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
NunoThe starting and stopping of a Server Service has nothing
to do with SQL and everything to do with the W2k3 roles.
So the problem here is your user does not have access
rights to stop the service as the W2k3 role will not let
them.
Have a chat to your server guys.
Peter
"Action speaks louder than words but not nearly as often"
Mark Twain
>--Original Message--
>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:
> 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
> >