stops monitoring every saturday @1AM

Monitor, diagnose and receive alerts to problems across your SQL Servers.

stops monitoring every saturday @1AM

Postby jbreien » Mon Oct 17, 2011 8:25 am

Every monday for the past month i´ve had to reconnect on a number of servers that are monitored, but not all of them....

the logfile in sqlmonitor shows:
User "sqlmonitor" does not have permission to run DBCC SHOWCONTIG for database 'msdb'.

as mentioned, a simple reconnect and everything is peachy, but its alarming that i lose surveillance every weekend...

in my test cluster, 4 out of 6 sql instances have "monitoring stopped" and 6 out of 8 on my production cluster!

all the windows servers in the cluster are still monitored though...

the permissions for the surveillance account are set up the same for all instances....

Any ideas ?
Posts: 4
Joined: Tue Aug 16, 2011 1:40 pm
Location: Stockholm

Postby priyasinha » Mon Oct 17, 2011 2:02 pm


I would suggest sending all the log files to especially from around the time this error happens.

Posts: 549
Joined: Wed Jan 03, 2007 4:02 pm

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests