SQL Server Express

When you choose the SQL Server Express option, the database configuration tool will install SQL Server Express, then create the adTempus database.

If necessary you may change the location where SQL Server program files should be installed. These files should not be placed in the adTempus installation directory.

Leave the Show SQL Server installation progress window box checked to see detailed progress information displayed by the SQL Server setup program during installation. This is recommended, as the SQL Server installation process can be lengthy.

Click Next to continue to the Select Actions page. All actions will be selected on this page, which will be appropriate for most installations.

Click Next, then Next again to begin setup.

At this time, the setup program will install SQL Server Express, create and initialize the adTempus database, and start the adTempus service using the new database.

If this process fails for any reason, review the error messages for more information, and contact technical support. The adTempus software will remain installed, but you will not be able to start the adTempus service until the database is successfully installed and configured. Uninstalling and reinstalling the adTempus software will not resolve the problem.

Allowing Remote Connections

The SQL Server Express instance installed by adTempus allows only local connections. If you need to connect to the database from another computer (for example, to query it using SQL Server Management Studio), you can enable remote connections.

This allows users on other computers to query the adTempus database directly. Consider the security implications before making this change.

  1. Log in as an Administrator to the computer where the adTempus service is installed.
  2. Run SQL Server Configuration Manager.
  3. Expand SQL Server Network Configuration, then select Protocols for ADTEMPUS.
  4. Right-click TCP/IP and select Enable.
  5. Using the Windows Services tool, restart the "SQL Server (ADTEMPUS)" service. This also requires restarting the adTempus service.
  6. Change the startup type of the "SQL Server Browser" service to "Automatic" and start it if it is not running.
  7. Configure your firewall to allow incoming connections to SQL Server (TCP port 1433 by default, and UDP port 1434 for the SQL Server Browser).

Granting Access to Users

By default only the user who installed SQL Server Express and members of the Administrators group can connect to it. To allow other users to connect, create SQL Server logins for them. For example, to grant read-only access to a user, run the following script using the Database Utility, replacing USERNAME with the user's Windows user ID (e.g., "corpdomain\bobw") and DATABASENAME with the name of the adTempus database:

use [master]
GO
if not exists (select * from master.dbo.syslogins where loginname = N'USERNAME')
CREATE LOGIN [USERNAME] FROM WINDOWS with DEFAULT_DATABASE=[DATABASENAME]
GO
use [DATABASENAME]
GO
if not exists (select * from dbo.sysusers where name = N'USERNAME' and uid < 16382)
    CREATE USER [USERNAME] FOR LOGIN [USERNAME] WITH DEFAULT_SCHEMA=[dbo]
GO
exec sp_addrolemember N'db_datareader', N'USERNAME'
GO

When connecting from another computer, specify the server as "computername\ADTEMPUS". See Database Connection Settings to find the database name.

Related Concepts

Database Installation and Configuration