User Tools

Site Tools


Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

public:5298_sql_database_permission_denied

[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

public/5298_sql_database_permission_denied.txt · Last modified: 2021/12/16 06:15 by anna.olalia

Page Tools