Configure Microsoft SQL Server Connection window
Use this window to configure and test Microsoft SQL Server connection strings. Add a server using the following options:
- Server name
-
This option provides a list of all Microsoft SQL Servers on the local network.
Note 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. This is the default value for this option.
-
Enter the user name for the Kofax TotalAgility Server account.
- User Name
-
Enter the user name for the Kofax TotalAgility Server account.
This option is disabled when the Use Windows Authentication option is selected.
- Password
-
Enter the password for the User Name. This option is disabled when the Use Windows Authentication option is selected.
-
- Connect to a database
-
This group has the following option:
- Database name
-
Select the desired database from the available list.
Important 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 options in the window, a new string is generated and overwrites any changes you made.
In addition to the common Transformation Designer buttons, the following buttons are provided:
- Test Connection
-
This button tests the current connection string configuration.