START SERVICES ON AD WIN2K3 SERVER?

[osjohnm]

Hi All

THe server is running as DC(actually BDC) on W2K3 with SQL Server 2000. A domain user account was created to run the sql services but once the user and pwd have been entered and the service has been stopped, if you try and start the service we get an Access Is Denied error.

Eventually the user was added to the Domain Admins group and that sorted it out.

This is not the best solution and therefore was wandering if anyone knows what permissions and properties need to be ticked to allow the user to start the services?

Thanks

John

 

[JamesLean]

Make sure you change the service account through Enterprise Manager rather than directly through Windows services. That way, SQL Server will assign the necessary file/registry permissions to the account automatically.

--James