Microsoft SQL ODBC Backup "BACKUP DATABASE permission denied in database"

6 Mar, 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.	Type	Timestamp	Log
*	info	YYYY/MM/DD hh:mm:ss	[Start] Backing up "SQL_hostname\MSDB\db_name" ... to "temp_path"
*	warn	YYYY/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.