December 1, 2008 at 5:47 pm
Hi Friends,
I added a linked server with "be made using current login security context " option in security tab for the linked server.
When i run one of the SP which is with select statement from linked server, I am getting data. But when i call this SP from a job step i am getting below error.
Executed as user: NT AUTHORITY\SYSTEM. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. [SQLSTATE 28000] (Error 18452) TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 42000] (Error 10054) OLE DB provider "SQLNCLI" for linked server "NMDB" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412). The step failed.
A machine account with my servername is already created in remote server.
Can someone help me to come out of this issue please.
February 12, 2010 at 12:45 pm
Does your problem Resolved?
I am having same issue where I have READ-ONLY access to my REMOTE Server. I have SP which call several table from remote server. When I run sp in SQL Management Studio it run perfect but when i schedule via SQL Server Agent it give me below message.
Message: "Executed as user: dbo. Access to the remote server is denied because the current security context is not trusted."
Since, I have DBO access on my server and looking at above error message it seem like due to my read only access to remote server?
Please advice,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply