I am having some trouble executing a stored procedure via a linked server from SQL2005 to SQL2008R2. I can select data fine via the linked server, but executing a stored procedure is not working, i get this error when i try to execute it
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'user1'
The user(sql user) has full access required on the database in question,
and the linked server is set so that the local login is impersonating the remote user
I also tried not impersonating and manually entering the details.