CMK version: 2.2.0p46
OS version: Window Server 2025
Error message: Failed to connect to database (INFO: Connecting using provider msoledbsql; Connecting using provider sqloledb; Connecting using provider sqlncli11 ;; ERROR: Der Provider kann nicht gefunden werden. Möglicherweise ist er nicht richtig installiert worden.) CRIT
Output of “cmk --debug -vvn hostname”: (If it is a problem with checks or plugins)
Description: The MSSQL plugin (mssql.vbs) fails when executed by the CheckMK agent (running as SYSTEM), but works correctly when executed manually via PowerShell as a local Administrator.
The SQL Server instance is a named instance running SQL Server 2022 Express (not default). SQL Server Browser service is running.
The following OLE DB providers are installed on the system (verified via 32-bit and 64-bit PowerShell):
-
MSOLEDBSQL
-
MSOLEDBSQL19
-
SQLOLEDB
When running the script manually as Administrator, the plugin outputs data correctly for all sections (mssql_databases, mssql_connections, mssql_jobs, etc.).
Adding a SQL Server login for NT AUTHORITY\SYSTEM with sysadmin role did not resolve the issue.
Has anyone else experienced this issue with SQL Express specifically, or found a solution? Any hints are greatly appreciated! 