[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

SQL Server Properties

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
0
prairieits
Asked:
prairieits
  • 2
1 Solution
 
SjoerdVerweijCommented:
Odd. When you go to Administrative Tools -> Services, can you set it from there? Do you have administrator rights?
0
 
prairieitsAuthor Commented:
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
0
 
SjoerdVerweijCommented:
> As a "best practice" should those services be started with a user account or with Local System?

A special domain account with as few rights as possible.

> 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.  

That sounds quite plausible, yep  :-)
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now