Microsoft KB Archive/818550

= BUG: Upgrade of SQL Server 6.5 to SQL Server 2000 Service Pack 3 Fails During the Export and Import Through Named Pipe Task =

Article ID: 818550

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Service Pack 3
 * Microsoft SQL Server 6.5 Enterprise Edition, when used with:
 * Microsoft Windows NT 4.0

-



BUG# 364258 (SQL Server 8.0)



SYMPTOMS
When you upgrade a SQL Server 6.5 database on a computer that is running Microsoft Windows NT to SQL Server 2000 Service Pack 3 (SP3) by using the SQL Server Upgrade Wizard, the operation fails during the Export and Import via Named Pipe task.

The Upgrade Wizard displays the following information files:

Export and Import via Named Pipe - 00n .err

Export and Import via Named Pipe - 00n .out

An error message, similar to the following, is logged in the 00n .err file:

Export.exe on the remote machine was hung...

Export Exit Code: 259 - export.exe -CodePage 1252 -DeviceType Pipe -AllTables yes -MasterPath C:\MSSQL\DATA\MASTER.DAT

-DatabaseName -DevicePath \\.\pipe\~cnvpipe0

Import Exit Code: -1 - ~cnvpipe0

Msg 4854, Level 21, State 1, Server , Procedure, Line 1

[Microsoft][ODBC SQL Server Driver][SQL Server]****

Time:04-18-2003 16:06:33.000

Error return from function CreateFile

in file CnvPipe.cpp

Line=143

rc=5

Msg=Access is denied.





STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



WORKAROUND
To work around the problem, perform one of the following tasks:
 * Upgrade the operating system of the server that is running SQL Server 6.5 to Windows 2000, and then upgrade the SQL Server 6.5 databases to SQL Server 2000 SP3.
 * Back up, and then restore the SQL Server 6.5 databases to the computer that is running Windows 2000 Server. Next, upgrade SQL Server 6.5 to SQL Server 2000 SP3. To do so, follow these steps:
 * On a Windows 2000-based computer, install SQL Server 6.5 with service pack 5a.

Note Before you install SQL Server 6.5, make sure that SQL Server 2000 is not installed on the computer that is running Windows 2000.
 * On a Windows NT-based computer, back up the SQL Server 6.5 databases.
 * On a Windows 2000-based computer, restore the backup of the SQL Server 6.5 databases you retrieved from the Windows NT-based computer.
 * On the Windows 2000-based computer, install SQL Server 2000 with Service Pack 3.
 * On the Windows 2000-based computer, upgrade the SQL Server 6.5 databases to SQL Server 2000 SP3.

