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.
The following buttons are available at the bottom of this window:
|
Button |
Description |
|---|---|
| Test Connection |
Tests the connection string configuration to ensure that its settings are correct. |
| OK |
Closes the window and saves your changes. |
| Cancel |
Closes the window without saving your changes. |
 Help
|
Displays the help for the open window. |
Related topics: