Welcome > Use the Transformation Designer > Manage Databases > Relational Databases > Configure a Microsoft SQL Server Relational Connection

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.

  1. 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:
    1. On the Project tab, in the Configuration group, select Project Settings Project Settings icon.
    2. Click the Databases tab to view the databases settings.
    3. Under Relational Connections, select the connection you want to change.
    4. Click Properties.
  2. 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.
  3. In the Login Information group, select the authentication type, and then type a User Name and Password if applicable.
  4. In the Database name field, select the database on the server.
  5. 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.

  6. Click Test Connection to verify that the connection works.
  7. 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.

  8. Optionally, click OK to close the Project Settings window.
  9. Save the changes to your project.