Hi,
Merry Christmas to Everyone.
We have a SQL2k server that is not in any domain (in a
workgroup). I registered it in the Enterprise Manager on
my workstation with the sa account. However, I can do
anything but stop or start the SQL server and server
agent. Here is the error message:
An error 5 - (Access is denied) occurred while performing
this service operation on the SQLServerAgent service.
Any suggestions?
Thanks.
David WangServices are an OS thing, not an SQL thing. Log in as
admin.
>--Original Message--
>Hi,
>Merry Christmas to Everyone.
>We have a SQL2k server that is not in any domain (in a
>workgroup). I registered it in the Enterprise Manager on
>my workstation with the sa account. However, I can do
>anything but stop or start the SQL server and server
>agent. Here is the error message:
>An error 5 - (Access is denied) occurred while performing
>this service operation on the SQLServerAgent service.
>Any suggestions?
>Thanks.
>David Wang
>.
>|||Yes, you are right. I have no problem to do this if I log
in from the local server. I am trying to do this from a
remote machine. I thought the sa account could impersonate
the local system admin role.
Thanks.
>--Original Message--
>Services are an OS thing, not an SQL thing. Log in as
>admin.
>>--Original Message--
>>Hi,
>>Merry Christmas to Everyone.
>>We have a SQL2k server that is not in any domain (in a
>>workgroup). I registered it in the Enterprise Manager on
>>my workstation with the sa account. However, I can do
>>anything but stop or start the SQL server and server
>>agent. Here is the error message:
>>An error 5 - (Access is denied) occurred while
performing
>>this service operation on the SQLServerAgent service.
>>Any suggestions?
>>Thanks.
>>David Wang
>>.
>.
>|||sa is not an administrator to the operating system.
No comments:
Post a Comment