Symptoms
After SSL 3 and TLS 1.0 are disabled on the adTempus server or your database server, the adTempus service fails to start and logs an error message similar to the following:
Cause
This happens because the SQL Server OLEDB database driver that adTempus uses by default does not support TLS 1.2.
Resolution
To resolve this problem you must install a different database driver on the computer, and configure adTempus to use that driver. Two new drivers are available, and one or both may already be on your server. If not, you can install either.
Option 1: Microsoft OLE DB DRIVER for SQL Server
Note: This driver may not be available for older operating systems (e.g., Windows Server 2008).
Install the Microsoft OLE DB Driver for SQL Server on the adTempus server.
Then configure adTempus to use this driver:
- Run the Registry Editor and go to key "HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus\Database".
- Edit the "ConnectionString" value and replace "SQLOLEDB" with "MSOLEDBSQL".
adTempus should now be able to connect to the database.
Option 2: SQL Server Native Client
The SQL Server Native Client can be installed as part of the SQL Server 2012 Feature Pack and is also included in other SQL Server packages from Microsoft.
Then configure adTempus to use this driver:
- Run the Registry Editor and go to key "HKEY_LOCAL_MACHINE\Software\Arcana Development\adTempus\Database".
- Edit the "ConnectionString" value and replace "SQLOLEDB" with "SQLNCLI11".
adTempus should now be able to connect to the database.
