Using a Standalone SQL Server Instance

adTempus can use an existing SQL Server or Azure SQL Database server to host its database. SQL Server may be running on the same computer as adTempus, or on a remote computer. SQL Server 2005 and later are supported.

Information in this topic refers to the Database Installation and Configuration program, which is the program that configures SQL Server and adTempus. This program is run either by the adTempus setup program, or manually, at a later time.

Installation Requirements

The Database Installation and Configuration program must be run with sufficient authority to create databases and users on the SQL Server. When you run the program, therefore, you must either be logged in under a Windows account that has system administrator authority for SQL Server, or have a system administrator user ID and password that the tool can use.

SQL Server must be running.

Azure SQL Database Considerations

To host the database on an Azure SQL Database server, you must create the empty database using the Azure Management Portal or another tool. In the configuration wizard, supply the server name and the name of the existing database. The setup program will populate the database with the necessary tables and other objects.

Security Setup

If SQL Server is on the same computer as adTempus, you can generally use Integrated (Windows) security, which means that adTempus can connect to the database without an explicit user ID and password. This is possible because the adTempus service runs under the SYSTEM account, which is a member of the Administrators group on the computer, which by default has system administration authority for SQL Server.

If you have changed SQL Server security settings such that members of the computer's Administrators group do not automatically have system administration authority in SQL Server, you will need to either make the necessary changes to allow the SYSTEM account full control over the adTempus database, or enable SQL Server security and have adTempus use that.

If SQL Server is on a different computer from adTempus, you must use one of the following approaches:

• Enable SQL Server security on the server and allow adTempus to use that instead
• Configure SQL Server to grant permission to the adTempus server's computer account

The Database Configuration Wizard will help you with the necessary settings for either option.

Hosting Multiple adTempus Instances

If you are installing adTempus on several servers, you can use a single SQL Server instance to host the databases for all of the adTempus instances. However, each instance of adTempus must have its own separate database on the server.

The Database Installation and Configuration program handles this automatically, by including the name of the adTempus server in the database name. For example, you have installed adTempus on three servers: ServerA, ServerB, and ServerC. You will use the SQL Server on ServerX to host the databases for all three adTempus installations. When you run the database migration tool, it will create the databases "adTempus_ServerA," "adTempus_ServerB," and "adTempus_ServerC."

Database Backups

By default adTempus does not back up the adTempus database when you are using a standalone SQL Server instance. You can configure adTempus to create a daily backup in the Server Options window if the database is not included in another backup policy.