I'm implementing database monitoring for ms SQL server's . i'm able to retrive information for check
"MSSQL Connection Time"
Ok 1h 1m 41s 1/5 2015-07-16 13:38:54 OK: Time to connect was 0.00798416137695s" with same credential i'm getting error for below plugin:
master MSSQL Database Size
error----> "Unknown 1h 10m 42s 5/5 2015-07-16 13:38:56 SQL Server message 297, severity 16, state 1, line 1:"
Does anybody knows this check will work with read only permission or no.
Any idea what permissions we should use while setting up nagios monitoring for mssql database, server and query.
I'm new to ms-sql , please help.