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.
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:
resolve the issue, follow the steps below.
the Connect to Server window, make sure you have the correct server name
for your course. Then click on the Options >> button.
the Connection Properties tab, click on the drop-down arrow in the Connect
to database: field and select <Browse server…>
the next window, click Yes
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.
the Connect to Server window, click the Connect button.
- You are now connected to the server.
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.