March 14, 2008 at 11:59 am
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?
March 18, 2008 at 1:46 pm
Try to see if any of these solutions help.
http://qa.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