Table of Contents
[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