Configure Microsoft SQL Server Connection window

Use this window to configure and test Microsoft SQL Server connection strings. Add a server using the following settings:

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.

Refresh

Use this button to update the list if a new server is added to the network.

Login Information

Choose one of the following authentication types:

• Use Windows Authentication. (Default: Selected)

• Use SQL Server Authentication.

User Name

Enter the user name for the SQL Server account.

This setting is disabled when the Use Windows Authentication setting is selected.

Password

Enter the password for the User Name. This setting is disabled when the Use Windows Authentication setting is selected.

Connect to a database

This group has the following setting:

Database name

Select the desired database from the available list.

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.

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.

In addition to the common Project Builder buttons, the following buttons are provided:

Test Connection

This button tests the current connection string configuration.