<div>
To be more specific, our DBA needed to stop the SQL SERVER AGENT service. He stopped it through Enterprise Manager. When he did this all resources in the cluster group failed over to the next node. Our DBA did not know why this happened and said he had stopped the service this way before and the cluster had not failed over, but the the SQL Server Agent service stopped.<br />
The check box is set to Restart but has not changed. <br />

</div>


To be more specific, our DBA needed to stop the SQL SERVER AGENT service. He stopped it through Enterprise Manager. When he did this all resources in the cluster group failed over to the next node. Our DBA did not know why this happened and said he had stopped the service this way before and the cluster had not failed over, but the the SQL Server Agent service stopped.
The check box is set to Restart but has not changed.


<div>
One would have to review the cluster log from time that event occurred, but suspect that service was in use and when stopped the cluster could not restart the resource so it restarted the group on the secondary node.
</div>


One would have to review the cluster log from time that event occurred, but suspect that service was in use and when stopped the cluster could not restart the resource so it restarted the group on the secondary node.

<div>
Does it matter where the SQL Server Agent service is stopped/started/restarted on a cluster? <br />
From where should the SQL Server Agent be controlled on a cluster? <br />
Where should all SQL services be controlled from on a cluster?
</div>


Does it matter where the SQL Server Agent service is stopped/started/restarted on a cluster?
From where should the SQL Server Agent be controlled on a cluster?
Where should all SQL services be controlled from on a cluster?

<div>
<div class="content wysiwyg-content">
We are running a Windows 2003 failover cluster with SQL Server 2000 Enterprise. &nbsp;Where should SQL server agent service be stopped so as not to initiate a failover? From Services for the Virtual server? From Enterprise Manager?
</div>
</div>


We are running a Windows 2003 failover cluster with SQL Server 2000 Enterprise.  Where should SQL server agent service be stopped so as not to initiate a failover? From Services for the Virtual server? From Enterprise Manager?

Controlling SQL Server Agent on a Windows 2003 cluster

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.