RE: Linked server 7302 error
From: William Wang[MSFT] (v-rxwang_at_online.microsoft.com)
Date: 01/28/05
- Next message: Marco Pais: "Database Performance"
- Previous message: Wolfgang: "Communication ODBC Error-1"
- In reply to: SPaquin: "RE: 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: Fri, 28 Jan 2005 09:39:47 GMT
Hi Stephane,
Your explaination is great. Now my understanding of this
issue is: On both Computer A and Computer B, if you
logon the SQL Server using User A and run the Openquery
statement, the query works fine; but if you logon as
User B, the query fails regardless whether you are on
Computer A or Computer B. If this is not correct,
please let me know.
This issue looks strange because the error message
should not be caused by a permission problem.
Nevertheless, let's try the following steps to see what
happens:
To isolate the problem we don't need to involve Computer
B in our troubleshooting step.
1. Register MSDAORA.dll using RegSvr32.exe and then test
the problem.
2. Check the Security tab of the Linked Server
Properties dialog box to see if there is anything
related to User A. What do you see from the tab? You may
want to remove the linked server and then set up a
linked server with a simliar script to the one mentioned
in KB280106 and then test the problem.
3. If the issue persists, reinstall MDAC to see if it
helps. You can download the latest MDAC from the
following link:
http://www.microsoft.com/downloads/details.aspx?displayla
ng=fr&FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c
If the issue still occurs, I suggest that you post this
issue in the <microsoft.public.fr.sqlserver> newsgroup
as you are using Franch version.
Hope it helps.
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.
=====================================================
Business-Critical Phone Support (BCPS) provides you with
technical phone support at no charge during critical LAN
outages or "business down" situations. This benefit is
available 24 hours a day, 7 days a week to all Microsoft
technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/support
overview/40010469
Others:
https://partner.microsoft.com/US/technicalsupport/support
overview/
If you are outside the United States, please visit our
International Support page:
http://support.microsoft.com/default.aspx?scid=%2finterna
tional.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and
confers no rights.
--------------------
>Thread-Topic: Linked server 7302 error
>thread-index: AcUEeBMq2g7sFC82QQGsoRNJgct6CA==
>X-WBNR-Posting-Host: 205.151.229.14
>From: "=?Utf-8?B?U1BhcXVpbg==?="
<spaquin@newsgroup.nospam>
>References:
<0245D03E-DA88-49FA-86AC-65FCE40910E8@microsoft.com>
<CV5HjoFBFHA.644@cpmsftngxa10.phx.gbl>
>Subject: RE: Linked server 7302 error
>Date: Thu, 27 Jan 2005 05:57:01 -0800
>Lines: 83
>Message-ID:
<FF352DAC-0676-4328-818B-2C57D7F563EA@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:44266
>X-Tomcat-NG: microsoft.public.sqlserver.connect
>
> Hi William
>
> Here are answers to your questions.
>
>1. I use SQL Server Enterprise Manager to add a user to
the Security/Logins.
>Sorry, my Security/Connections is a bad translation
from my French
>installation.
>2. I had already tried a third user before I posted. It
shows the same
>behavior.
>
>Computer A
Computer B
>Windows XP Fr SP1
Windows XP Fr
>MSDE installation
SQL Server tools
>Oracle network drivers
No oracle drivers
>User A is local admin
User a logs in
>this computer.
>In QA, login to DB with integrated QA
login integrated
>security
>security.
>Queries to linked server work.
Queries to linked
>server work
>
>Login with user B
Login with user
>B on computer B
>Open QA, login to DB with integrated Open
QA, login to DB with
>integrated
>security.
security
>Run linked server query. Does not Run
linked server query.
>Error 7302
>work(7302 error) but no DCOM but
no DCOM error anymore
>in
>error in eventlog.
eventlog.
>
>On SQLServer error log, I see the following message:
> Unable to load OLE/DB initialization service.
>
>On all computers, if I log to SQLServer DB with
SQLServer security,
>everything works perfectly.
>
>Stephane
>
>
>"William Wang[MSFT]" wrote:
>
>> 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.
>>
>> --------------------
>
>
- Next message: Marco Pais: "Database Performance"
- Previous message: Wolfgang: "Communication ODBC Error-1"
- In reply to: SPaquin: "RE: 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
|
