Symptoms

adTempus logs an alert with message code 5123:

Database backup to file "C:\Program Files\Arcana Development\adTempus\instances\default\data\database\backup\adtempus_XXX.bak" failed: Cannot open backup device 'C:\Program Files\Arcana Development\adTempus\instances\default\data\database\backup\adtempus_XXX.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally. [ADT005123E]

Cause

The user account that the SQL Server service is running under does not have permission to write to the database backup directory.

Resolution

First identify the account that the SQL Server service (not the adTempus service) is running under. Typically the account will be "NT Service\MSSQL$ADTEMPUS". To confirm this, locate the "SQL Server (ADTEMPUS)" service in the Windows service manager and check to see what Log On account it uses.

Then, using Windows Explorer, edit the properties for the backup folder named in the error message (typically "C:\Program Files\Arcana Development\adTempus\instances\default\data\database\backup"). Grant Read and Write permissions on the folder to the SQL Server service account (e.g., "NT Service\MSSQL$ADTEMPUS").

More Information

To confirm that database backups are working correctly, select About from the Help menu in the adTempus Console and scroll down to the Server Diagnostic Details section. This section will contain information about the status of the backup (Enabled or Disabled), and information about the most recent backup created, or the most recent backup error encountered.