[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

11/06/2009 at 08:58AM PST, ID: 24878512 | Points: 500
[x]
Attachment Details

SQL Server 2008 Enterprise Cluster errors

Asked by Moonpiejen in Microsoft Applications, SQL Server 2008, Windows Server 2008

Tags: Microsoft Server Enterprise 2008 R2, Microsoft SQL Server 2008 Enterprise

I have a 2 node cluster running in Node and Disk Majority mode.  We have a witness disk, a MSDTC disk and 3 disks for the SQl cluster.  I'm able to successfully simulate failures and all services/apps failover.  Also I can manually move from one node to another without problems.

One node we run validation on and we get zero errors.  The other node we run validation on and it fails.  We get these errors:

Failed to arbitrate for cluster disk 3 from node xxxxxxx.xxxxxxxx.com, failure reason: The RPC server is unavailable.

Failed to arbitrate for cluster disk 2 from node xxxxxxx.xxxxxxx.com, failure reason: The RPC server is unavailable.

The validation doesn't always fail though, sometimes we get warnings such as these:
Validating cluster resource SQL Server.
This resource is marked with a state of 'Offline'. The functionality that this resource provides is not available while it is in the offline state. The resource may be put in this state by an administrator or program. It may also be a newly created resource which has not been put in the online state or the resource may be dependent on a resource that is not online. Resources can be brought online by choosing the 'Bring this resource online' action in Failover Cluster Manager.
Validating cluster resource SQL Server Agent.
This resource is marked with a state of 'Offline'. The functionality that this resource provides is not available while it is in the offline state. The resource may be put in this state by an administrator or program. It may also be a newly created resource which has not been put in the online state or the resource may be dependent on a resource that is not online. Resources can be brought online by choosing the 'Bring this resource online' action in Failover Cluster Manager.


Any ideas to what could be causing this?  Thanks for any help
[+][-]11/07/09 04:07 PM, ID: 25768744

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/07/09 04:30 PM, ID: 25768817

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/07/09 05:32 PM, ID: 25768977

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/08/09 03:18 PM, ID: 25772506

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/09/09 10:52 AM, ID: 25778763

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/10/09 04:15 PM, ID: 25791408

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/10/09 05:43 PM, ID: 25791736

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625