OleDbProbe: Results Error

Question

hi guys,

i am getting a OldEbProbe Error alert from SCOM 2019 management server

*****OleDb Module encountered a failure 0x80004005 during execution and will post it as output data item. Unspecified error
: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.*****

instance name: System Center Data Warehouse.

some time back i have enabled TLS 1.2 only in SCOM 2019, so i guess it is causing this.

could you guide me to fix the connection issue between the DB and mgmt server.

thx
Sarav

Answer 1

To Close the thread, We just need to use the MOMCertImport.exe tool to load the certificate into the SCOM agent which in turn update the registry settings. Once imported. you will see the Channel Certificate Serial Number.

do a reg query for the below path:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Machine Settings

now you will see the Cert details in the SCOM Management Pack ( https://github.com/thekevinholman/SCOM.Management ). You can download the mgmt pack from Kevin Holman's github site.

Answer 2

Hi @Saravanan Balasubramanian ,

If you have enabled TLS 1.2 in your SCOM environment I suggest you make sure that your SCOM environment has been correctly implemented with TLS 1.2.

You can start with Kevin's blog post here:
Implementing TLS 1.2 enforcement with SCOM

There's a script on the above link that will check things for you, I suggest you read through the whole post and go through it step-by-step.

Also make sure your SQL Server supports TLS 1.2:
TLS 1.2 support for Microsoft SQL Server

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Best regards,
Leon