CODEWITHSUNDEEP
javasql-serversql-server-2005
Y.E.P
Y.E.P

Reputation: 1207

connecting to the database engine in Microsoft SQL Server 2005

I had to connect my netbeans application to Microsoft SQL Server 2005 so that I am able to read the data back to application (after I store it !) . But I haven't been able to create a table yet since I am able to connect to the database engine as it says.

How do I connect to the database engine in Microsoft SQL Server 2005 ? This is what it currently displays when I open Microsoft Server SQL Management Studio :

enter image description here

and this is the SQL Server Configuration Manager :

enter image description here

Now what do I do to connect to the database engine ?

Note : Please let me know if I need to add some more information

Upvotes: 1

Views: 3135

Answers (2)

ron tornambe
ron tornambe

Reputation: 10780

Right-click on the Database Engine and click "connect". You will need to supply the IP address (or Server Name) of the SQL Server you wish to connect to. Choose SQL Server Authentication (unless you environment supports Windows Authentication) and enter your password. No password is requried if using Windows Authentication.

HTH

Upvotes: 1

Vikdor
Vikdor

Reputation: 24134

You create tables through your management studio through File -> New -> Database Engine Query and provide the server name, user name and password. This will open an SQL editor where you can USE <your DB> and start creating tables.

You can also register your DB server to avoid entering the authentication details every time, in the management studio. Once you register your server, test the connection, you can open it in Object Explorer or open a Query window directly etc.,

To connect to this database from a Java program, you need Microsoft SQL JDBC driver (jTDS is also a good JDBC driver for SQL server) and a tutorial on how to use Java JDBC API to connect to SQL server from Java programs.

Hope this is useful.

Upvotes: 1

Related Questions