I have linked a Sql2005 server in a multi server environment in order to run remote queries.

I did setup security, so that

Select Top 10 * From [DK_SQL_01].Fleet.dbo.Inventory

works and returns results

But:

EXEC [DK_SQL_01].SimpleDayFeeder.dbo.SimpleDaysUpdateOnHand

Returns:
Server: Msg 7416, Level 16, State 1, Line 1
Access to the remote server is denied because no login-mapping exists.

I believe I have set up correct login mappings, since the query works, but I keep getting this error.

TIA

Peter