Hi all
The server is a BDC (as it was called in the good old days) running AD on w2k3.SQL Server 2000 is also running on this machine. A domain user account was created to run these SQL Server services. I add the accounts under services and grant log on as a service etc. I then stop the service but when I try and restart the service I get an Access Denied error. Eventually I added the sql domain account to the domain admins group and that did the trick.
Ideally we don't want the sql account to be a domain administrator but what do I need to setup to allow the user to start the sql services.?
The server is a BDC (as it was called in the good old days) running AD on w2k3.SQL Server 2000 is also running on this machine. A domain user account was created to run these SQL Server services. I add the accounts under services and grant log on as a service etc. I then stop the service but when I try and restart the service I get an Access Denied error. Eventually I added the sql domain account to the domain admins group and that did the trick.
Ideally we don't want the sql account to be a domain administrator but what do I need to setup to allow the user to start the sql services.?
