Linked Servers through Windows Authentication

  • Hi Everyone,

    I set up [Server2] as a linked server on my local [Server1]. We use Windows Authentication mode ( So I selected Be made using the login's current security context). I wrote a SP on my local to fetch data from the linked server [Server2] and insert into a table in my local database. This SP works fine through the SSMS. Now I am trying to run the same SP in a job. I created a EXECUTE T-SQL step in the job to execute this SP. Also, in the Advanced properties Tab for the step, I set RUN AS: MyDomain\MyLogin .

    Inspite of all this, the job fails due to the following reasons.

    Executed as user: MyDomain\MyLogin. Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274). The step failed.

    Can somebody help me how i can get this job succeed?

  • Try to see if any of these solutions help.

    http://www.sqlservercentral.com/Forums/Topic455426-146-2.aspx#bm459710

    ¤ §unshine ¤

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply