Summary
This article discusses the settings that adTempus uses to connect to a SQL Server database. These settings are made automatically when you run the adTempus SQL Server migration/configuration tool. In some cases you may need to review or modify the settings.
Description of Settings
The information adTempus uses to connect to a SQL Server database is found in the Registry key "HKEY_LOCAL_MACHINE\SOFTWARE\Arcana Development\adTempus\Instances\Default\Database". (If you are using a named instance of adTempus, replace "Default" with the instance name.)
The following values may be present under this key:
| server |
Specifies the name or IP address of the computer where SQL Server is running, and, optionally, the name of a named instance of SQL Server. If SQL Server is on the same computer as adTempus, specify the server name as ".". For the adTempus instance of SQL Server Express, specify the server as ".\adtempus". |
| database | Specifies the name of the database used by adTempus. This database must have been created by the Database Configuration Wizard. |
| userID |
The user ID to use if adTempus is connecting using SQL Server security. You must also specify the password. To use integrated security (automatic Windows authentication), remove the userID value. If you want to use SQL Server (password) security, remove "; Integrated Security=SSPI" from the ConnectionString and set the UserID and Password values. |
| password |
The password for the user account. To set or change the password, delete the "encryptedPassword" value (if present) and create a STRING value named "password" containing the new password value. When the adTempus service is started, it will remove the "password" value and create the "encryptedPassword" value. |
| encryptedPassword | The encrypted value of the password. |
Changing Settings
To change settings you can update the Registry directory or use the Database Configuration Wizard.
Changes take effect the next time the adTempus service is started.
More Information
More information on using adTempus with SQL Server can be found in the Database Installation and Configuration topic in the online help.
