Ranjit Chavan
asked on
Nagios XI error "SQL Server message 297, severity 16, state 1, line 1:"
Hi,
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.
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.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Deepak,
Can you help me in knowing the "VIEW SERVER STATE " permissions , "VIEW database STATE" and DB_datareader role as i only know about serveradmin,sysadmin, setupadmin type of permissions.
and not the one you mentioned. Please help in how to provide these permission in MSSQL database
Can you help me in knowing the "VIEW SERVER STATE " permissions , "VIEW database STATE" and DB_datareader role as i only know about serveradmin,sysadmin, setupadmin type of permissions.
and not the one you mentioned. Please help in how to provide these permission in MSSQL database
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER