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.