473,388 Members | 1,109 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

-"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 17308
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: calfdog | last post by:
Hello, Does anyone know a workaround for calling fireEvent. With the latest from Microsoft OS XP2 and Hot fixes to IE it now gives an "access denied" error in Python when called. Here is what...
0
by: Steve | last post by:
Hi, Yesterday I signed up for another dedicated linux server with the hosting company I use and I am having problems getting MySQL 4.1.3 working on it. I've tried just about everything I can...
3
by: vincentw56 | last post by:
This is the first time I have tried this. What we have is a com object the generates keys. A developer here wrote a .Net wrapper in C# for this com object. I am trying to call her dll wrapper...
4
by: Fabian von Romberg | last post by:
Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000 PRO and the other one is WIN 2000 ADV. SERVER. When I try to access a report using the webbrowser, I get the following...
5
by: Raterus | last post by:
I'm just throwing this error out for my sanity, I've seen posts about this, but never solutions. I'm using VS.NET 2003, Framework 1.1, and I'm getting a random error about every 1 out of 10 times...
16
by: Brad | last post by:
After compiling my asp.net project I'm receiving a "BC31011 - Access is denied" error when attempting to run or debug. The only thing that seems to resolve problem is IISReset. After a reset my...
12
by: Ron Weldy | last post by:
I have a test server runinng 2003/IIS 6 with a mixture of asp and asp.net files. On my workstation I have a share set up to the folder where the web files reside. I am just doing quick and dirty...
3
by: Shailesh Humbad | last post by:
I figured out what was causing the "Access is Denied" error when calling functions from referenced DLLs in my service. I've tried to be very detailed, so bear with me. It turns out that...
8
by: Jeremy Ames | last post by:
I am trying to move an application from my system to a new test system. I really should have tried an easier program first, but I didn't really have a chance. My application was originally written in...
0
by: Andy | last post by:
Thanks Peter, I thought I'd give an update on this problem. My application had 2 assemblies that contained classed for the Data access and business logic layer. It was on one of them that I was...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.