Post reply

Job doesn't login to the linked server

  • November 14, 2007 at 2:18 pm

    #119394

    My SQL Agent runs under system account

    User DOMAIN\COMPUTER_NAME$ is added to users and has role system admin

    This user has mapping to "sa" user to the linked server

    Job runs procedure which select from remote DB

    Error I have:

    Executed as user: NT AUTHORITY\SYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416). The step failed.

    Can somebody help me?

  • November 14, 2007 at 2:27 pm

    #751267

    Another interesting think: If I make new login map "any users" -> "sa" remote query will work fine. If I remove mapping "any users" -> sa connection still working for a 20min.

    But after some expiration period connection is lost

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply