SQL Server Upgrade Wizard 
Author Message
 SQL Server Upgrade Wizard

I want to transfer data from sql server 6.5 to sql server7.0.
SQL Server 6.5 installed on COMPUTER_SERVER server.
SQL Server 7.0 installed on TNL_LUMPOON server.
I have a ploblem when i use SQL Server Upgrade Wizard.
It occur error while running "Export and Import via Named Pipe" task.
It display 2 outputs file is Export and Import via Named Pipe -
019HR_TNL_L.err and
Export and Import via Named Pipe - 019HR_TNL_L.out

Everybody  help me please.
Thanks in advance.

=================================================
1. Export and Import via Named Pipe - 019HR_TNL_L.err
=================================================
The 'SQL Version Upgrade' service create failed.
Export.exe on the remote machine was hung...Export Exit Code: 259 -
export.exe -CodePage 1252 -DeviceType Pipe -AllTables yes -MasterPath
D:\MSSQL\DATA\MASTER.DAT -DatabaseName HR_TNL_L -DevicePath
\\.\pipe\~cnvpipe0Import Exit Code: -1 - ~cnvpipe0Msg 4854, Level 21, State
1, Server TNL_LAMPOON, Procedure , Line 1[Microsoft][ODBC SQL Server
Driver][SQL Server]****Time:02-17-1999 06:47:59.922Error return from
function CreateFilein file CnvPipe.cppLine=140rc=1326Msg=Result Code =
0x0000052e****

##### Wednesday, February 17, 1999 - 06:50:36 #####

Export.exe on the remote machine was hung...Export Exit Code: 259 -
export.exe -CodePage 1252 -DeviceType Pipe -AllTables yes -MasterPath
D:\MSSQL\DATA\MASTER.DAT -DatabaseName HR_TNL_L -DevicePath
\\.\pipe\~cnvpipe0Import Exit Code: -1 - ~cnvpipe0Msg 4854, Level 21, State
1, Server TNL_LAMPOON, Procedure , Line 1[Microsoft][ODBC SQL Server
Driver][SQL Server]****Time:02-17-1999 06:50:48.845Error return from
function CreateFilein file CnvPipe.cppLine=140rc=1326Msg=Result Code =
0x0000052e****
===================================================
2. Export and Import via Named Pipe - 019HR_TNL_L.out
===================================================
############################################################################
### Two Machine Data
Transfer...#################################################################
##############Checking MSSQLServer
sysmessages # 6006
[Microsoft][ODBC SQL Server Driver][SQL Server]Server SHUTDOWN by request.
sysmessages # 5702
[Microsoft][ODBC SQL Server Driver][SQL Server]The SQL Server is terminating
this process.
Stopping MSSQLServer......................
Shutdown the old server - Exit Code =
0!##########################################################################
#####
 Installing and starting the remote
service...##################################################################
#############
Checking SQL Version Upgrade
COMPUTER_SERVER SQL Version is 65COMPUTER_SERVER has 1
processors##################################################################
#############
 Installing and registering remote
files...####################################################################
###########
Files were successfully copied and registered.Master.dat was found at
'D:\MSSQL\DATA\MASTER.DAT' on COMPUTER_SERVERThis machine has 1
processors.#################################################################
##############Export Exit Code: 259 -
~cnvpipe0###################################################################
############================================================================
===============Table   : [HR_TNL_L].[dbo].[working_shift]~Rows   : 4~Pages
: 1Time    : 02-17-1999
06:48:02####################################################################
###########Import Exit Code: -1 -
~cnvpipe0###################################################################
############################################################################
###############
 Performing
cleanup...##################################################################
#############
Checking MSSQLServer
Starting
MSSQLServer.................................................................
............................................................................
...............
Waiting for recovery.sysmessages # 4002
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed
Checking SQL Version Upgrade
Checking SQL Version Upgrade
Stopping SQL Version Upgrade.
The 'SQL Version Upgrade' service was removed successfully.

##### Wednesday, February 17, 1999 - 06:50:36 #####

############################################################################
### Two Machine Data
Transfer...#################################################################
##############Checking MSSQLServer
sysmessages # 6006
[Microsoft][ODBC SQL Server Driver][SQL Server]Server SHUTDOWN by request.
sysmessages # 5702
[Microsoft][ODBC SQL Server Driver][SQL Server]The SQL Server is terminating
this process.
Stopping MSSQLServer.....................
Shutdown the old server - Exit Code =
0!##########################################################################
#####
 Installing and starting the remote
service...##################################################################
#############
The 'SQL Version Upgrade' service was created successfully.
Checking SQL Version Upgrade
Starting SQL Version Upgrade.
COMPUTER_SERVER SQL Version is 65COMPUTER_SERVER has 1
processors##################################################################
#############
 Installing and registering remote
files...####################################################################
###########
Files were successfully copied and registered.Master.dat was found at
'D:\MSSQL\DATA\MASTER.DAT' on COMPUTER_SERVERThis machine has 1
processors.#################################################################
##############Export Exit Code: 259 -
~cnvpipe0###################################################################
############================================================================
===============Table   : [HR_TNL_L].[dbo].[working_shift]~Rows   : 4~Pages
: 1Time    : 02-17-1999
06:50:51####################################################################
###########Import Exit Code: -1 -
~cnvpipe0###################################################################
############################################################################
###############
 Performing
cleanup...##################################################################
#############
Checking MSSQLServer
Starting
MSSQLServer.................................................................
............................................................................
...............
Waiting for recovery.sysmessages # 4002
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed
Checking SQL Version Upgrade
Checking SQL Version Upgrade
Stopping SQL Version Upgrade.
The 'SQL Version Upgrade' service was removed successfully.



Sun, 05 Aug 2001 03:00:00 GMT
 SQL Server Upgrade Wizard

Most likely, you have changed your domain password, or the same user id has
a different password on the other machine since the error means:

//
// MessageId: ERROR_LOGON_FAILURE
//
// MessageText:
//
//  Logon failure: unknown user name or bad password.
//
#define ERROR_LOGON_FAILURE              1326L

-GertD



Sun, 05 Aug 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. SQL Server Upgrade Wizard - SQL Server 7.0

2. SQL Server Upgrade Wizard Hangs. (SQL 7 RTM)

3. SQL Server upgrade Wizard

4. Error when using SQL Server Upgrade Wizard

5. SQL Server Upgrade Wizard Fails During Import/Export

6. SQL Server Upgrade Wizard error

7. SQL Server Upgrade Wizard

8. SQL Server Upgrade Wizard

9. SQL Server Upgrade Wizard 6.5 to 7.0

10. SQL server Upgrade Wizard

11. SQL Server Upgrade Wizard

12. problem upgrading more than 1 server with sql server 2000 upgrade wizard


 
Powered by phpBB® Forum Software