Problems upgrading from 6.5 to 70...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Problems upgrading from 6.5 to 70...

Author

Topic

RobMarsh
Starting Member

28 Posts

Posted - 2002-05-09 : 13:35:43

Hi,
I'm having hassle running the upgrade from SQL 6.5 to 7.0

During the Export & Import via Named Pipe stage, and error comes up claiming there is an invalid login. I've been throught the checklist and I can't see what is causing this.

There are two files generated by the error are 003model.out (the process log file) & 003model.err (the error log). the log

003 model.out (summarised):

Two Machine Data Transfer...
Installing and registering remote files...
Files were successfully copied and registered.
Master.dat was found at 'C:\MSSQL\DATA\MASTER.DAT' on BHONTSQL02
This machine has 2 processors.

###################################################################
Export Exit Code: 259 - ~cnvpipe0
###################################################################

###################################################################
Import Exit Code: -1 - ~cnvpipe0
###################################################################

###################################################################
Export Exit Code: 259 - ~cnvpipe1
###################################################################

##################################################################
Import Exit Code: -1 - ~cnvpipe1
###################################################################
Performing cleanup...

003model.out:
Export.exe on the remote machine was hung...
Export Exit Code: 259 - export.exe -CodePage 850 -DeviceType Pipe -AllTables yes -MasterPath C:\MSSQL\DATA\MASTER.DAT -DatabaseName model -DevicePath \\.\pipe\~cnvpipe0
Import Exit Code: -1 - ~cnvpipe0
Msg 4854, Level 21, State 1, Server BHONTSQL09, Procedure , Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]****
Time:05-09-2002 13:58:47.078
Error return from function CreateFile
in file CnvPipe.cpp
Line=140
rc=1326
Msg=Logon failure: unknown user name or bad password.

****

Export.exe on the remote machine was hung...
Export Exit Code: 259 - export.exe -CodePage 850 -DeviceType Pipe -AllTables yes -MasterPath C:\MSSQL\DATA\MASTER.DAT -DatabaseName model -DevicePath \\.\pipe\~cnvpipe1
Import Exit Code: -1 - ~cnvpipe1
Msg 4854, Level 21, State 1, Server BHONTSQL09, Procedure , Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]****
Time:05-09-2002 13:58:47.078
Error return from function CreateFile
in file CnvPipe.cpp
Line=140
rc=53
Msg=The network path was not found.

****

This is driving me barmy as I don't know which login or password is incorrect to set. The Server processes are being run by an account with domain admin rights, so that isn't it...

Any Ideas?

Rob

chadmat
The Chadinator

1974 Posts

Posted - 2002-05-10 : 02:44:58

Your friendly neighborhood KB-Man to the rescue:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q302850&SD=MSKB&

-Chad

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-05-10 : 14:08:35

quote:
friendly neighborhood KB-Man

Hmmmm... I see a custom title in Chad's future...

RobMarsh
Starting Member

28 Posts

Posted - 2002-05-20 : 08:51:13

Just a quick (and belated) thank you for the help on that one - I have a nice working 7.0 Database now - next month we go to 2000...

and another thank you to Microsoft for not returning that link when I searched the site..

chadmat
The Chadinator

1974 Posts

Posted - 2002-05-20 : 14:34:00

Came right up for me