MSSQL server & query monitoring question

[JakeHatMacys]

I'm trying to set up monitoring for MSSQL server... And my connection options appear to be limited to Local Database IDs.

We want to tell the Monitors to use Active Directory to connect. Is this possible and or did I miss this in the configuration???

[lmiltchev]

The check_mssql_server.py plugin will NOT work with Windows Authentication and requires local SQL authentication.
You will have to setup a local account on the MSSQL server, set the user rights to DBO and give that user connect rights to the master database and the check should work for you.

[JakeHatMacys]

Okay, thanks for the prompt response.

For some reason they stopped creating local accounts... but we'll see what we can do.

[lmiltchev]

Sounds good! I will be locking this thread now. If you have any more questions/issues, please start a new one. Thank you!