PRB: Upgrade to SQL Server 7.0 or SQL Server 2000 fails during "Import and Export" step (302850)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
This article was previously published under Q302850

SYMPTOMS

When you upgrade a SQL Server 6.5 server to SQL Server 7.0 or SQL Server 2000 by using the Upgrade Wizard, the Import and Export via Named Pipe task may fail, and the following informational files are referenced:
  • Import and Export via Named Pipe - 00n<dbname>.err
  • Import and Export via Named Pipe - 00n<dbname>.out
The Import and Export via Named Pipe - 00n<dbname>.err file contains the following error messages:
Error return from function CreateFile
in file CnvPipe.cpp
Line=140
rc=1326
Msg=Logon failure: unknown user name or bad password.
The Import and Export via Named Pipe - 00n<dbname>.out file contains the following error message:
Export Exit Code: 259 - ~cnvpipe0

CAUSE

The SQL Server 6.5, SQL Server 7.0 or SQL Server 2000 service startup account is either a local Microsoft Windows NT account or the LocalSystem account.

WORKAROUND

The service startup account for the MSSQLServer service startup account for both SQL Server instances involved in the upgrade must be a domain account that is a member of the local Administrators group on both computers. Also, the account that you use to log in to the SQL Server 7.0 or SQL Server 2000 server to run the Upgrade Wizard utility must be an administrator on the computer that is running SQL Server 6.5. The easiest way to ensure that these requirements are met is to perform the following steps:
  • Create a new domain account.
  • Explicitly add this domain account to the local Administrators group on both the SQL Server 6.5 and the SQL Server 7.0 or SQL Server 2000 servers.
  • Change the service startup account for the MSSQLServer service on both servers to use this account.
  • To run the Upgrade Wizard, log into the local Windows NT computer on the SQL Server 7.0 or SQL Server 2000 server with this account.

REFERENCES

For additional information and other considerations when you upgrade from SQL Server 6.5, refer to the "Before Upgrading: Checklist" (if using SQL Server 7.0)" topic or to the "Preparing to Upgrade from SQL Server 6.5" (if using SQL Server 2000) topic in SQL Server Books Online.
Modification Type:MajorLast Reviewed:11/17/2004
Keywords:kbprb KB302850
©2004 Microsoft Corporation. All rights reserved.