Help! How to install Sql Svr 2k to Win2k3 Least Privilege Acct?

We are trying to install SQLSever2000 on a Windows 2003 Standard Server to a
n
account other than Administrator.
We used this guide (which works fine for Win2k Svr)
http://support.microsoft.com/defaul...b;en-us;Q283811
We get an Error 5: Access Denied message when starting SQL Server Agent, but
we don't get enough information to determine what has been denied.
It is obvious that there is some other setting that must be applied in
WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We hav
e
attempted to give the "SQLAdmin" account access to all files and directories
that are related to MS SQL Server.
Unfortunately, our fall back is to install SQL Server to run as
Administrator - because that works.
Any ideas/info is greatly appreciated.
email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.comI think something else must be wrong or you would not be able to start SQL
Server. Check your event logs, SQL errorlogs and SQL Agent logs for
additional information.
Use SQL Enterprise Manager whenever possible to change the start-up account
for SQL Server and SQL Agent services. SEM will set file and registry
permissions whereas Service Control Manager won't.
Most importantly, ensure that non-admin start-up accounts have following
user privileges:
. Act as Part of the Operating System = SeTcbPrivilege
. Bypass Traverse Checking = SeChangeNotify
. Lock Pages In Memory = SeLockMemory
. Log on as a Batch Job = SeBatchLogonRight
. Log on as a Service = SeServiceLogonRight
. Replace a Process Level Token = SeAssignPrimaryTokenPrivilege
If this is a cluster follow the instructions in
http://support.microsoft.com/kb/239885.
Adrian
"Hal" <Hal@.discussions.microsoft.com> wrote in message
news:D2E25E17-DE30-4AD9-AD55-96BBB5D78ABE@.microsoft.com...
> We are trying to install SQLSever2000 on a Windows 2003 Standard Server to
> an
> account other than Administrator.
> We used this guide (which works fine for Win2k Svr)
> http://support.microsoft.com/defaul...b;en-us;Q283811
> We get an Error 5: Access Denied message when starting SQL Server Agent,
> but
> we don't get enough information to determine what has been denied.
> It is obvious that there is some other setting that must be applied in
> WinSvr 2k3 that we are not doing - but we didn't see it in the guide. We
> have
> attempted to give the "SQLAdmin" account access to all files and
> directories
> that are related to MS SQL Server.
> Unfortunately, our fall back is to install SQL Server to run as
> Administrator - because that works.
> Any ideas/info is greatly appreciated.
> email: hal.hayes@.REMOVE_CAPS_AND_INVALIDacritech.com