Skip to main content
Druva Documentation

SQL discovery fails with ODBC SQL server errors

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:

Cause-1

SQL server version may not be supported.

Traceback

[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]

Resolution

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

Cause-2

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.

Traceback

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] 

Resolution

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. 

Cause-3

Insufficient permission to access the SQL server

Traceback

 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)')]

Resolution

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.