469,610 Members | 1,862 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

-"Access Denied (Error 5)

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.
Jul 20 '05 #1
1 17005
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.

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by calfdog | last post: by
reply views Thread by Steve | last post: by
4 posts views Thread by Fabian von Romberg | last post: by
12 posts views Thread by Ron Weldy | last post: by
3 posts views Thread by Shailesh Humbad | last post: by
8 posts views Thread by Jeremy Ames | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.