Skip to main content

How can we help you?

Druva Documentation

Troubleshooting SQL server issues

The following topic lists some of the issues that you might encounter, and the solutions or workarounds that you can use to resolve these issues.

Unable to discover SQL databases

Hybrid Workloads agent is unable to discover databases, and displays the following error:
[2022-03-30 12:37:16,707] [ERROR] Error[('08001', u'[08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error (18) (SQLDriverConnect); [08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()). (772)')] while connecting with instance [AMZOESSQL01] using SQL Server driver
[2022-03-30 12:37:16,710] [ERROR] Error[('IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')] while connecting with instance [AMZOESSQL01] using SQL Server Native Client driver
[2022-03-30 12:37:16,710] [ERROR] SyncError: Phoenix SQL agent found no instance/database on the server to backup or the SQL service is not running or the backup content is set to exclude all the databases.
[2022-03-30 12:37:16,710] [INFO] Error[Phoenix SQL agent found no instance/database on the server to backup or the SQL service is not running or the backup content is set to exclude all the databases. (#100030006) (Error Code : SQL6)] while getting product info for instance [AMZOESSQL01]
[2022-03-30 12:37:48,790] [ERROR] Error[('08001', u'[08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error (18) (SQLDriverConnect); [08001] [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()). (772)')] while connecting with instance [AMZOESSQL01] using SQL Server driver
[2022-03-30 12:37:48,790] [ERROR] Error[('IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')] while connecting with instance [AMZOESSQL01] using SQL Server Native Client driver
[2022-03-30 12:37:48,790] [ERROR] SyncError: Phoenix SQL agent found no instance/database on the server to backup or the SQL service is not running or the backup content is set to exclude all the databases.
[2022-03-30 12:37:48,792] [INFO] Error[Phoenix SQL agent found no instance/database on the server to backup or the SQL service is not running or the backup content is set to exclude all the databases. (#100030006) (Error Code : SQL6)] while getting product info for instance [AMZOESSQL01]
[2022-03-30 12:37:48,792] [DEBUG] sql discovery info ={'cluster_name': '', 'instances': {}, 'discovery_node_name': ''}
[2022-03-30 12:37:48,793] [INFO] Killing SQL Client discovery Instance

Cause

This error occurs as TLS 1.2 is not enabled on the server where the agent is installed.

Resolution

Enable TLS 1.2 and make sure that TLS 1.0/1.1 is disabled.

 

  • Was this article helpful?