Page 1 of 1
MSSQL server & query monitoring question
Posted: Mon Mar 07, 2016 11:29 am
by 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???
Re: MSSQL server & query monitoring question
Posted: Mon Mar 07, 2016 1:07 pm
by 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.
Re: MSSQL server & query monitoring question
Posted: Mon Mar 07, 2016 1:22 pm
by JakeHatMacys
Okay, thanks for the prompt response.
For some reason they stopped creating local accounts... but we'll see what we can do.
Re: MSSQL server & query monitoring question
Posted: Mon Mar 07, 2016 1:46 pm
by lmiltchev
Sounds good! I will be locking this thread now. If you have any more questions/issues, please start a new one. Thank you!