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 with Upgrading 7.0 to 2000

Author  Topic 

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2001-10-01 : 13:19:53
Any insight to this might be helpful....

While trying to upgrade to SQL 2000 from 7.0, I ran into this problem repeatedly:
=========================================
13:07:30 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINNT2\sqlstp.log" -I PARESH -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 131600 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=PARESH\PARESH;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECDoClientHandshake()).

driver={sql server};server=PARESH\PARESH;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECDoClientHandshake()).

driver={sql server};server=PARESH\PARESH;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error

[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (SECDoClientHandshake()).

SQL Server configuration failed.

###############################################################################

13:09:43 Process Exit Code: (-1)
13:09:57 Setup failed to configure the server. Refer to the server error logs and C:\WINNT2\sqlstp.log for more information.
13:09:57 Action CleanUpInstall:
13:09:57 C:\WINNT2\Profiles\SU_MOT~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service SQLAgent$PARESH
13:09:57 Process Exit Code: (1060) The specified service does not exist as an installed service.

13:09:57 C:\WINNT2\Profiles\SU_MOT~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe -Silent 1 -Action 4 -Service MSSQL$PARESH
13:09:57 Process Exit Code: (0)
13:09:57 StatsGenerate returned: 2
13:09:57 StatsGenerate (0x0,0x1,0xf0000000,0x200,1033,303,0x0,0x1,0,0,0
13:09:57 StatsGenerate -1,su_motiwala)
13:09:57 Installation Failed.
=============================================



   

- Advertisement -