Error received when attempting to restore backup on SQL Server 2000 sp3 Windows 2000 Enterprise sp4 (2195).
"Server: Msg 50000, Level 19, State 1, Line 0
ConnectionRead (WrapperRead()).
[Microsoft][ODBC SQL Server Driver][Named Pipes]General network error. Check your network documentation."
A MDAC (Microsoft Data Access Components) 2.8 bug that occurs when using Named Pipes with MS SQL Server 2000 SP 3 on Windows 2000 Enterprise, this is not a LiteSpeed problem.
WORKAROUND:
Utilize the TCP/IP Net-Library instead of the Named Pipes Net-Library to connect to the SQL Server database, and then back up or restore the database.
For the exact steps to set the TCP/IP network library on the client where you are performing the backup or the restore operation, see the "How to configure a client to use TCP/IP (Client Network Utility)" chapter in SQL Server 2000 Books Online. Microsoft's SQL Server 2000 Books Online can be installed from the SQL Server 2000 CD. For information on how to use SQL Server 2000 Books Online, refer to Microsoft Article "Using SQL Server Books Online":
http://msdn.microsoft.com/library/en-us/startsql/hlpview_94fm.asp
When you connect to an instance of SQL Server by using SQL Query Analyzer, you can force the connection to use the TCP/IP Net-Library. To do this, type the name of the instance of SQL Server with the tcp prefix in the SQL Server text box in the Connect to SQL Server dialog box. This appears as follows:
tcp:SQL Server Name
Refer to Microsoft Article ID: 827452 - "FIX: General network error when you try to back up or restore a SQL Server database on a computer that is running Windows Server 2003", for more information on this issue:
http://support.microsoft.com/kb/827452/en-us
RESOLUTION:
Contact Microsoft for the hotfix: http://support.microsoft.com/contactus/?ws=support
SQL Server 2000 sp3
Windows 2000 Enterprise sp4 (2195).
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy