Linked server 7302 error
From: SPaquin (SPaquin_at_discussions.microsoft.com)
Date: 01/26/05
- Next message: SPaquin: "Linked server 7302 error"
- Previous message: thejamie: "Finding the better performance filtered table vs record fetch"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 26 Jan 2005 07:33:01 -0800
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
- Next message: SPaquin: "Linked server 7302 error"
- Previous message: thejamie: "Finding the better performance filtered table vs record fetch"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
