Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a linked server from a 2005 instance to a 2000 instance that I am getting an error when trying to do an Update accross the linked server. This Update has worked for the past 2 years without issue. The last 2 days it is now failing with this error

OLE DB provider "SQLNCLI" for linked server "sr1ap004" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Msg 16955, Level 16, State 2, Line 1 Could not create an acceptable cursor.

I have verified permissions with the linking account, I can run simple select without issue. I have also tried to recreate the linked server, and verified that RPC and RPC out are both set to 'true'

Thanks for your help!

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.