BACKUP DATABASE permission denied in database (MS SQL database backup)

Article ID

2074

Product Version

AhsayOBM: 8 or above

Operating System

Windows

Symptom

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

No.	Type	Timestamp	Log
info
*	info	...	[Start] Backing up "SQL_hostname\MSDB\db_name" ... to "temp_path"
warn
*	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.

For AhsayOBM v9.11 and above, backup sets created using SQL Server Authentication as its authentication type can bypass this issue if Windows User Authentication is turned on and the supplied Windows login credentials does not have permission to access the affected database by either turning Windows User Authentication off or by simply ensuring that the supplied SQL login credentials have the necessary permissions .

However, having invalid SQL login credentials — or simply an account with no access permissions to the affected database — will always result in a backup job encountering this error, regardless if Windows User Authentication is turned on or if the supplied Windows login credentials have the necessary permissions.