active directory with sqll 2005

Hello,
I have an active directoy controller with microsoft SQL 2005 installed
in the same windows 2003 machine.
is there a way to grant a domain user to start/stop sql server without
domain admin privilege?
Many thanks for the help in advance.The local admin on the server would do the trick. Thats what I have on all
SQL servers I manage.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"one2001boy@.yahoo.com" wrote:

> Hello,
> I have an active directoy controller with microsoft SQL 2005 installed
> in the same windows 2003 machine.
> is there a way to grant a domain user to start/stop sql server without
> domain admin privilege?
> Many thanks for the help in advance.
>|||Mohit K. Gupta wrote:
> The local admin on the server would do the trick. Thats what I have on al
l
> SQL servers I manage.
>
For the domain controller on Win 2003, there is no local admin. Your SQL
server must not be on domain controller.
thanks for your help anyway.|||Yeap. Sorry my bad, I wouldn't want SQL Server to be on PDC. The network
guys would make my life a living hell.
Not server guy, but if the service is set to start under set of credentials.
Can those credentials start/stop the service?
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"one2001boy@.yahoo.com" wrote:

> Mohit K. Gupta wrote:
> For the domain controller on Win 2003, there is no local admin. Your SQL
> server must not be on domain controller.
> thanks for your help anyway.
>