Symptoms

When you attempt to use a SQL Server 2000 database server for the adTempus database, the Database Installation and Configuration Wizard fails with the following error:

Error:	Line 17: Incorrect syntax near '('.
Database creation failed

Cause

This error occurs because the database creation script uses some statements that are only compatible with SQL Server 2005 and later.

Resolution

This issue has been corrected in the current adTempus installation package.