MS SQL ODBC Backup Fails: Permission Denied for Database

April 16, 2025

Product Version

AhsayOBM: 7 and above

Operating System

Windows

Symptom

When performing a MS SQL database backup (ODBC backup mode), the following warning message is received in the backup report:

No.TypeTimestampLog
*infoYYYY/MM/DD hh:mm:ss[Start] Backing up "SQL_hostname\MSDB\db_name" ... to "temp_path"
*warnYYYY/MM/DD hh:mm:ss[Microsoft][ODBC SQL Server Driver][SQL Server] BACKUP DATABASE permission denied in database 'db_name'.

Cause

The message suggests that AhsayOBM does not have permission to access the affected database.

Resolution

To resolve the issue, ensure that the sa account login credentials are correct (if SQL Server and Windows Authentication mode is used), and the operating system account specified in the Windows User Authentication setting has permission to access the affected database.

Login credentials to Microsoft SQL Databases for AhsayOBM

Troubleshooting
    #ws-chat { position: fixed !important; bottom: 110px !important; /* Move up so it doesn't overlap Live Chat */ right: 30px !important; /* Adjust as needed */ z-index: 10001; } /* Example: Ensure Live Chat stays at the bottom */ #livechat-box { position: fixed !important; bottom: 30px !important; right: 30px !important; z-index: 10000; }