Can't manage SQL

I have a SQL Server running on a new W2k3 Server, and a user that received
the Sys Admin roles at this SQL Server. However, this user can't access this
SQL Server using the Service Manager nor stop/pause this server. The others
operations, suck as creating a new DB is ok for this group. Any help?
the error that i get is "error 5 (acess denied)"
thanks
Nuno
Hi,
To start any of the windows service user should be in Administrator or Power
user group. A login with SYSADMIN role can do
all the stuffs inside the SQL Server layer only not in Operating system side.
Note:
But the SQL Server Trusted users who fall in Admin group or power users
group can start and stop SQL server service.
Thanks
Hari
MCDBA
"Nuno" wrote:

> I have a SQL Server running on a new W2k3 Server, and a user that received
> the Sys Admin roles at this SQL Server. However, this user can't access this
> SQL Server using the Service Manager nor stop/pause this server. The others
> operations, suck as creating a new DB is ok for this group. Any help?
> the error that i get is "error 5 (acess denied)"
> thanks
> Nuno
>
|||Without giving users total admin control to access (stop/start services) i
believe you can add the users to the print operators group. This would
achieve the results you are looking for.
"Hari Prasad" wrote:
[vbcol=seagreen]
> Hi,
> To start any of the windows service user should be in Administrator or Power
> user group. A login with SYSADMIN role can do
> all the stuffs inside the SQL Server layer only not in Operating system side.
> Note:
> But the SQL Server Trusted users who fall in Admin group or power users
> group can start and stop SQL server service.
> Thanks
> Hari
> MCDBA
> "Nuno" wrote: