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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions) SP3
  • Microsoft SQL Server, Enterprise Edition 6.5, when used with:
    • the operating system: Microsoft Windows NT
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<dbname>.err
Export and Import via Named Pipe - 00n<dbname>.out



An error message, similar to the following, is logged in the 00n<dbname>.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 <dbname> -DevicePath \\.\pipe\~cnvpipe0
Import Exit Code: -1 - ~cnvpipe0
Msg 4854, Level 21, State 1, Server <Server Name>, 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:
    1. 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.
    2. On a Windows NT-based computer, back up the SQL Server 6.5 databases.
    3. On a Windows 2000-based computer, restore the backup of the SQL Server 6.5 databases you retrieved from the Windows NT-based computer.
    4. On the Windows 2000-based computer, install SQL Server 2000 with Service Pack 3.
    5. On the Windows 2000-based computer, upgrade the SQL Server 6.5 databases to SQL Server 2000 SP3.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

302850 PRB: Upgrade from SQL Server 6.5 Fails During "Import and Export" Step

Modification Type:MajorLast Reviewed:12/3/2003
Keywords:kberrmsg kbUpgrade kbbug KB818550 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.