Problems with Upgrade of SQL 7.0 to SQL 2000

  • 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.

    =============================================

    Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA

  • Looks like you didnt provide an SA password - it is really blank?

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply