How to connect to database in sql server management studio

Posted on : 13-03-2012 | By : Devi Prasad | In : SQL Server Basics, SQL Server Management



Steps to connect to a database in SQL Server Management Studio (ssms)

In SSMS click on file – Connect to object explorer.

Connect Object Explorer

In the connect to server give the details of server name , login ID and password.

Connect to Server

Click on connect.

Note: Select the correct Authentication while connecting to the server. Contact your database administrator for details of the authentication that you have to use while connecting.

References : Devi Prasad (

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.

Write a comment