Unable to Connect to SQL Server in SQL Server Management Studio

This document will outline the steps to connect to the SQL Server in SQL Server Management Studio when you get a connection error.

When launching SQL Server Management Studio, you are prompted to connect to a server. After selecting your server name and clicking on the connect button, you get the following error message:




To resolve the issue, follow the steps below.
  1. In the Connect to Server window, make sure you have the correct server name for your course. Then click on the Options >> button.



  2. Under the Connection Properties tab, click on the drop-down arrow in the Connect to database: field and select <Browse server…>



  3. In the next window, click Yes



  4. In the Browse Server for Database window, select the database you will be using for your course. Note: If you are unsure what database to select, you can select the master database as your default database. Click OK to save your selection.



  5. In the Connect to Server window, click the Connect button.



  6. You are now connected to the server.


If you are still having issues connecting to the SQL server, please contact us by phone at 1-877-724-7883 or submit a ticket on our website.