Database Connection Settings
The information that adTempus uses to connect to its SQL Server database is set by the Database Configuration Wizard. You may need to review these settings when troubleshooting a service startup problem, or change them when you move the database.
The settings are stored in the Registry under the following key:
HKEY_LOCAL_MACHINE\SOFTWARE\Arcana Development\adTempus\Instances\Default\Database
If you are working with an instance other than the default, replace "Default" with the instance name.
Settings
| Value | Description |
| server |
The name or IP address of the computer where SQL Server is running, optionally followed by the name of a named SQL Server instance (e.g., "dbserver1\instance1"). If SQL Server is on the same computer as adTempus, use "." rather than the computer name. For the SQL Server Express instance installed with adTempus, the value is ".\ADTEMPUS". |
| database | The name of the adTempus database. By default this is "adTempus_computername", where computername is the name of the computer where adTempus was installed. |
| authenticationType | The method used to authenticate with SQL Server. See SQL Server Authentication. |
| userID | The user ID, if adTempus connects using SQL Server (user ID and password) security. If this value is not present, adTempus uses Windows integrated security, connecting as the computer account of the adTempus computer (see SQL Server Computer Account). |
| EncryptedPassword | The encrypted password for the user ID. |
| password | Used only to set a new password manually (see below). When the service starts, it encrypts this value, saves it as EncryptedPassword, and deletes the password value. |
Changing the Settings
The recommended way to change the settings is to run the Database Configuration Wizard, which verifies the connection and makes any other changes that are needed.
You can also edit the Registry values directly. To change the password, delete the EncryptedPassword value and create a String value named "password" containing the new password. Changes take effect the next time the adTempus service starts.
Before changing the settings, export the Database key from the Registry Editor so that you can restore the original settings if there is a problem.