SQL 6.5 upgrade to 7 faild --Specified SQL server not found ConnectOpen(Creatfile())

[shawn]

i installed SQL 7.0 on my 6.5 machine and when install completed and reboot. then the SQL Upgrade Wizard run automatically and after i choose data transfer method(named pipe) and the 6.x server name and 7.0 servername and choose next,then the Upgrade Wizard shows

"Switching to SQL server 7.0 ...."
"Restarting MSSQLserver service ..."
"Gather information from ..."
"Switching to SQL server 6.x ...."
"Restarting MSSQLserver service ..."

then the SQL Upgrade Wizard gives the following msg

"An error occured on "SQL_SERVER",specified SQL server not found ConnectOpen(Creatfile())."

and

"An error occured while trying to querry @@servername on 'SQL_SERVER' please make sure that value is not NULL."

and when i tried to switch to SQL 6.5 mannually the 6.5 service can't start with the same error occured, the enterprise manager says can't connect to server "SQL_SERVER"

my computer have windows nt sp4 and ie4.01 sp1 and SQL 6.5 with sp4 installed.

any ideas?

[Ray Miao]

Sounds your sql 6.5's master db doesn't have sql server name in sysservers table. I'll try to copy master.dat file to another sql 6.5 server, start the server and run sp_addserver to modify sysservers table. Then copy the master.dat file back.


------------
shawn at 5/31/99 12:01:09 PM

i installed SQL 7.0 on my 6.5 machine and when install completed and reboot. then the SQL Upgrade Wizard run automatically and after i choose data transfer method(named pipe) and the 6.x server name and 7.0 servername and choose next,then the Upgrade Wizard shows

"Switching to SQL server 7.0 ...."
"Restarting MSSQLserver service ..."
"Gather information from ..."
"Switching to SQL server 6.x ...."
"Restarting MSSQLserver service ..."

then the SQL Upgrade Wizard gives the following msg

"An error occured on "SQL_SERVER",specified SQL server not found ConnectOpen(Creatfile())."

and

"An error occured while trying to querry @@servername on 'SQL_SERVER' please make sure that value is not NULL."

and when i tried to switch to SQL 6.5 mannually the 6.5 service can't start with the same error occured, the enterprise manager says can't connect to server "SQL_SERVER"

my computer have windows nt sp4 and ie4.01 sp1 and SQL 6.5 with sp4 installed.

any ideas?

cause the server is our kernel database server, so i just restore the old system from my tape backup. then i do the following

in a new test machine i installed 6.5 and 6.5 sp4 and install 7,before install 7 i backup 6.5's master.dat and msdb.dat and msdblog.dat file. After 7 installed there are 2 same errors in the application event log

can't find the source ( SQLCTR70 ) description about ID ( 1001 ), it includes the following string:Cannot open the Registry Key..

but sql 7 can run normally,then i switch to 6.5,and the same error occured and in the application event of windows NT have such a error

can't find the source ( MSSQLServer ) description about ID ( 17055 ), it includes the following string:17113, initconfig: error 2(system can't find certain file) opening 'master.dat' for config information.

then i start sql 6.5 in minimun config mode and run sp_addserver 'SQL_SERVER' ,but it said the server 'SQL_SERVER' already exist. and i run select @@servername the result is "SQL_SERVER'. but when i open the enterprose manager or service manager it still say no such server.

then i copy back my backup files to 6.5's data directory and the problem is still there,now what?

(all my windows nt , nt sp4 and ie sp1 is simplified chinese version,and my code page is 936)

The following is the errorlog file in mssqllog directory

99/06/01 23:18:57.43 kernel Microsoft SQL Server 6.50 - 6.50.281 (Intel X86)
Nov 4 1997 17:58:00
Copyright (c) 1988-1997 Microsoft Corporation

99/06/01 23:18:57.49 kernel Copyright (C) 1988-1994 Microsoft Corporation.
99/06/01 23:18:57.49 kernel All rights reserved.
99/06/01 23:18:57.49 kernel Logging SQL Server messages in file 'E:MSSQLLOGERRORLOG'
99/06/01 23:18:57.53 kernel Warning: -f command line flag used...minimal server configured.
99/06/01 23:18:57.64 kernel initconfig: number of user connections limited to 5
99/06/01 23:18:57.64 kernel SQL Server is starting at priority class 'normal' with dataserver semaphore = 1 (1 CPU detected, SMPStat=1).
99/06/01 23:18:57.66 server LogLRU buffers: 0
99/06/01 23:18:57.67 kernel DTC initialization skipped because of startup option
99/06/01 23:18:57.69 kernel initializing virtual device 0, E:MSSQLDATAMASTER.DAT
99/06/01 23:18:57.71 spid1 WARNING ******************
99/06/01 23:18:57.76 spid1 SQL Server booted single user mode - updates allowed to system catalogs
99/06/01 23:18:57.76 spid1 WARNING ******************
99/06/01 23:18:57.76 kernel Opening Master Database ...
99/06/01 23:18:57.96 spid1 Loading SQL Server's default sort order and character set
99/06/01 23:18:58.02 spid1 Recovering Database 'master'
99/06/01 23:18:58.06 spid1 Recovery dbid 1 ckpt (8010,10) oldest tran=(8010,9)
99/06/01 23:18:58.12 spid1 1 transactions rolled forward
99/06/01 23:18:58.20 spid1 Activating disk 'MSDBData'
99/06/01 23:18:58.20 kernel initializing virtual device 127, E:MSSQLDATAMSDB.DAT
99/06/01 23:18:58.21 spid1 Activating disk 'MSDBLog'
99/06/01 23:18:58.21 kernel initializing virtual device 126, E:MSSQLDATAMSDBLOG.DAT
99/06/01 23:18:58.23 spid1 server name is 'NS1'
99/06/01 23:18:58.26 spid1 Recovering database 'model'
99/06/01 23:18:58.27 spid1 Recovery dbid 3 ckpt (338,0) oldest tran=(339,0)
99/06/01 23:18:58.30 spid1 Clearing temp db
99/06/01 23:18:58.43 kernel initializing virtual device 1, IN_RAM
99/06/01 23:18:58.86 kernel Read Ahead manager disabled.
99/06/01 23:18:58.87 kernel Using 'SQLEVN60.DLL' version '6.00.000'.
99/06/01 23:18:59.01 kernel Using 'OPENDS60.DLL' version '6.00.01.02'.
99/06/01 23:18:59.01 kernel Using 'NTWDBLIB.DLL' version '6.50.252'.
99/06/01 23:18:59.05 ods Using 'SSNMPN60.DLL' version '6.5.0.0' to listen on '\.pipesqlquery'.
99/06/01 23:18:59.05 ods Using 'SSMSRP60.DLL' version '6.5.0.0' to listen on ''.
99/06/01 23:19:00.69 ods Using 'SSMSSO60.DLL' version '6.5.0.0' to listen on '1433'.
99/06/01 23:19:00.88 spid1 Recovering database 'msdb'
99/06/01 23:19:00.90 spid1 Recovery dbid 4 ckpt (3594,5) oldest tran=(3594,4)
99/06/01 23:19:00.92 spid1 1 transactions rolled forward in dbid 4.
99/06/01 23:19:00.98 spid1 Recovering database 'pubs'
99/06/01 23:19:00.99 spid1 Recovery dbid 5 ckpt (865,12) oldest tran=(865,11)
99/06/01 23:19:01.01 spid1 1 transactions rolled forward in dbid 5.
99/06/01 23:19:01.01 spid1 Recovery complete.
99/06/01 23:19:01.07 spid1 SQL Server's default sort order is:
99/06/01 23:19:01.07 spid1 'nls_cp936' (ID = 199)
99/06/01 23:19:01.07 spid1 on top of default character set:
99/06/01 23:19:01.07 spid1 'cp936' (ID = 14)
99/06/01 23:19:01.09 kernel Warning: override, autoexec procedures skipped.




------------
Ray Miao at 6/1/99 7:19:28 AM

Sounds your sql 6.5's master db doesn't have sql server name in sysservers table. I'll try to copy master.dat file to another sql 6.5 server, start the server and run sp_addserver to modify sysservers table. Then copy the master.dat file back.

[SFogli]

When you register the 6.5 server within the EM do you have to register as (local), or do you register as SQL_SERVERNAME? Do you see the MSDTC as an option within EM? I had a similar experience that was due to the account that I had created for the services to run as. Do you have them set to run as local system account? If so try changing this to domain accounts and then try again.

------------
at 6/1/99 10:17:09 AM

cause the server is our kernel database server, so i just restore the old system from my tape backup. then i do the following

in a new test machine i installed 6.5 and 6.5 sp4 and install 7,before install 7 i backup 6.5's master.dat and msdb.dat and msdblog.dat file. After 7 installed there are 2 same errors in the application event log

can't find the source ( SQLCTR70 ) description about ID ( 1001 ), it includes the following string:Cannot open the Registry Key..

but sql 7 can run normally,then i switch to 6.5,and the same error occured and in the application event of windows NT have such a error

can't find the source ( MSSQLServer ) description about ID ( 17055 ), it includes the following string:17113, initconfig: error 2(system can't find certain file) opening 'master.dat' for config information.

then i start sql 6.5 in minimun config mode and run sp_addserver 'SQL_SERVER' ,but it said the server 'SQL_SERVER' already exist. and i run select @@servername the result is "SQL_SERVER'. but when i open the enterprose manager or service manager it still say no such server.

then i copy back my backup files to 6.5's data directory and the problem is still there,now what?

(all my windows nt , nt sp4 and ie sp1 is simplified chinese version,and my code page is 936)

The following is the errorlog file in mssqllog directory

99/06/01 23:18:57.43 kernel Microsoft SQL Server 6.50 - 6.50.281 (Intel X86)
Nov 4 1997 17:58:00
Copyright (c) 1988-1997 Microsoft Corporation

99/06/01 23:18:57.49 kernel Copyright (C) 1988-1994 Microsoft Corporation.
99/06/01 23:18:57.49 kernel All rights reserved.
99/06/01 23:18:57.49 kernel Logging SQL Server messages in file 'E:MSSQLLOGERRORLOG'
99/06/01 23:18:57.53 kernel Warning: -f command line flag used...minimal server configured.
99/06/01 23:18:57.64 kernel initconfig: number of user connections limited to 5
99/06/01 23:18:57.64 kernel SQL Server is starting at priority class 'normal' with dataserver semaphore = 1 (1 CPU detected, SMPStat=1).
99/06/01 23:18:57.66 server LogLRU buffers: 0
99/06/01 23:18:57.67 kernel DTC initialization skipped because of startup option
99/06/01 23:18:57.69 kernel initializing virtual device 0, E:MSSQLDATAMASTER.DAT
99/06/01 23:18:57.71 spid1 WARNING ******************
99/06/01 23:18:57.76 spid1 SQL Server booted single user mode - updates allowed to system catalogs
99/06/01 23:18:57.76 spid1 WARNING ******************
99/06/01 23:18:57.76 kernel Opening Master Database ...
99/06/01 23:18:57.96 spid1 Loading SQL Server's default sort order and character set
99/06/01 23:18:58.02 spid1 Recovering Database 'master'
99/06/01 23:18:58.06 spid1 Recovery dbid 1 ckpt (8010,10) oldest tran=(8010,9)
99/06/01 23:18:58.12 spid1 1 transactions rolled forward
99/06/01 23:18:58.20 spid1 Activating disk 'MSDBData'
99/06/01 23:18:58.20 kernel initializing virtual device 127, E:MSSQLDATAMSDB.DAT
99/06/01 23:18:58.21 spid1 Activating disk 'MSDBLog'
99/06/01 23:18:58.21 kernel initializing virtual device 126, E:MSSQLDATAMSDBLOG.DAT
99/06/01 23:18:58.23 spid1 server name is 'NS1'
99/06/01 23:18:58.26 spid1 Recovering database 'model'
99/06/01 23:18:58.27 spid1 Recovery dbid 3 ckpt (338,0) oldest tran=(339,0)
99/06/01 23:18:58.30 spid1 Clearing temp db
99/06/01 23:18:58.43 kernel initializing virtual device 1, IN_RAM
99/06/01 23:18:58.86 kernel Read Ahead manager disabled.
99/06/01 23:18:58.87 kernel Using 'SQLEVN60.DLL' version '6.00.000'.
99/06/01 23:18:59.01 kernel Using 'OPENDS60.DLL' version '6.00.01.02'.
99/06/01 23:18:59.01 kernel Using 'NTWDBLIB.DLL' version '6.50.252'.
99/06/01 23:18:59.05 ods Using 'SSNMPN60.DLL' version '6.5.0.0' to listen on '\.pipesqlquery'.
99/06/01 23:18:59.05 ods Using 'SSMSRP60.DLL' version '6.5.0.0' to listen on ''.
99/06/01 23:19:00.69 ods Using 'SSMSSO60.DLL' version '6.5.0.0' to listen on '1433'.
99/06/01 23:19:00.88 spid1 Recovering database 'msdb'
99/06/01 23:19:00.90 spid1 Recovery dbid 4 ckpt (3594,5) oldest tran=(3594,4)
99/06/01 23:19:00.92 spid1 1 transactions rolled forward in dbid 4.
99/06/01 23:19:00.98 spid1 Recovering database 'pubs'
99/06/01 23:19:00.99 spid1 Recovery dbid 5 ckpt (865,12) oldest tran=(865,11)
99/06/01 23:19:01.01 spid1 1 transactions rolled forward in dbid 5.
99/06/01 23:19:01.01 spid1 Recovery complete.
99/06/01 23:19:01.07 spid1 SQL Server's default sort order is:
99/06/01 23:19:01.07 spid1 'nls_cp936' (ID = 199)
99/06/01 23:19:01.07 spid1 on top of default character set:
99/06/01 23:19:01.07 spid1 'cp936' (ID = 14)
99/06/01 23:19:01.09 kernel Warning: override, autoexec procedures skipped.




------------
Ray Miao at 6/1/99 7:19:28 AM

Sounds your sql 6.5's master db doesn't have sql server name in sysservers table. I'll try to copy master.dat file to another sql 6.5 server, start the server and run sp_addserver to modify sysservers table. Then copy the master.dat file back.