I’m using Check_MK to monitor an MSSQL cluster. It all worked fine when using 1.6.x. After I did an upgrade to 2.0.0p3 it does not work anymore. When I run a check on the command line this is the result I get for the MSSQL service:
MSSQL_MSSQLSERVER|state|0|Connecting using provider msoledbsql. ERROR: Provider cannot be found. It may not be properly installed. Connecting using provider sqloledb. ERROR: Login failed for user ‘’. ERROR: Login failed for user ‘’. (SQLState: 42000/NativeError: 18456). Connecting using provider sqlncli11. ERROR: Login failed for user ‘’. ERROR: Login failed for user ‘’. (SQLState: 28000/NativeError: 18456).
It’s true I don’t have a user setup, so no mssql.ini. In the 1.6 release, this would work with just the local system account that is used to run the check_mk agent. To be more precise, if I switch back the mssql.vbs script to the 1.6 version it works again.
Any chance for a fix in the 2.0 version of the mssql.vbs script?