Print

How to Connect to SQL Server

To manipulate database, a client should connect to the server. We can connect to the SQL Server in two way with Windows authentication or SQL server authentication. 

 

Windows authentication: In this model we use a windows user account to establish a connection with the server. This user accounts will be created and controlled by system administrator. 

SQL server authentication: In this method we use a database user account to establish the connection. They will be created and controlled by the Database administrator(DBA).

Step One:

obtain SQL server name or IP address information. Generally speaking, Database administrators provide the information. If you have access to the server, you can get the information by remote into the database. In this screenshot below, database server name is "WIN-SM-Test" and Ip address is 192.168.1.13

Step Two (a) : Connect with Server name

Launch SQL Server Management Studio on the client machine and click on the "connect" in Object Explorer window. 

Step Two (b) : enter Server name, Login and Password information and click on the "connect button". 

Step Two (C) : check the connection result.

when connection is established, you can see various database objects by expanding Database folder in Object Explorer. In this example below, we see that AdventureWork2008 has been installed on the database server. 

Alternatively, we can connect by using IP address of the sql server. See the screenshot below. 

Step three (a) : enter IP address for Server name, Login and Password information and click on "connect" button. 

Step three (b) : check the connection result. 

when connection is established, you can see various database objects by expanding Database folder in Object Explorer. In this example below, we see that AdventureWork2008 has been installed on the database server.