<div>
Odd. When you go to Administrative Tools -&gt; Services, can you set it from there? Do you have administrator rights?
</div>


Odd. When you go to Administrative Tools -> Services, can you set it from there? Do you have administrator rights?

<div>
I can set it from there. &nbsp;I am logged on as administrator. &nbsp;As a &quot;best practice&quot; should those services be started with a user account or with Local System?<br />
<br />
I think the reason that I cannot set them in EM is because the SQL Server is part of a resource group in my 2 node cluster. &nbsp;I am going to leave the services as manual and let the cluster re-start the services (which is how the cluster is set, now that I looked at that) :)<br />
<br />
Thanks for your help.<br />
<br />
-Jerod
</div>


I can set it from there.  I am logged on as administrator.  As a "best practice" should those services be started with a user account or with Local System?

I think the reason that I cannot set them in EM is because the SQL Server is part of a resource group in my 2 node cluster.  I am going to leave the services as manual and let the cluster re-start the services (which is how the cluster is set, now that I looked at that) :)

Thanks for your help.

-Jerod

<div>
<div class="content wysiwyg-content">
If I go into EM, right click on the server I want to configure and click on properties, I cannot check the options &quot;Autostart SQL Server&quot;, &quot;Autostart SQL Server Agent&quot; or &quot;Autostart MSDTC&quot; in the General tab. &nbsp;They are greyed out.<br />
<br />
Some background:<br />
<br />
This is a Windows Server 2003 Enterprise 2 node cluster attached to an EMC SAN. &nbsp;One thought I had is, since SQL Server is a resource group in Cluster Administrator, do I set these options in there somewhere? &nbsp;If so, I didn't see it.<br />
<br />
Thanks in advance,<br />
Jerod
</div>
</div>


If I go into EM, right click on the server I want to configure and click on properties, I cannot check the options "Autostart SQL Server", "Autostart SQL Server Agent" or "Autostart MSDTC" in the General tab.  They are greyed out.

Some background:

This is a Windows Server 2003 Enterprise 2 node cluster attached to an EMC SAN.  One thought I had is, since SQL Server is a resource group in Cluster Administrator, do I set these options in there somewhere?  If so, I didn't see it.

Thanks in advance,
Jerod

SQL Server Properties

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.