Skip to main content
All CollectionsKnowledge BaseEnterprise WorkloadsHow To - Enterprise Workloads
How to give permissions to the system user in SQL Management Studio when Phoenix SQL backup fails with permission issue
How to give permissions to the system user in SQL Management Studio when Phoenix SQL backup fails with permission issue
Updated over 10 months ago

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

Did this answer your question?