> Hi All
>
> I trying to pull data from another server by the use of linked server.
>
> On the server pulling the data I have views accessing the linked server.
>
> My question relates to the remote user choice - when setting up linked
> server it seems as if I can
> only choose to connect using af database user on the remote server I
> cannot
> connect using
> a windows user.

"Helge C. Rutz" <news050424@nurfuerspam.de> wrote in message
news:3ehtfiF39o42U1@individual.net...
> Hi Michael,
>
> "Michael Vardinghus" <michaelvardinghus@hotmail.com> schrieb im
Newsbeitrag
> news:%23bgqFcyVFHA.3716@TK2MSFTNGP12.phx.gbl...
> > Hi All
> >
> > I trying to pull data from another server by the use of linked server.
> >
> > On the server pulling the data I have views accessing the linked server.
> >
> > My question relates to the remote user choice - when setting up linked
> > server it seems as if I can
> > only choose to connect using af database user on the remote server I
> > cannot
> > connect using
> > a windows user.
>
> there is no way to map windows users.
> The only way to use windows users is the option to use the current user
> context.
> If the user authenticated through kerberos, and the sql server is trusted
> for delegation, and the user is also authorized on the remote server, he
> could query the linked server.
> For more Information start with kerberos in the online help.
>
> To be fair: In practice it's not so easy as it some times look like ;-)
>
> Helge
>
>