Validating cluster resource analysis services
We need to assign the Virtual Server Name and Instance Name properties of the SQL Server Agent resource to match those of the SQL Server resource.
In my environment, the Virtual Server Name property is SQLCLUS and the Instance Name is MSSQLSERVER since I am using a default instance.
To do this, run the from the SQL Server 2008 R2 installation media and click the Maintenance link on the left-hand side.
You can then click the Repair link to run the repair process. NOTE: Make sure that you run the repair process on the node that does not own the SQL Server cluster resource group, or in other words, the passive node.
To fix the SQL Server Agent resource on the clustered resource group, you need to perform the following steps below: NOTE: These steps can be performed either via the Failover Cluster Manager, or Windows Power Shell.
This is the same as adding the SQL Server service as a dependency to the SQL Server Agent service in a stand-alone instance.
Using the Failover Cluster Manager, click on the Advanced Policies tab of the SQL Server Agent Properties dialog box to see the list of Possible Owners.