From: admin@lists.myITforum.com [mailto:admin@lists.myITforum.com] On Behalf Of Nepal, Santosh
Sent: Wednesday, May 27, 2009 2:58 PM
To: msmom@lists.myitforum.com
Subject: [msmom] Cluster SQL instance discovery problem
We are unable to discover the SQL instances which reside on Virtual Servers within one of our cluster. This cluster is not on the same domain as the RMS but we have two way trust in place. We are able to discover both nodes of the cluster as well as all Virtual Windows Servers within that cluster. All virtual servers within the cluster are discovered under agentless systems. We keep seeing warning and information like below within both nodes of the cluster. What am I missing here? Thank you.
Event Type: Warning
Event Source: Health Service Modules
Event Category: None
Event ID: 10409
Date: 5/27/2009
Time: 12:48:07 PM
User: N/A
Computer: SQL3
Description:
Object enumeration failed
Query: 'SELECT * FROM MSCLUSTER_Resource where Name="mdtcsql2c"'
HRESULT: 0x80041013
Details: Provider load failure
One or more workflows were affected by this.
Workflow name: Microsoft.Windows.Cluster.Resource.StateMonitoring
Instance name: mpcsgmdtcsql2c
Instance ID: {63B2D331-3134-A55E-EBC9-DDE9264C7AB5}
Management group: PROD
******************************************************************
Event Type: Information
Event Source: Health Service Modules
Event Category: None
Event ID: 10403
Date: 5/27/2009
Time: 12:48:07 PM
User: N/A
Computer: SQL3
Description:
Module was able to connect to namespace 'ROOT\MSCLUSTER'
One or more workflows were affected by this.
Workflow name: Microsoft.Windows.Cluster.Resource.StateMonitoring
Instance name: SQL IP Address 1 (sql2c)
Instance ID: {3F986FED-B945-EAFF-1DC7-3D655C8AEBC3}
Management group: PROD
************************************************************************
Event Type: Warning
Event Source: Health Service Modules
Event Category: None
Event ID: 10409
Date: 5/27/2009
Time: 12:48:07 PM
User: N/A
Computer: SQL3
Description:
Object enumeration failed
Query: 'SELECT * FROM MSCLUSTER_Resource where Name="prd_db_backup"'
HRESULT: 0x80041013
Details: Provider load failure
One or more workflows were affected by this.
Workflow name: Microsoft.Windows.Cluster.Resource.StateMonitoring
Instance name: prd_db_backup
Instance ID: {28A6FFDB-8411-649B-1BD5-9F6036C02D77}
Management group: PROD
*******************************************************************
Event Type: Information
Event Source: Health Service Modules
Event Category: None
Event ID: 10403
Date: 5/27/2009
Time: 12:48:08 PM
User: N/A
Computer: SQL3
Description:
Module was able to connect to namespace 'ROOT\MSCLUSTER'
One or more workflows were affected by this.
Workflow name: Microsoft.Windows.Cluster.Resource.StateMonitoring
Instance name: SQL IP Address 1 (sql2c)
Instance ID: {2782289C-0A1E-11EB-A30A-28B776EC048B}
Management group: PROD
==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/momlist/
