Linked Server loses login-mapping

I use linked serve with (Security :be made with specific security conterxt) to connect to my production server from a Data Archive server.

Stored Procedures loop throught the prodcution data to insert records into Archive tables...Howerver after few hundreds of iteration I get the following error...

"Access to the remote server is denied because no login-mapping exists."

I am confused with the error message as it happens only after some successful insertions....

Any help is apprecaited...

Thanks

Please refer to BOL. A couple of links that hopefully will help you to get started:

· sp_addlinkedsrvlogin http://msdn2.microsoft.com/en-us/library/ms189811(SQL.90).aspx

· Distributed Queries Stored Procedures http://msdn2.microsoft.com/en-us/library/ms174359(SQL.90).aspx

If you have additional questions we will be glad to help.

-Raul Garcia

SDE/T

SQL Server Engine