RE: Linked server 7302 error
From: William Wang[MSFT] (v-rxwang_at_online.microsoft.com)
Date: 01/27/05
- Next message: borko: "Enterprise Manager list databases"
- Previous message: Sue Hoegemeier: "Re: Connecting from Windows (VB6.0) app to SQL on Internet"
- In reply to: SPaquin: "Linked server 7302 error"
- Next in thread: SPaquin: "RE: Linked server 7302 error"
- Reply: SPaquin: "RE: Linked server 7302 error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 Jan 2005 10:22:37 GMT
Hi Stephane,
Before we go further, I'd like to get a better
understanding of the following points to ensure that I
understand the problem clearly:
1. "I add my user A to the Security/Connections tab to
allow a connection to this DB"
How did you do this? Where is the Security/Connections
tab? Is "this DB" a SQL Server DB or a Oracle DB?
2. What is the difference between User A and User B? If
you create a new user, say User C, do you still have
this problem?
You may want to refer to this article for more basic
troubleshooting steps regarding this error:
280106 How to set up and troubleshoot a linked server to
Oracle in SQL Server
http://support.microsoft.com/?id=280106
Feel free to post back if you have any further updates.
Sincerely,
William Wang
Microsoft Online Partner Support
=============================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=============================
This posting is provided "AS IS" with no warranties, and
confers no rights.
--------------------
>Thread-Topic: Linked server 7302 error
>thread-index: AcUDvo+royZwDPf5QV+3AtJyHzQhaA==
>X-WBNR-Posting-Host: 205.151.229.14
>From: "=?Utf-8?B?U1BhcXVpbg==?="
<spaquin@newsgroup.nospam>
>Subject: Linked server 7302 error
>Date: Wed, 26 Jan 2005 07:49:03 -0800
>Lines: 52
>Message-ID:
<0245D03E-DA88-49FA-86AC-65FCE40910E8@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.connect
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl
microsoft.public.sqlserver.connect:44257
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>
>Hi
>I have a strange connection error that I believe is
related to security. But
>I need some advice.
>
>I need to know what are exactly the permissions needed
to establish a linked
>server connection through network using integrated
security.
>
>My setup is the following for my test environment
before I implement a
>linked server in production servers.
>
>I have installed MSDE on my Windows XP FR machine. The
exact version is SQL
>Server Desktop Engine 8.00.194 on Windows NT5.1(2600)
Francais(France). MDAC
>2.7 is installed. MSDAORA.dll version is 2.71.9030.
MSDAORAR.dll version is
>2.70.7713.
>
>I have installed Oracle 9i SQL*Net Client 9.0.1.1.1.
All Oracle tools are
>configured and work properly and allow me to access the
Oracle database
>without any problem. I conclude there is no Oracle
connectivity problem.
>
>I am a local admin. I add my user A to the
Security/Connections tab to allow
>a connection to this DB. I add a linked server pointing
to my Oracle DB where
>the oracle user is readonly. Still on the same machine,
I open the Query
>analyser using local server and integrated security.
Works like a charm.
>
>I enter a query using the linked server. select * from
>openquery(ORACLE,'sql') where sql is executed on the
oracle DB. I receive
>results correctly. This works perfectly. I go to
another computer and log
>with user A. I use the QA to connect to my SQLserver DB
with integrated
>security. It works and I can query the SQLServer
tables. I run the same
>linked server query as if I was on my first machine and
it works.
>
>Now my problem. In my SQLServer, I add a second
Security/Connection user B.
>On the second computer using QA and user B, I can
connect to my SQLServer
>with integrated security under user B. But when I try
to run the linked
>server query, it does not work. I get an error logged
in the registry
>whenever I attempt a connection. The error is DCOMM
10002 Access denied
>attempting to launch a DCOM server. The server is
>{2206CDB0-19C1-11D1-89E0-00C04FD7A829}. The user is...
>This corresponds to MSDAINITIALIZE DCOM component. In
QA, my query returns
>with error 7302, Unable to create a MSDAORA OLEDB
provider instance.
>
>What is the problem ?
>I have tried so far:
>- giving admin rights on to user B on SQL Server
computer. No success.
>- the linked server works when I use a SQLServer
authentication.
>
>Other thoughts ?
>
>Stephane
>
>Sorry for the third post. I had trouble with Microsoft
managed newsgroup
>stuff...
>
- Next message: borko: "Enterprise Manager list databases"
- Previous message: Sue Hoegemeier: "Re: Connecting from Windows (VB6.0) app to SQL on Internet"
- In reply to: SPaquin: "Linked server 7302 error"
- Next in thread: SPaquin: "RE: Linked server 7302 error"
- Reply: SPaquin: "RE: Linked server 7302 error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
