Skip to main content

How can we help you?

Druva Documentation

How to give permissions to the system user in SQL Management Studio when Phoenix SQL backup fails with permission issue

This article applies to:

  • OS: SQL Management Studio
  • Product edition: Phoenix

Overview

When the SQL backup job fails due to permission issue, you can see the errors like SQL7 or SQL8.  You will see the below error message in the job log.

{snippet}
[2017-06-12 16:08:51,595] [ERROR] Discover databases pyodbc error: ('08004', '[08004] [Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\\SYSTEM" is not able to access the database "ReportServer$MSSQL2014" under the current security context. (916) (SQLExecDirectW)')
[2017-06-12 16:08:51,608] [ERROR] Discover databases pyodbc error: ('08004', '[08004] [Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\\SYSTEM" is not able to access the database "model" under the current security context. (916) (SQLExecDirectW)')
{snippet}

Provide system user permission on SQL Management Studio

  1. Remote log on to the SQL Server where you have installed the Phoenix Agent.
  2. Open SQL Server Management Studio.

    OpenSQLMgmtStudio.png
  3. Connect the SQL instance which is installed on the SQL Server and log on to the SQL Server.

    ConnectSQLinstance.png
  4. Go to Security > Logins.

    SecurityLogins.png
  5. Right-click on NT AUTHORITY\SYSTEM and select Properties. This opens the Login Properties window.

    AuthoritySystem.png
     
  6. Select Server Roles and from the Server roles list on the right, select sysadmin.
  7. Click OK to confirm the roles selected for System account.

See also

Phoenix for MS-SQL servers system requirements.