Skip to main content
SQL discovery fails with ODBC SQL server errors
Updated over a week ago

This article applies to:

  • OS: Not applicable

  • Product edition: Phoenix

Problem description

SQL discovery fails while configuring the SQL backup with an ODBC error. The following scenarios that cause these errors are discussed in this article:


SQL server version may not be supported.


[2018-08-14 18:59:42,328] [INFO] Error[('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error (18) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECCreateCredentials()). (1)')] while connecting with instance [BACKUP01\DISCOVERY]


Refer the System requirements section of Phoenix documentation and install or upgrade to the supported SQL version


Any of the following may cause the SQL discovery to fail:

  • SQL cmd is not configured.

  • An error with sqlcmd.

  • TLS 1.0 is disabled.


The following traceback is logged for all the three causes mentioned above.

[2018-07-15 19:01:19,101] [INFO] Error[('08001', '[08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error (18) (SQLDriverConnect); [01000] [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()). (772)')] while connecting with instance [USCAW3-CLSECP01]


Verify if sqlcmd works as follows:

  1. Launch the command prompt on the server.

  2. Run sqlcmd to check if SQL cmd is configured.

  3. If the command returns an error, rectify the issue and retry the backup operation.

If TLS version 1.1 or 1.2 is used and TLS 1.0 is disabled:

  • Install SQL Server Native Client driver 11.0 is installed.
    In absence of the driver, SQL backups fail even if TLS 1.1 or 1.2 is enabled.


Insufficient permission to access the SQL server


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


Assign sysadmin permissions to the NT\Authority account to enable access to the SQL database to be backed up. The permissions enable Phoenix to access and back up the database successfully.

Did this answer your question?