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...

    Monday, May 14, 2007 7:43 AM