linked servers and windows authentication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: OJ (anonymous_at_discussions.microsoft.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 13:51:12 -0700

Hi,
Does anybody know if I can use linked server security
configuration with login's current security context for
windows authenticated sql server logins? I tested and it
doesn't work!!!
I have same windows nt sql server logins on both servers.
Linked server security is configured in a way that all
connections should be made using the login's current
security context (third option). It means that all windows
nt users should be able to refer database objects from the
linked server in their queries (using fully qualified
object name).
Well..., it is not true!
It works ONLY if windows nt user is connected locally to
the server where linked server is defined! However, if the
same windows nt user tries to do that from the client
computer, query fails with login incorrect message.
Did anybody try this? It's so stupid that I cannot believe
it's true.
Thanks

Relevant Pages

  • Update
    ... Seems to have something to do with security. ... Windows NT user activated by SETUSER. ... I gather that the SQL Agent Job ... >linked server, and these work via Query Analyzer. ...
    (microsoft.public.sqlserver.security)
  • Re: Linked server - from 2008 to a 2005 box.
    ... Ok - so there are no windows authentication involced in the Linked Server ... The SA account you are using to connect with, has to exists on the target ... From my local machine I connect to a SQL 2008 Server from the management ...
    (microsoft.public.sqlserver.server)
  • Problem with linked server
    ... I am using a linked server to import data from a excel-file that is stored ... windows permission to read the excel-file. ... The OLE DB-Provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ... OLE DB-errortrace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' ...
    (microsoft.public.sqlserver.programming)
  • Alternative to Account Delegation?
    ... I want to run distributed queries via a linked server using a windows ... autheniticated login. ...
    (microsoft.public.sqlserver.security)
  • Re: linked servers and windows authentication
    ... > Does anybody know if I can use linked server security> configuration with login's current security context for> windows authenticated sql server logins? ...
    (microsoft.public.sqlserver.server)