Red Gate forums :: View topic - stops monitoring every saturday @1AM
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

stops monitoring every saturday @1AM

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jbreien



Joined: 16 Aug 2011
Posts: 4
Location: Stockholm

PostPosted: Mon Oct 17, 2011 9:25 am    Post subject: stops monitoring every saturday @1AM Reply with quote

Every monday for the past month ive 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 ?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Mon Oct 17, 2011 3:02 pm    Post subject: Reply with quote

Hi,

I would suggest sending all the log files to support@red-gate.com especially from around the time this error happens.

Thanks,
Priya
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group