NetProbe - Why am I seeing an SSL Security Error in my SQL-Toolkit Windows sampler
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 Copied
Possible Cause 1 Copied
The DBA has disabled TLS 1.0 on the Microsoft SQL Database server and enabled TLS 1.2.
Possible Cause 2 Copied
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 Copied
Possible Solution 1 Copied
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 Copied
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.
