-"Access Denied (Error 5)

[Ravi]

I am posting this message after reading all the previous posts with
the above subject.
I have a SQL2K named instance running on a Windows 2K machine under
Local system Account and it uses SQL Server authentication. This
Server is on a domain by itself. Let us call this M1.
I am connecting to this server from an XP machine usinng Enterprise
Manager. Let us call this machine M2.
Since the client and server are on differentt domains when I use
Server Manager on M2 to start/stop my M1's SQL Server, SQL Server
Agent etc, I am getting this error message -"Access Denied (Error 5)
When starting SQL Server Service"?
What user detailed are passed from M2 to M1 that I am getting this
error? What is the best way to use server manager on M2 to control M1?
Also how to know the status of a SQL server Agent from a cleint EM.

[Igor Raytsin]

You have not only two machines, but also two domains.
Let's call them D1 and D2.
And you are using D2\User_name to start/stop SQL Server on D1\M1.

1. Check your trust relationship between D1 and D2. D1 should at least trust
D2.
2. Your D2\User_name should be in "Administrators" or "Power Users " local
group on D1\M1
and has right "Access this computer from the network" on D1\M1.
If you don't like to add D2\User_name to the local Administrators or Power
Users on D1\M1,
check this article how to do it in other way:
http://support.microsoft.com/default...b;en-us;288129
HTH
Igor Raytsin

"Ravi" <ar*******@hotmail.com> wrote in message
news:92**************************@posting.google.c om...

I am posting this message after reading all the previous posts with
the above subject.
I have a SQL2K named instance running on a Windows 2K machine under
Local system Account and it uses SQL Server authentication. This
Server is on a domain by itself. Let us call this M1.
I am connecting to this server from an XP machine usinng Enterprise
Manager. Let us call this machine M2.
Since the client and server are on differentt domains when I use
Server Manager on M2 to start/stop my M1's SQL Server, SQL Server
Agent etc, I am getting this error message -"Access Denied (Error 5)
When starting SQL Server Service"?
What user detailed are passed from M2 to M1 that I am getting this
error? What is the best way to use server manager on M2 to control M1?
Also how to know the status of a SQL server Agent from a cleint EM.