Post reply

SQL job with step calling SP containing select statement with linked server.

  • December 1, 2008 at 5:47 pm

    #203643

    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

    #1118240

    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