Symptoms
When you use the adTempus job wizard to create a job that runs a SQL Server job, the job fails when run against a SQL Server 2005 database. The job log contains an error message similar to the following:
Failed to connect to SQL Server: [Microsoft][ODBC SQL Server Driver][SQL Server]To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO). (55555)
Cause
The job wizard generates a script that uses the SQL Server DMO ActiveX component to connect to the database and run the job. SQL Server 2005 uses a different library to provide script access, and is not compatible with the DMO library used by earlier SQL Server versions.
Workaround
For adTempus to connect to SQL Server 2005 using the generated script, you must install the SQL Server 2005 Backward Compatibility Components, available from Microsoft at www.microsoft.com/downloads/details.aspx?FamilyId=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en (look for the "Microsoft SQL Server 2005 Backward Compatibility Components" and download the X86 package). These components must be installed on the computer where adTempus is running.
