Item Copy recieves Database connection lost Error

It sounds like there is bad data in the item they are trying to copy from. Do you get the same result when copying ANY Item, or is it limited to a specific set of items.

I would suggest creating a Sample DB on that system and pointing SO Administrator to that new sample DB. Try copying one of the sample items and see if that works. If it does, something has gone bad in your live data. First thing to do would be to backup the DB then do check and reindex from SO Administrator. That may fix it.

The next thing would be to compare the schema of the live database to the sample database; it is possible that a column size has been altered on the live DB and the copy process is failing because of that.

Make sure that you don't have any other programs open that might LOCK the item table - an example would be MS Access or SQL Management Studio with the table open either to show results or in design view.

Glenn Adams Tiber Creek C> One of our clients is receiving a Database connection lost Error -2147467259

Hi Glenn, The error occurs on all items tried. The database check was performed with no errors. The network settings were reviewed, the network protocols (Named Pipes, TCP/IP) were disabled and then reenabled, both computers were rebooted, the network connections were refreshed, the file printer and sharing is checked on both computers, and the Windows firewall was turned off on both computers. The client is now able to copy the same items tried before. Thank you for your assistance, Ed

"Glenn Adams [MVP - Retail Mgmt]" wrote:A