Monitoring Microsoft SQL Connection Issue

[AndyPIlgrim]

**CMK version:2.3.0p24
**OS version: Windows Server 2016

I am trying to set up Monitoring of Microsoft SQL Instance and Databases and have gone through the steps listed on this page Monitoring Microsoft SQL Server and its not working. I am getting this error when i run a service discovery on the host (Note; I have removed Domain, User and Server names)

Failed to connect to database ([SQL LOGIN ERROR] Token error: ‘Login failed for user ‘DOMAIN\USERNAME’.’ on server SERVERNAME\TSSANDYP executing on line 1 (code: 18456, state: 1, class: 14))CRIT, Version: 15.0.2000.5 - Developer Edition (64-bit)

I have checked the domain user we are using can access the server and it can. I have check it using MSSMS and it logs in and can connect to the databases.

I am a bit stuck now on where to go? Does anyone have any advice where to look or how to get this to work as it seems the CheckMK documentation is not providing the full information required.

Any help would be appreciated.

[robin.gierse]

@AndyPIlgrim

Does anyone have any advice where to look or how to get this to work as it seems the CheckMK documentation is not providing the full information required.

It goes without saying, but I am going to say it anyways: Obviously do we not withhold information on how to enable proper monitoring. Ever.
Your error clearly points towards authentication, so you might to try and run the plugin manually on the affected system and see, if the behavior changes somehow. Also check the SQL server logs, if they provide any insights.