Red Gate forums :: View topic - cluster: unreachable (cannot connect) openregistryhive
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

cluster: unreachable (cannot connect) openregistryhive

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



Joined: 11 Jul 2011
Posts: 9

PostPosted: Tue Mar 06, 2012 1:34 am    Post subject: cluster: unreachable (cannot connect) openregistryhive Reply with quote

----------------- Environment: -----------------
2 node cluster, call it C1. Call the nodes N1 and N2
2 instances, SQL1 and SQL2.
SQL1 is active on N1 and passive on N2
SQL2 is active on N2 and passive on N1

----------------- SQL Monitor Status -----------------

I added this "cluster" to SQL monitor by adding N1\* (NOT intuitive BTW). It picked up the cluster, the two nodes and the two instances.

SQL2 is marked as "monitoring, connected"
SQL1 is marked as "unreachable, cannot connect"

----------------- Checks I've performed -----------------

Clicking "show log" on SQL1 displays:

registry | openregistryhive:performancedata | cannot connect | win32 exception | the network path was not found

Clicking "all events" instead of just "errors" in the sql monitor log shows that ping, get server time, file system access, geterrorlogpath, etc, are all fine. But all openregistryhive is failing.

Remote registry service is enabled.

SQL Monitor account is a member of the administrators group on the cluster.

At command prompt, I ran: runas /netonly /user:(sql monitor account) "regedit"
Went to file: connect network registry, entered "N1", hit OK. Remote registry came up fine. Same for "N2".
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Wed Mar 07, 2012 2:49 pm    Post subject: Reply with quote

Thanks for your post.

For this kind of error I would normally recommend that you check each of the data collection methods we use as described in this document.

However, it looks like the most significant error is the remote registry error, and you've already checked that.

When you tried connecting to the nodes registry remotely, did you perform the test from the same machine where the SQL Monitor Base monitor is installed?

It might be worth restarting the remote registry service on the server in case it's just being a bit flaky.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
allmhuran



Joined: 11 Jul 2011
Posts: 9

PostPosted: Thu Mar 08, 2012 12:43 am    Post subject: Reply with quote

Thanks for the reply.

I have restarted the remote registry service on N1.

If I remote desktop to the server hosting SQL Monitor Base, log in using the SQL Monitor Base domain account, run regedit and connect network registry, I can successfully connect to both N1 and N2.

If I "retry connection" from within the monitored servers list it changes to "monitoring, connected" for about 2 seconds, then goes back to "unreachale", same underlying error.
Back to top
View user's profile Send private message
jonwilk



Joined: 09 Sep 2005
Posts: 18

PostPosted: Fri May 31, 2013 12:00 pm    Post subject: Reply with quote

i'm having exactly the same problem.

this cluster used to work fine for about 2 years and now suddenly won't work
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri May 31, 2013 12:16 pm    Post subject: Reply with quote

I'm not sure why this would happen. I would suggest logging a support ticket (support@red-gate.com) so it can be investigated.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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