<div>
Best practice is to let the Cluster service handle SQL Server service and SQL Agent Service. They should both be set to manual startup on each cluster node, so that the cluster service can start them on the active node at boot or at failover.<br />
<br />
Anytime you remove a resource from a group or application that is a dependency of something, then that something will be grumpy. <br />
<br />
In fact, in order for SQL Server to be able to see Disk X, then Disk X must be a dependency of SQL Server in a clustered scenario.
</div>


Best practice is to let the Cluster service handle SQL Server service and SQL Agent Service. They should both be set to manual startup on each cluster node, so that the cluster service can start them on the active node at boot or at failover.

Anytime you remove a resource from a group or application that is a dependency of something, then that something will be grumpy.

In fact, in order for SQL Server to be able to see Disk X, then Disk X must be a dependency of SQL Server in a clustered scenario.

<div>
First to answer. Just got to the answers this morning. &nbsp; Thanx
</div>


First to answer. Just got to the answers this morning.   Thanx

<div>
<div class="content wysiwyg-content">
We have a cluster with resources shared. We needed to reconfigure one of the resources so we cleared out the data on the drive, all was fine. Removed the resource and sql server service and agent stopped. Should this have happened? These services are set to manual on one server and automatic on the other in the cluster. What is best parctice for the configuration of these services on the servers in the cluster? This is a two node cluster running windows 2008R2 with SQL 2008 R2. 
</div>
</div>


We have a cluster with resources shared. We needed to reconfigure one of the resources so we cleared out the data on the drive, all was fine. Removed the resource and sql server service and agent stopped. Should this have happened? These services are set to manual on one server and automatic on the other in the cluster. What is best parctice for the configuration of these services on the servers in the cluster? This is a two node cluster running windows 2008R2 with SQL 2008 R2. 

SQL Services

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.