Sensor status is connected but DBMS status is disconnected for MSSQL DBMS on Database Security Console
Last Modified: 2022-10-20 12:46:56 Etc/GMT
Affected Products
Languages:
This article is available in the following languages:
Trellix CEO, Bryan Palma, explains the critical need for security that’s always learning.
As per Gartner, "XDR is an emerging technology that can offer improved threat prevention, detection and response."
Trellix announced the establishment of the Trellix Advanced Research Center to advance global threat intelligence.
Trellix Advanced Research Center analyzes threat data on ransomware, nation-states, sectors, vectors, LotL, MITRE ATT&CK techniques, and emails.
As of May 14, 2024, Knowledge Base (KB) articles will only be published and updated in our new Trellix Thrive Knowledge space.
Log in to the Thrive Portal using your OKTA credentials and start searching the new space. Legacy KB IDs are indexed and you will be able to find them easily just by typing the legacy KB ID.
Sensor status is connected but DBMS status is disconnected for MSSQL DBMS on Database Security Console
Technical Articles ID:
KB96088
Last Modified: 2022-10-20 12:46:56 Etc/GMT Environment
Database Activity Monitoring (DAM) 4.x
Problem
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 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... Cause
These messages show that the connection to the DBMS instance can't initialize the SQL native client. The sensor fails to establish a permanent connection to the DBMS instance.
Solution
Affected ProductsLanguages:This article is available in the following languages: |
|