Nagios Support Forum

I have a MSSQL Server 2008 and using to monitor this by MSSQL Server wizard. For this i have created a "testuser" in SQL with public access and Read only permission.
when im trying to configure Received " CRITICAL:unable to access SQL server".
In command also, i have tried ./check_mssql_server.py -H 192.168.10.10 -U 'testuser' -P 'test@123' -I 'Share_test' -p 1433 --pageplits --warning 20 critical 30
CRITICAL:unable to access SQL server


Is this related to Privilege issue, what level of previlege should be given to the "testuser" for fetching the information??.

Thanks in advance.


Regards,
Deepak.

Usually if you are connecting to an instance you would not include the

Hi,

Thanks for your update, I gave system admin user privilege to that query after it shows results. Correct me if i am wrong, for this query required any specific privilege. If i gave public it shows CRITICAL:can access server but not query. Pls clarify...

Regards,
Deepak.P

User needs server level permissions of "Connect SQL" and "View server state." Also needs database level permissions of "Connect" and "Select".