Red Gate forums :: View topic - Issues with Monitored Server connections v3.4.1.4
Return to www.red-gate.com RSS Feed Available

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

Issues with Monitored Server connections v3.4.1.4

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JoeGT



Joined: 13 Jun 2012
Posts: 40

PostPosted: Wed Jun 12, 2013 4:58 am    Post subject: Issues with Monitored Server connections v3.4.1.4 Reply with quote

I am having issues with connectivity to some of the SQL instances that I monitor in a UAT environment (I have the same version of SQL Monitor 3.4.1.4 - running without issue in two production environments)

The specs in this problem UAT environment

Base Monitor - Hosted on node 1 of a two node SQL failover cluster (I would ideally like to have this reside on a remote server but I dont yet have the hardware available to do this)

I use a domain account (that is a member of the Administrators group on all monitored servers and also a "sysadmin" SQL login on all instances I want to monitor) to run the Base Monitor connections


The issues I am seeing that using this Base Monitor account I have the following

Stand alone SQL server and instance

- no issues with connection

2 Node SQL Cluster

- Connection Failed to parent cluster node and then to the instance that is hosted on this server

Date Group Event Outcome Exception Exception message
12/06/2013 3:47 WMI OpenNamespace: Root\MSCluster Internal SQL Monitor 3 error ManagementException User credentials cannot be used for local connections


- Connection successful to both host servers in this cluster as well as the second SQL instance (which is NOT hosted on the base monitor server)



Is the issue that I cant have the Base Monitor running on a host server that belongs to an SQL cluster and use domain account credentials ? Or is there something more simple that I am missing that will solve this one for me ?

Cheers

Joe
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 921
Location: Red Gate Software

PostPosted: Fri Jun 14, 2013 9:56 am    Post subject: Reply with quote

Hi

Thank you for your forum post.

This entry indicates a WMI problem:
Quote:
Date Group Event Outcome Exception Exception message
12/06/2013 3:47 WMI OpenNamespace: Root\MSCluster Internal SQL Monitor 3 error ManagementException User credentials cannot be used for local connections


Can you please run through the tests for the data collection methods as per this help ARTICLE?

Hopefully the tests will help you identify the cause and how to rectify the problem.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
JoeGT



Joined: 13 Jun 2012
Posts: 40

PostPosted: Wed Jun 19, 2013 12:06 am    Post subject: Reply with quote

Hi Eddie

I have followed the instructions in your link to check WMI. (minus the screenshots)

Testing WMI

At the command prompt, run:
wbemtest

In the Windows Management Instrumentation Tester dialog box, click Connect.

In the Namespace box, type \\myserver.example.com\root\cimv2 where myserver.example.com is the name of the
Windows server you are attempting to monitor.

Under Credentials, enter the Windows account you are using to monitor the server and the password. This is the account listed under Credentials on the Monitored serverspage in SQL Monitor (Configuration > Monitored servers).

Click Connect.
Click Query and enter the following query:
SELECT Name FROM Win32_Service
Click Apply. You should see a list of results similar to those shown below:

If connection fails and an "Access Denied" error message is displayed, see WMI Troubleshooting and WMI Isn't Working!.



I get exactly the same issue when I try these tests with the error:

"User credentials cannot be used for local connections"


So back to my question - is the issue that I cant have the Base Monitor running on a host server that belongs to an SQL cluster and use domain account credentials ie. the base monitor is running on the instance that I am monitoring and that instance is the member of a cluster.

Cheers

Joe
Back to top
View user's profile Send private message
JoeGT



Joined: 13 Jun 2012
Posts: 40

PostPosted: Mon Jun 24, 2013 4:46 am    Post subject: Reply with quote

Can I please get an update on this question or a ticket logged ?
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 327
Location: Cambridge, UK

PostPosted: Mon Jul 01, 2013 2:22 pm    Post subject: Reply with quote

Eddie has asked me to take a look at your question.

Basically SQL Monitor is unable to support the monitoring of a cluster when it is installed on a node of that cluster.

The technical reason for this is a bit complicated, but boils down to the fact that WMI contains a bug which SQL Monitor encounters when it monitors the local machine. It contains logic which identifies this scenario and does some special stuff to ensure that WMI will work, but when this local machine is part of a cluster, it is not possible to differentiate between the local cluster details and the local machine details and so WMI is subject to the original problem which the logic tries to overcome.

Unfortunately, this means that the only workaround is install on a separate standalone machine.

I hope this makes sense. Please let me know if you have any questions.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
JoeGT



Joined: 13 Jun 2012
Posts: 40

PostPosted: Mon Jul 01, 2013 10:42 pm    Post subject: Reply with quote

Thanks for the reply Chris

I thought it might come down to something like this.

I will have to look at moving the base monitor setup to a server that is not part of the cluster.

Cheers

Joe
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