RE: Linked server 7302 error

From: SPaquin (spaquin_at_newsgroup.nospam)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 06:13:02 -0800

Hi
Your understanding is correct. User A can use the linked server from any
computer. User B(or any other) can not. Error message is related to
initializing the connection.

1. The MSDAORA.dll is already registered since it works perfectly under user
A.
2. Under the linked server security tab, nothing is entered except the last
item is selected: Be made with this security context : username/password.
Nothing related to user A or B. I will look at KB article.
3. MDAC 2.7 is installed and works. Again, it works perfectly under user A.

Post to microsoft.public.fr.sqlserver. Bad suggestion. I have a problem and
you suggest that I go somewhere else. No thanks.

I still have a problem with my linked server and I still need some support.
I believe it is related to a security issue using integrated security login
because I can access the linked server with a SQLServer login from any user
or computer.

What other suggestions do you have ? Surely, you can find a SQL Server /
linked server / integrated security specialist somewhere in Microsoft ?

Thanks anyway
Stephane

"William Wang[MSFT]" wrote:

> 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.
>
> --------------------

Relevant Pages

  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
  • RE: Script-Out Linked Server?
    ... There is no script out function available for Linked Server. ... to add the Linked Server is using the following TSQL script: ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.setup)
  • RE: securing Access to DB on remote Server
    ... SQL instances/servers via linked server. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.security)
  • Re: Distributed Query - Linked Servers?
    ... the Microsoft SQl Serve support engineer. ... make a detail list for you to configure the double hop linked server. ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.server)
  • RE: 0x80004005 - you need permission to view its data
    ... The first one says to install the latest Jet service pack on the server, ... When I use enterprise manager to browse the linked server from the SQL ... server machine I can see the tables in the database. ... > Access 97 has been out of support boundary and is not officially supported. ...
    (microsoft.public.sqlserver.security)