Article ID: 9525
Reviewed: 01/03/2023

Product Version:
AhsayOBM: 9
OS: Windows

When performing a MS SQL database backup, the following warning message is displayed in the backup report:

This issue can occurs if the Windows account running the backup job is not found in the affected MS SQL server's Security Logins, or if the account does not have the sysadmin and public Server Roles.

You can check by looking at the SQL ERRORLOG file at

${database_folder}\MSSQLog

Check if there may be error such as the following (e.g. the log entries around the time of the warning displayed in backup report):

To resolve the issue, perform the following steps:

1. Open the SQL Server Management Studio.
   
   
2. Under Object Explorer, select Security:
   
   
   
   
3. Select Logins, check if the Windows user that you are running the backup job with is there under Logins:
   
   
   
   
   • If the account is there, confirm if the public and sysadmin Server Roles have been assigned to the account (e.g. Right click, Properties, Server Roles).
     
     
   
   
   • If the account is not there, add the account, then assign the public and sysadmin Server Role to it (e.g. Right click, New Login).