Services login policies and rights question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: frankm (frank_at_nxspxm.mallardcentral.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 16:09:19 -0600

Scenario is Windows 2003 Enterprise and SQL Server 2000 Enterprise.

I need to know what rights, policies and / or other configurations are
needed for SQL Server to install on a cluster.
(for that matter, any SQL Server install on / in a 2003 environment). It
seems that things may have changed somewhat with 2003.

We trying to install today with a sql service domain account added to the
local admin group of both nodes of the cluster. Cluster service login was
already configured. We tried logging in as the sql service account and the
install failed. The admin added the sql service account as part of the
domain admin group and still wouldn't install. Finally, the domain admin
(who is enterprise domain admin) used his login to install and it worked, we
still used the sql service domain account as the services login. We have had
a lot of difficulty in this type of install. The admin say it is a "security
thing" but won't elaborate. I know about a few of the policy setting and
rights things, but I need a real and better understanding of **exactly**
what we need, to make this work properly.

Relevant Pages