Very Computer

I am encountering a problem installing SQL Server 2000 Std onto a windows 2000
server. The complete installation log is attached, the point where install fails
is as follows:

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

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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.

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

17:49:51 Process Exit Code: (-1)

Has anyone encountered this problem and found a resolution?

Thank you!

Matt Young

Quote:-----Original Message-----

I am encountering a problem installing SQL Server 2000 Std onto a windows 2000
server. The complete installation log is attached, the point where install fails
is as follows:

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

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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.

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

17:49:51 Process Exit Code: (-1)

Has anyone encountered this problem and found a resolution?

Thank you!

Matt Young

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

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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.

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

17:49:51 Process Exit Code: (-1)

Has anyone encountered this problem and found a resolution?

Thank you!

Matt Young

Nope, full release of SQL 2000 Server Standard Edition.

Quote:-----Original Message-----

I have the same problem... are using the BETA?

-----Original Message-----
I am encountering a problem installing SQL Server 2000 Std onto a windows 2000
server. The complete installation log is attached, the point where install fails
is as follows:

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

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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.

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

17:49:51 Process Exit Code: (-1)

Has anyone encountered this problem and found a resolution?

Thank you!

Matt Young

.

I am encountering a problem installing SQL Server 2000 Std onto a windows
2000
server. The complete installation log is attached, the point where install
fails
is as follows:

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

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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.

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

17:49:51 Process Exit Code: (-1)

Has anyone encountered this problem and found a resolution?

Thank you!

Matt Young

There is an entry on 11/8 in this newsgroup with this exact "SSL error"
which has the Subject entitled:
"cnfgsvr.exe fails during setup with SSL Security errors".  The solution was
to uninstall the Certificate Authority.

I have the same problem... are using the BETA?

Quote:-----Original Message-----

I am encountering a problem installing SQL Server 2000 Std onto a windows
2000
server. The complete installation log is attached, the point where install
fails
is as follows:

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

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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=SIGMOND\PROJECT1;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.

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

17:49:51 Process Exit Code: (-1)

Has anyone encountered this problem and found a resolution?

Thank you!

Matt Young

Hi Matt!

   It is a known issue for SQL 2000 on Windows 2000.
The problem pertains to Certificate services on your
Windows 2000 box.

   Steps to resolve the problem are very simple.

   Make sure you do one of the following, as these
   pertain to different cases that have come in, to
   this point:

Route #1:
=========
   1) Click on Start, Run... MMC

   2) Console, Add/Remove Snap-In

   3) Add, Certificates, Add, Computer Account,
      Local Computer, Finish, Close, OK

   If this doesn't work, you may need to reinstall MMC
   and try it again.

Route #2:
=========

   1) Reboot the machine, if the above fails, as it might
      because the MDAC files that are required for the
      installation of SQL 2000, are in use.

Route #3:
=========
   The installation of SQL 2000 could fail if the drive to
   which sql server is being installed does not have the
   SYSTEM Account with Full Permissions.

   Resolution:

   -----------

   1. Right click on the drive and choose properties

   2. choose Security --> Permissions

   3. Add the SYSTEM Account with Full Permissions to the
      partition, on which SQL will be installed

   4. Then perform a clean uninstall and reboot the machine

   That should help you cross the border

Route #4:
=========
   The problem could be because your NTFS permissions are
   not set right.

   1. Check to make sure that your NTFS permission on the
      drive, on which you are trying to install SQL Server
      is set to FULL CONTROL.
   2. Give local administrator -> full control,
                 Everyone -> Full Control,
                 and SYSTEM -> full control

   3. Make sure that the 'Replace permissions on
      subdirectories' is checked.

   4. Basically, as long as the NT account that installs has
      full control in the root directory and all
      subdirectories, it should work

   5. Installation should now go through successfully

Actually, one of these methods suggested should help you
resolve the problem. Make sure that the account that
the setup is run with has FULL CONTROL on the partitions
on the system, also make sure that the user who is
trying to run the install is the SYSADMIN, on the box.

Matt

Quote:

> Hi Matt!

>    It is a known issue for SQL 2000 on Windows 2000.
> The problem pertains to Certificate services on your
> Windows 2000 box.

>    Steps to resolve the problem are very simple.

>    Make sure you do one of the following, as these
>    pertain to different cases that have come in, to
>    this point:

> Route #1:
> =========
>    1) Click on Start, Run... MMC

>    2) Console, Add/Remove Snap-In

>    3) Add, Certificates, Add, Computer Account,
>       Local Computer, Finish, Close, OK

>    If this doesn't work, you may need to reinstall MMC
>    and try it again.

> Route #2:
> =========

>    1) Reboot the machine, if the above fails, as it might
>       because the MDAC files that are required for the
>       installation of SQL 2000, are in use.

> Route #3:
> =========
>    The installation of SQL 2000 could fail if the drive to
>    which sql server is being installed does not have the
>    SYSTEM Account with Full Permissions.

>    Resolution:

>    -----------

>    1. Right click on the drive and choose properties

>    2. choose Security --> Permissions

>    3. Add the SYSTEM Account with Full Permissions to the
>       partition, on which SQL will be installed

>    4. Then perform a clean uninstall and reboot the machine

>    That should help you cross the border

> Route #4:
> =========
>    The problem could be because your NTFS permissions are
>    not set right.

>    1. Check to make sure that your NTFS permission on the
>       drive, on which you are trying to install SQL Server
>       is set to FULL CONTROL.
>    2. Give local administrator -> full control,
>                  Everyone -> Full Control,
>                  and SYSTEM -> full control

>    3. Make sure that the 'Replace permissions on
>       subdirectories' is checked.

>    4. Basically, as long as the NT account that installs has
>       full control in the root directory and all
>       subdirectories, it should work

>    5. Installation should now go through successfully

> Actually, one of these methods suggested should help you
> resolve the problem. Make sure that the account that
> the setup is run with has FULL CONTROL on the partitions
> on the system, also make sure that the user who is
> trying to run the install is the SYSADMIN, on the box.

Thanks!
R.