Configure a Microsoft SQL Server relational connection
When you create a new connection to a Microsoft SQL Server database, a window appears where you specify the server, authentication, and database. You can modify this connection as needed.
-
If you are creating a new connection, the
Configure Microsoft SQL Server Connection appears after you complete the
Add New Connection window. If you are modifying an existing connection, open the
Configure Microsoft SQL Server Connection window
by following these steps:
-
On the
Project tab, in the
Configuration group, select
Project Settings
.
- Click the Databases tab to view the databases settings.
- Under Relational Connections, select the connection you want to change.
- Click Properties.
-
On the
Project tab, in the
Configuration group, select
Project Settings
-
In the
Server Name field, select or type the name of the server that contains the
database.
This field contains a list of all the servers on the local network. If a server on the network does not appear, click Refresh to update the list.
Note The search may take a few moments, depending on the size of your network. - In the Login Information group, select the authentication type, and then type a User Name and Password if applicable.
- In the Database name field, select the database on the server.
-
Optionally, you can review the
Connection String field.
This string shows the connection to the database and is defined by the other settings in this window. If you have specified a password, it is fully encrypted and cannot be viewed. You can edit the connection string as needed. If you change any of the options in the window, a new string is generated and overwrites any changes you made.
- Click Test Connection to verify that the connection works.
-
Click
OK.
If the connection succeeds, the Configure Microsoft SQL Server Connection window closes. If the connection fails, an error appears and the Configure Microsoft SQL Server Connection window remains open.
- Optionally, click OK to close the Project Settings window.
- Save the changes to your project.