Until recently this worked ok, however now on one of the 2 nodes if I fail over SQL all of the services start, on the other node, Sql Server Agent & Analysis Services will not come on line. I have checked some of the other links suggestiing fixes but
they dont seem to apply. On the Node where it fails you get an error 53 for the server agent the Analysis Services fails with Generic service 'Analysis Services' could not be brought online (with error '1060') during an attempt to open the service. Possible
causes include: the service is either not installed or the specified service name is invalid.
attached is the details from the Sql Log
2011-04-06 13:13:32.05 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
2011-04-06 13:13:32.05 Server (c) Microsoft Corporation.
2011-04-06 13:13:32.05 Server All rights reserved.
2011-04-06 13:13:32.05 Server Server process ID is 4744.
2011-04-06 13:13:32.05 Server System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge R610'.
View Complete Post