Access issue on MSSQL_server.py

[siriideepak]

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.

[scottwilkerson]

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

Code: Select all

-p 1433

[siriideepak]

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

[scottwilkerson]

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