You see a Sensor status of connected in the Database Security Console. But, the DBMS status for MSSQL DBMS is reported as disconnected, as opposed to the expected Fully Monitored.
You see the following errors in
logfile.log when you extract the Windows Sensor Analytic Package:
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[OledbAdapter.cpp] L[318] WARNING Failed to connect, Error 0x80004005, can't connect to <DBMS Instance name>Error code: 18, Description: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error., Source: Microsoft OLE DB Provider for SQL Server
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[OledbAdapter.cpp] L[577] ERROR Connect with our user failed
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[OledbAdapter.cpp] L[621] WARNING Failed to connect using all methods
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[OledbAdapter.cpp] L[1580] WARNING Failed to establish permanent Connection to database [DBMS Instance name]
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[DalMSSQL.cpp] L[214] NOTICE Failed to send retry-operation [OpenPermanentConnectionFailed] messages to Evaluator
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[OledbAdapter.cpp] L[72] INFO initPropertiesAndGetInterface
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[OledbAdapter.cpp] L[86] INFO tlsDriverEnabled is set to [false]
XXXX-XX-XX XX:XX:XX.XXXXXX P[XXXX] T[4976] F[OledbAdapter.cpp] L[104] INFO Could not initialize SQL Native Client, falling back to SQL OLE DB...
