=====[V7] ISSUE: BACKUP DATABASE permission denied in database (MS SQL database backup) ===== Article ID: 5298
Reviewed: 2018-02-02

Product Version:
AhsayOBM: Post-7.3.0.0
OS: Windows ATTENTION 1st January, 2022: v7 officially End-of-Life [details] ===== Problem Description ===== 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	...	[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.

===== Keywords ===== sql, odbc, permission, deny, denied, sufficient, in-sufficient, enough, mssql