adTempus can use an existing SQL Server to host its database. SQL Server may be running on the same computer as adTempus, or on a remote computer. SQL Server 2000 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.
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.
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, integrated security cannot be used because the SYSTEM account that adTempus runs under has no authority on the remote computer. For adTempus to connect to SQL Server, you must use one of the following approaches:
Enable SQL Server security on the server and allow adTempus to use that instead. This is the default approach used by the migration tool: if you specify a remote database server, the migration tool will assume you are using explicit security, and will create a SQL Server login for adTempus to use. If SQL Server has not been configured to allow explicit security, adTempus will fail to start.
Change the adTempus service to run under a user account instead of the SYSTEM account.
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".
adTempus does not automatically back up the adTempus database when you are using SQL Server. You (or your SQL Server system administrator) are responsible for ensuring that the adTempus database is backed up in accordance with your backup policies.