Linked Server Security Problem
From: DaveK (anonymous_at_discussions.microsoft.com)
Date: 03/24/04
- Next message: john celery: "NT4 Groups to SQL Roles"
- Previous message: Timo: "Re: IIS -> SQLServer on another machine"
- Next in thread: Sue Hoegemeier: "Re: Linked Server Security Problem"
- Reply: Sue Hoegemeier: "Re: Linked Server Security Problem"
- Reply: Jasper Smith: "Re: Linked Server Security Problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 24 Mar 2004 11:53:05 -0800
I moved a DB to another server in the same domain. The
app needs to connect both to new server (B) and to a table
on the old server (A). I set up a linked server entry
pointing back to old server (A) in the new server (B), but
could not get app to connect unless I used SQL security.
All attempts to use NT security resulted in the login
failing for either a null user or for annonymous user. I
also had to delete the user on server (B) and re-add with
same name, since SID did not match up between the new and
the old server. I understand that problem, howver does the
same thing occurr with NT security? Both servers are set
to use mixed security. Right now only SQL security seems
to work. I have tried modifying the settings with both EM
and QA commands. I would prefer that NT security be used
for all connections.
- Next message: john celery: "NT4 Groups to SQL Roles"
- Previous message: Timo: "Re: IIS -> SQLServer on another machine"
- Next in thread: Sue Hoegemeier: "Re: Linked Server Security Problem"
- Reply: Sue Hoegemeier: "Re: Linked Server Security Problem"
- Reply: Jasper Smith: "Re: Linked Server Security Problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
