Alternative to Account Delegation?

From: Dan H (DanH_at_discussions.microsoft.com)
Date: 07/21/05

  • Next message: Sophie Guo [MSFT]: "Re: How to create SQL Login audit log?"
    Date: Wed, 20 Jul 2005 16:13:01 -0700
    
    

    Hello,
    I want to run distributed queries via a linked server using a windows
    autheniticated login. Talking with our AD/network admin about the steps in

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp

    they have a problem with setting up account delegation for service account
    and sql server computer, mainly because this is a new precedent and they
    don't want to go there unless absolutely necessary.

    Are there any alternatives to doing the above that would enable distributed
    queries using windows authenicated logins?
    Thanks,
    Dan


  • Next message: Sophie Guo [MSFT]: "Re: How to create SQL Login audit log?"

    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)
    • 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)
    • linked servers and windows authentication
      ... I have same windows nt sql server logins on both servers. ... Linked server security is configured in a way that all ...
      (microsoft.public.sqlserver.server)
    • Re: Executing INSERT INTO EXEC against linled server
      ... Computer I am querying from is using Windows XP SP2. ... Both computers have SQL Server 2000 SP3 instralled. ... databases and RECOVERY MODEL from linked server. ...
      (microsoft.public.sqlserver.programming)