Microsoft KB Archive/302850

= PRB: Upgrade to SQL Server 7.0 or SQL Server 2000 fails during &quot;Import and Export&quot; step =

Article ID: 302850

Article Last Modified on 11/17/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



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 .err
 * Import and Export via Named Pipe - 00n .out

The Import and Export via Named Pipe - 00n .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 .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.