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:
Launch the command prompt on the server.
Run
sqlcmdto check if SQL cmd is configured.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.