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 begin

Before you can configure a Microsoft SQL Server relational connection, verify that you have already created a connection to a relational database.

Procedure
  1. 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.

  2. 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.

  3. 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.

  4. Optional. Select OK to close the Project Settings window.
  5. Save the changes to your project.