Linked server security problems
Posted on 2008-10-02
I have a SProc that is set to run on Server - it calls and makes some changes to remote DB on another server.
I have created a SQL user account with basic priveleges and used it to set up a linked server connection between the 2 servers.
The account is called 'LinkedUser' for example.
The account has basic priveleges to the databases it needs to run against.
I am trying to call the SProc from a SQL Agent job.
But when I try and run the job get error message
"Access to the remote server is denied because no login-mapping exists. "
The job is set to run as SA..
How can I get around this ?