Configure a Microsoft SQL Server relational connection
Use the procedure in this topic to configure a Microsoft SQL server relational connection.
When you create a new connection to a Microsoft SQL Server database, a window is displayed where you specify the server, authentication, and database.
Before you can configure a Microsoft SQL Server relational connection, verify that you have already created a connection to a relational database.
-
In the
Configure Microsoft SQL Server Connection window, configure the following settings.
Setting
Description
Server Name
This setting provides a list of all Microsoft SQL Servers on the local network.
The search may take a few moments, depending on the size of your network.
Use the Refresh button to update the list when a new server is added to the network.
Login information
Select one of the following authentication types:
-
Use Windows Authentication
-
Use SQL Server Authentication
For more information about relational database authentication, see Relational database authentication
User Name / Password
These settings are available only when Use SQL Server Authentication is selected.
Enter the user name and password for the Tungsten TotalAgility Server account.
Database name
Select the database from the list of available databases.
Connection String 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 settings in the window, a new string is generated and overwrites any changes you made.
-
-
Select
Test Connection to verify the connection works.
If you are unable to successfully test a Microsoft SQL Server connection, you are unable to add that database connection. This ensures you do not add a faulty database connection. Retry your settings and test again.
-
Once the test is successful, select
OK.
If the connection succeeds, the Configure Microsoft SQL Server Connection window closes. If the connection fails, an error is displayed and the Configure Microsoft SQL Server Connection window remains open.
- Optional. Select OK to close the Project Settings window.
- Save the changes to your project.