RE: Linked server 7302 error

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

Date: Thu, 27 Jan 2005 05:57:01 -0800

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

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to prevent hacker trying to guess sa password?
    ... and port 1433 will not be open. ... If someone can crash SQL Server by connecting to port 1433, ... You don't need multiple security experts. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting to the bottom of MSDE network connection problems ...
    ... Brilliant, Nick, especially the explanation for local network user being ... authenticated as GUEST in WinXP SP2. ... > on a desktop OS like XP (meaning that, you can not compare SQL Server ... > again and selected the security tab. ...
    (microsoft.public.sqlserver.msde)
  • RE: Login failed for user (null).
    ... used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • [NT] SQL Extended Procedure Functions Contain Unchecked Buffers
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... SQL Server 7.0 and 2000 provide extended stored procedures, ... Several of the Microsoft-provided extended stored procedures have been ... Exploiting the flaw could enable an attacker to either cause the SQL ...
    (Securiteam)