We are trying to setup SQL monitoring for a server running in Azure. DB ports are opened and it is able to connect to the DB using SQL Client. Also telnet is successful. However, we are getting 'probe has to be started for connection test' error during the connection test.
The probe is started, and this issue only happens for a specific server, as other SQL servers can be tested.
In the probe logs we see:
sqlserver: (NimCryptographerCfgKeyReadEncryptedValue) failed to decrypt value. RC=3
sqlserver: Profile: test connection profile/test connection checkpoint/Connect - COM Error: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error
- TLS was not set to 'Enabled' for the connection.
Release : 20.3
Component : UIM - SQLSERVER (any version)
- TLS 1.2 support for sqlserver is supported as of v5.30 or higher.
Most likely the server hosting the SQL Server that is contacted requires TLS 1.2 for the connection.
In the probe connection detail, enable the use TLS checkbox and try again.