Red Gate forums :: View topic - Retry Connection after Monitoring Stopped
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

Retry Connection after Monitoring Stopped

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Go to page 1, 2  Next
Author Message
ScottHerbert



Joined: 07 Oct 2011
Posts: 13
Location: Canberra

PostPosted: Tue Jan 03, 2012 11:47 pm    Post subject: Retry Connection after Monitoring Stopped Reply with quote

Hi,

Is there a way to configure an amount of time after which SQL Monitor will attempt to reconnect to a server which has become unreachable?

We are monitoring a SQL2008R2 Failover Cluster which sits on clustered Server 2008R2 servers.

When a physical (i.e. Windows Server) failover occurs, we get "Machine Unreachable" and monitoring stops. I'd like to see SQL Monitor retry the connection say 10 minutes later, rather than waiting for me to notice and re-enable the next day.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Wed Jan 04, 2012 12:26 pm    Post subject: Reply with quote

Hi Scott,

SQL Monitor keeps trying to connect after every monitoring error including 'Unreachable', 'Connection failed' except when it is 'Monitoring stopped (Incorrect credentials or insufficent permission)'. The reason SQL Monitor doesn't try to connect after 'Monitoring stopped (Incorrect credentials or insufficent permission)' is that we dont want to fill security log with failed login. If you have a intrusion detection system in your environment then it may get triggered because of that.

But having said this, we do have a workaround for that i.e. SQL Monitor will keep trying to connect even after 'Monitoring stopped (Incorrect credentials or insufficent permission)'. Though we do not recommend this but I will send you detail in email. You can then decide whether you would like to make this change for your environment or not. If you do not receive my email in next 1/2 hour then please let us know.

Thanks,
Priya
Back to top
View user's profile Send private message
ScottHerbert



Joined: 07 Oct 2011
Posts: 13
Location: Canberra

PostPosted: Wed Jan 04, 2012 11:00 pm    Post subject: Reply with quote

Thanks Priya, that makes sense as to why it's been implemented like that.
Back to top
View user's profile Send private message
niehrx



Joined: 26 Jan 2012
Posts: 3

PostPosted: Thu Jan 26, 2012 4:37 pm    Post subject: Reply with quote

Hi Scott,

I have the same case as priyasinha. It would be best if it would automatically reconnect because we are using email alert. how can it raise an email alert if monitoring stopped?

Can you send to me the workaround for this too?

Thanks.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Thu Jan 26, 2012 5:55 pm    Post subject: Re: Reply with quote

niehrx wrote:
Hi Scott,

I have the same case as priyasinha. It would be best if it would automatically reconnect because we are using email alert. how can it raise an email alert if monitoring stopped?

Can you send to me the workaround for this too?

Thanks.


Hi,

I have emailed you just now.

Thanks,
Priya
Back to top
View user's profile Send private message
Chrish



Joined: 30 Jun 2011
Posts: 9
Location: Cambridgeshire

PostPosted: Thu Feb 02, 2012 10:30 am    Post subject: Reconnect Reply with quote

Hi Priya,

We are also experiencing similar problems to Scott. Intermittently the remote server login credentials will fail and return 'Monitoring stopped (Incorrect credentials or insufficent permission)', when we try and reconnect seconds later it is fine so I think your workaround will work for our scenario.

Please could you e-mail me the workaround as well?

Many thanks,

Chris.
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Thu Feb 02, 2012 11:40 am    Post subject: Reply with quote

Hi Chris

I've emailed you some instructions.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
Chrish



Joined: 30 Jun 2011
Posts: 9
Location: Cambridgeshire

PostPosted: Tue Feb 07, 2012 1:27 pm    Post subject: Re: Reply with quote

Chris Spencer wrote:
Hi Chris

I've emailed you some instructions.

Regards
Chris


Hi Chris,

Received the e-mail.

Many thanks for your help.

Cheers,

Chris.
Back to top
View user's profile Send private message
Irina



Joined: 02 Mar 2012
Posts: 1

PostPosted: Fri Mar 02, 2012 6:26 pm    Post subject: Reply with quote

Hi Priya,
We are having the same issue.
Could you also send me the work around?

Thanks,
Irina
Back to top
View user's profile Send private message Send e-mail
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Fri Mar 02, 2012 6:37 pm    Post subject: Re: Reply with quote

Irina wrote:
Hi Priya,
We are having the same issue.
Could you also send me the work around?

Thanks,
Irina


Email has been sent.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
SQLWhat



Joined: 15 Mar 2012
Posts: 1

PostPosted: Thu Mar 15, 2012 4:36 pm    Post subject: Reply with quote

Hi All,
I am having these exact same issues. I thought it was a DNS problem at first and modifying the hosts file for all monitored servers worked for a little bit but it seems to be doing it again.

Could I be sent the instructions as well?

Thank you,
Bruce
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Thu Mar 15, 2012 4:42 pm    Post subject: Re: Reply with quote

SQLWhat wrote:
Hi All,
I am having these exact same issues. I thought it was a DNS problem at first and modifying the hosts file for all monitored servers worked for a little bit but it seems to be doing it again.

Could I be sent the instructions as well?

Thank you,
Bruce


Email sent

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
Random Lengths



Joined: 29 Sep 2008
Posts: 25
Location: Eugene, OR

PostPosted: Tue Mar 20, 2012 4:31 pm    Post subject: Monitoring stopped on reboot? Reply with quote

I wonder if I'm having the same problem: Every time I reboot the SQL Server (for maintenance) The monitor stops, and never restarts. It certainly isn't invalid credentials since it's just a reboot, so I'm really doubting it's still trying 10 minutes later.

I would like these instructions as well, if you think this is my issue.

Thanks,
Dan
Back to top
View user's profile Send private message
devdtd



Joined: 30 Mar 2012
Posts: 1

PostPosted: Fri Mar 30, 2012 3:25 pm    Post subject: Can I get the instructions as well ? Reply with quote

Can I get the instructions as well ? I am having the same issues .

Thank you


donald.dixon@ttx.com
Back to top
View user's profile Send private message
Chris Spencer



Joined: 29 Aug 2006
Posts: 301
Location: Red Gate - Cambridge

PostPosted: Fri Mar 30, 2012 3:34 pm    Post subject: Re: Monitoring stopped on reboot? Reply with quote

Random Lengths wrote:
I wonder if I'm having the same problem: Every time I reboot the SQL Server (for maintenance) The monitor stops, and never restarts. It certainly isn't invalid credentials since it's just a reboot, so I'm really doubting it's still trying 10 minutes later.

I would like these instructions as well, if you think this is my issue.

Thanks,
Dan


Email sent. Apologies for the delay.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page 1, 2  Next
Page 1 of 2

 
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