Monitor Stop, cannot auto reconnect

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Monitor Stop, cannot auto reconnect

Postby xexex » Mon Oct 28, 2013 3:08 am

For some reasons, we don't give ddl_admin to SQL Monitor role and we know that the trace off is DBCC Showconfig fail to run.

However, SQL Monitor stop monitoring every Monday morning due to permission issue, I've followed the instruction from red-gate to edit"RedGate.Response.Engine.Alerting.Base.Service.exe.settings.config" but it doesn't help.
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am

Postby chriskelly » Tue Oct 29, 2013 1:58 pm

Thank you for your post.

Please can you send a copy of the configuration file to support@red-gate.com and quote the support ticket reference number #6647. Please can you also confirm where you got the instructions for the configuration change from as it is possible that you used an out of date version. The URL of any document would be great.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby xexex » Thu Oct 31, 2013 8:23 am

Thanks for reply, I've sent the email with config file.

I got the information here:
http://www.red-gate.com/supportcenter/c ... omatically
xexex
 
Posts: 41
Joined: Thu Jun 24, 2010 5:50 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests