Comments
Sort by recent activity
No - we still had this issue.
Without sysadmin - role the Monitoring doesnt work.
Hope that Red-Gate can help with an solution. / comments
No - we still had this issue.
Without sysadmin - role the Monitoring doesnt work.
Hope that Red-Gate can help with an solution.
Hi Adam
thanks for your answer.
Unfortunately i am not able to figure out which are the specific flags : sysadmin role required for Integrity check overdue alerts and to allow SQL Monitor to turn on the deadlock trace flag (this flag is required for Deadlock alerts to be raised; you can turn on the flag manually if you don't want to enable sysadmin permissions).
We are monitoring a 2 node AlwaysOn Cluster with 4 Instances.
In every Instance the following Commands were executed :
GRANT VIEW ANY DEFINITION TO [xxxxxyyyyyyyyyyyyyy]
GRANT VIEW SERVER STATE TO [xxxxxyyyyyyyyyyyyyy]
GRANT VIEW DATABASE STATE TO [xxxxxyyyyyyyyyyyyyy]
But i still got the error (after removing the sysadmin role from the monitoring account) :
IntegrityCheckSampler Incorrect credentials or insufficient permissions SqlException User 'xxxxxyyyyyyyyyyyyyy' does not have permission to run DBCC DBINFO.
Could you please explain how to disable the IntegrityCheckSampler ?
SQLMonitor - Version below Version 6 was running fine over the last 2 years without the sysadmin - role.
regards, Frank / comments
Hi Adam
thanks for your answer.
Unfortunately i am not able to figure out which are the specific flags :sysadmin role required for Integrity check overdue alerts and to allow SQL Monitor to turn on...
The idea was to query the SQL Monitor Database where the values are still persisted ;-). / comments
The idea was to query the SQL Monitor Database where the values are still persisted ;-).
Hi Alex
not my preferred opinion but thanks for the hint.
Handling with CSV Export / Import is time consuming manual work and thats not what im looking for.
regards, Frank / comments
Hi Alex
not my preferred opinion but thanks for the hint.
Handling with CSV Export / Import is time consuming manual work and thats not what im looking for.
regards, Frank