The below error may occur if you are running the SQL-Toolkit plug-in on a Windows probe querying an MS SQL Server database.
ERROR: SQL-TOOLKIT Fail - [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.(18)
Possible Causes
Possible Cause 1
The DBA has disabled TLS 1.0 on the Microsoft SQL Database server and enabled TLS 1.2.Possible Cause 2
The DBA has turned on encryption for database connections. Please check Microsoft SQL Server documentations as encryption may become enabled by default for newer installations.Possible Solutions
Possible Solution 1
Please check the existing SQL client libraries on the Netprobe machine are up to date and support SQL Server side TLS versions. If TLS 1.2 is required then the below link may help in checking for updated version.https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe
Possible Solution 2
Please check that the Netprobe is at version GA6.4 (COL-11601) or above.In Gateway Setup Editor, user should review the SSL Configuration section at the Basic tab for the SQL-Toolkit plugin. Please liaise with the company DBA to match the settings at the Microsoft SQL Server.
Comments
0 comments
Please sign in to leave a comment.