OMC: Supporting TLS 1.2 when monitoring Microsoft SQL Server with the Cloud Agent 1.55 or Higher
(Doc ID 2788304.1)
Last updated on JULY 06, 2021
Applies to:Oracle Management Cloud
Microsoft Windows x64 (64-bit)
With the release of OMC Cloud Agent version 1.55, TLS 1.0 and 1.1 protocols will no longer be supported by default for JDBC connections.
JDBC connections are used by the Cloud Agent for connecting to and monitoring Microsoft SQL Server.
If you are currently monitoring SQL Server with a Cloud Agent of version 1.54 or earlier, before you upgrade your Cloud Agent to 1.55, make sure you have configured and upgraded SQL Server to support TLS 1.2 protocol for JDBC connections.
Refer to the following Microsoft Support note for details:
If you have not updated SQL Server for TLS 1.2 connections and you upgrade the Cloud Agent to version 1.55, the monitoring of SQL Server will be disrupted and may result in metric collection errors, and/or showing the SQL Server entity as down.
You will also not be able to successfully add a new SQL Server database for monitoring: you will likely see these types of errors in the agent log files:
“Unable to connect to database using specified properties. Reason: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document