Database Credentials

Specify the database credentials that adTempus will use to connect to the database. The account you specify must have read, write, and backup permissions for the database but does not need to be an administrator or database owner.

Database Credentials

Select the authentication type for the connection to SQL Server.

Windows Authentication

Choose Windows Authentication to use integrated security for the database connection. To use this option, the LocalSystem account on this computer must be granted the necessary login and database permissions on SQL Server.

In adTempus 3 and earlier, you could change the adTempus service to run under a user account instead of LocalSystem, and grant the necessary database access to that account. This configuration is no longer fully supported: adTempus must run under the LocalSystem account for all adTempus features to be available. More information.

If SQL Server is located on the same computer as adTempus, make the necessary security changes in SQL Server to grant permissions to the LocalSystem account.

If SQL Server is running on a different computer, additional configuration is required, and the SQL Server Computer Account page (see below) will be displayed when you click Next.

SQL Server Authentication

Choose SQL Server Authentication to connect using a user ID and password. To use this option, your SQL Server must be configured to allow SQL Server authentication.

If the account you want adTempus to use already exists, specify the user ID and password here.

Otherwise, adTempus can create the account for you, or you can copy the script shown at the bottom of the page and use it to create the account.

SQL Server Computer Account

If you are using Windows authentication for SQL Server, and SQL Server is running on a different computer than adTempus, you must create a machine login in SQL Server for the computer on which adTempus is running.

This is necessary because adTempus runs under the special LocalSystem account that is specific to the computer on which adTempus is running. Were you to grant permissions to "LocalSystem" in SQL Server, that would only grant permissions to the LocalSystem account on the database server itself, not to the LocalSystem account on the adTempus computer.

You may have adTempus create the necessary account for you, or you may review the script that adTempus generates and execute it yourself.