Skip to main content
All CollectionsKnowledge BaseEnterprise WorkloadsTroubleshooting - Enterprise Workloads
Troubleshooting SQL T-Log backup failure with exit code Phoenix 318
Troubleshooting SQL T-Log backup failure with exit code Phoenix 318
Updated over 11 months ago

Problem description


SQL T-Log backup fails with exit code Phoenix 318.

Cause

This issue can occur if the account under which Phoenix Agent client service is running does not have sysadmin permissions over the database.This issue can occur if the account under which Phoenix Agent client service is running does not have sysadmin permissions over the database.

Traceback

  1. Follow the instructions in the Logs article and obtain the job logs.

  2. Extract the logs and go through the Phoenix<YYYYMMDD>_<timestamp>.log file to determine if the following traceback is present in the logs.

    [2020-03-04 15:39:51,621] [ERROR] <_MainThread(MainThread)> SqlStream::open_vdi_handle() vdilib error occured: ('08004', u'[08004] [Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\\SYSTEM" is not able to access the database "ngfddata" under the current security context. (916) (SQLExecDirectW)')

    [2020-03-04 15:39:51,621] [ERROR] <_MainThread(MainThread)> Error <class 'pyodbc.OperationalError'>:('08004', u'[08004] [Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\\SYSTEM" is not able to access the database "DBNAME" under the current security context. (916) (SQLExecDirectW)'). Traceback -Traceback (most recent call last):

    File "agents\sqlserver\VssHelper.pyc", line 52, in open_vdi_handle

    File "agents\sqlserver\VdiHelper.pyc", line 99, in open

    File "agents\sqlserver\sql_vss_2.pyc", line 288, in get_database_type

    File "agents\sqlserver\sql_vss_2.pyc", line 333, in __execute_sql_query_list

    OperationalError: ('08004', u'[08004] [Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "NT AUTHORITY\\SYSTEM" is not able to access the database "DBNAME" under the current security context. (916) (SQLExecDirectW)')

Resolution

Grant the sysadmin permission to the account under which Phoenix Agent Client service is running.

How to grant the sysadmin permission

  1. Login to the SQL Server Management Studio and connect to the SQL database.

  2. In the SQL Server Management Studio, in the Object Explorer, navigate to Security > Server Roles > sysadmin

  3. Right click sysadmin and select Properties.

  4. In the Server Role Properties - sysadmin dialog box, determine if the credential which is added in the Phoenix credential store and assigned to the virtual machine is listed under the Members of this role section. If it is not listed, proceed to step 5.
    ​

    Picture28.png

  5. In the SQL Server Management Studio, in the Object Explorer, navigate to Security > Logins. Locate the credential which is assigned to the virtual machine from the Phoenix credential store. Right-click this credential, and select Properties.

  6. In the Login Properties dialog box, in the left pane, click Server Roles.
    ​

    Picture29.png

  7. In the right pane, select sysadmin and click OK.

Related Articles
How to give permissions to the system user in SQL Management Studio when Phoenix SQL backup fails with permission issue
Database discovery fails on SQL server and server doesn’t get registered under “All SQL Resources” in the Phoenix console
SQL backups fail with snapshot error PHOENIX54
SQL discovery fails with ODBC SQL server errors
SQL Log backup fails with the error SQL8: Database is already open and can only have one user at a time
Did this answer your question?