Red Gate forums :: View topic - Why Does SQL Monitor Try To Log Into DB during Maint Window?
Return to www.red-gate.com RSS Feed Available

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

Why Does SQL Monitor Try To Log Into DB during Maint Window?

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Thu Feb 20, 2014 6:07 pm    Post subject: Why Does SQL Monitor Try To Log Into DB during Maint Window? Reply with quote

I have a maintenance window defined on my SQL Monitor 4.1.1 instance for 10 minutes starting at 2:00AM. Today I find that SQL Monitor is not monitoring because its attempt to login was denied and thats because it tried to login at 2:02AM during the defined maintenace window.

Am I missing something or is the maintenance window used for telling SQL Monitor when it should not try to access the SQL Server(s) it is monitoring?
Back to top
View user's profile Send private message
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Thu Feb 20, 2014 6:18 pm    Post subject: Reply with quote

Nervermind. I just remebred having this exact same issue with SQL monitro 3 and I'm fairly certain with SQL Monitor 2. Since we upgrade once every 1-2 years I had forgotten about this little quirk.

I assume SQL Monitor is built with teh assumption that the SQL Servers its monitors will never go off line or down and so if it fails to connect the you have to manually force it to re-try the login or edit the 'reconnectAfterAuthorizationError' setting located in the 'RedGate.Response.Engine.Alerting.Base.Service.exe.settings' file. At least that was the solution for SQL Monitor 3 so I assume its the same for version 4 but if thats wrong please reply.
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 86

PostPosted: Fri Feb 21, 2014 11:36 pm    Post subject: Reply with quote

Hi Ed,

It shouldn't be trying to connect during the maintenance window at all, so that's a bit strange, but the 'reconnectAfterAuthorizationError' solution should solve it regardless.

It might also be worth setting the maintenance window for a few minutes longer to check if that could solve the problem.

Hope that helps.

Thanks,
Evan
_________________
Evan Moss
Product Support
(866) 627-8107
Back to top
View user's profile Send private message Send e-mail
EdCarden



Joined: 25 Nov 2008
Posts: 90

PostPosted: Thu Mar 06, 2014 5:52 pm    Post subject: Re: Reply with quote

Evan Moss wrote:
Hi Ed,

It shouldn't be trying to connect during the maintenance window at all, so that's a bit strange, but the 'reconnectAfterAuthorizationError' solution should solve it regardless.

It might also be worth setting the maintenance window for a few minutes longer to check if that could solve the problem.

Hope that helps.

Thanks,
Evan


Evan,

Updating the reconnectAfterAuthorizationError value in the config file is what stopped this Alert from being raised again. We reboot the system regularly and not once has this alert been raised during the maintenance window since I changed reconnectAfterAuthorizationError in that file.

Ed
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