Re: Stored Procedure Fails Only When Called By Agent

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 05/07/04

  • Next message: Erik Nelson: "Re: Stored Procedure Fails Only When Called By Agent" 
    Date: Fri, 7 May 2004 20:38:55 +0100

    Erik,
    my suspicion is that you are using impersonation in your remote server
    login. The sql server agent is the account that runs the job, and this
    account exists on the server with a different password. If this is the case
    then you can use pass-through security by specifying the same password and
    username. Alternatively,you can map logins in the security section of the
    linked server setup - eg you can map all users on machine A to a single user
    on remote machine B.
    HTH,
    Paul Ibison

  • Next message: Erik Nelson: "Re: Stored Procedure Fails Only When Called By Agent"
    • Quantcast