Re: Link Server and sa password
From: BP Margolin (bpmargo@attglobal.net)
Date: 02/09/03
- Next message: Gert E.R. Drapers: "Re: Hide Database from Registered Server"
- Previous message: BP Margolin: "Re: protecting data from programmers!?"
- In reply to: S H Ferdous: "Link Server and sa password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "BP Margolin" <bpmargo@attglobal.net> Date: Sun, 9 Feb 2003 11:44:07 -0500
Shah,
When server AAA tries to access server BBB, server BBB doesn't care that it
is being accessed by another SQL Server instance. From the perspective of
server BBB, just another user is requesting access.
Impersonation means that when server AAA is trying to access server BBB, it
should login to server BBB using the credentials specified.
Are you supplying the sa password of server BBB or of server AAA? Server BBB
doesn't care what the sa password of server AAA is, so you need to supply
the password of server BBB.
Also, is server BBB set up to use Mixed Authentication mode? If server BBB
only accepts Windows Authentication, then sa passwords, even if valid, just
don't work ;-)
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"S H Ferdous" <shah_ferdous@hotmail.com> wrote in message
news:00ed01c2d027$0e280180$3001280a@phx.gbl...
> I am using MSSQL Server 7. I have another SQL Server 7 at
> a remote location. Now think first one is "AAA" and second
> one is "BBB". "AAA" has got a linked server configuration
> like;
> General Tab
> Provider name : Microsoft OLE DB provider for Sql Server
> Data Source: CCC
> Catalog : YYY
> Security Tab
> They will be impersonated is checked.
> Linked server works fine. I can see the tables of "BBB".
>
> Problem is if I put the sa password, the linked server
> doesn't work. I don't know why.
>
> Can anybody help me on this regard.
>
> Thanks in Advance
>
> Regards
>
> S H Ferdous
>
>
>
>
- Next message: Gert E.R. Drapers: "Re: Hide Database from Registered Server"
- Previous message: BP Margolin: "Re: protecting data from programmers!?"
- In reply to: S H Ferdous: "Link Server and sa password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
