access to the remote server is denied because the current security context is not trusted

_{Wednesday, May 12, 2010 5:05 PM}

I have a sql job that i am trying to run, however i keep getting this error message:

access to the remote server is denied because the current security context is not trusted [sql state 42000] [error15274] the step failed.

i can run this script is ssms pefectly fine, but the error happens when i create a job.

i created one step,

step name: term

type: (transact-sql script t-sql)

run as: (this is blank)

command: UPDATE A
SET  A.terminated_on = B.Emp_TermDate
FROM saba_prod_tp2.saba_uat_tp2.cmt_person A
INNER JOIN [midhardysql04\dev].ssa_clone.dbo.EmployeeMaster B
ON A.custom0 = B.RecordID

advanced

run as user: net\devlogin

is there something else i can do to make this script execute successfully?

thank you

_{Thursday, May 13, 2010 1:14 AM ✅Answered}

Please find the response for the same error on another thread Job Failes on Linked Server

It is mainly relating to the SQL Server Service accounts and Windows account privileges issue.

Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!