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
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)