How do I Connect to a Database using SQL Server Management Studio?

Start SQL Server Management Studio. Please refer to Microsoft if you need a copy of SQL Server Management Studio, The current version, SQL Server Management Studio 2012, is compatible with MS SQL 2005, 2008, and 2012. Fill in the database connection information:

Server Name: the name or IP of the database server. Type PORT after the IP or name to specify a different port (e.g. “,2433″).

Authentication: SQL Server Authentication is listed by default.

Login: Your username you have set up for the database.

Password: Your password you have set up for the user.

Connect to SQL Server

To connect to a specific database only, click on the Options button. Click on the Connection Properties tab. Type in the name of the database. Please note it is required that you specify the database for most MS SQL 2012 connections. Click Connect. If you need any assistance with this process, or encounter any issues, please don’t hesitate to contact our Technical Support Department.