SSL Security error ConnectionOpen (SECDoClientHandshake())

SSL Security error ConnectionOpen (SECDoClientHandshake())

Post by Sorry Charli » Fri, 27 Apr 2001 12:26:11



I recently started to get error messages that look like this

SSL Security error
ConnectionOpen (SECDoClientHandshake())

That made me completely unable to connect to my SQL server. The messages
come up when I try to connect through the Enterprise Manager or through the
ODBC applet or through the coldfusion pages that use the ODBC connection.

The only error in the Window's log is this warning that appears once in the
Application log

MSSQLServer Event ID 19011
SuperSocket info (SpnRegister): Error 1355

--------------

I've tried reinstalling the SQL server but it hangs when it says it is
"starting and configuring the server" and puts the same error in the setup
log:

22:57:59 K:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe  -F
"K:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
"SQL_Latin1_General_CP1_CI_AS" -H 197126 -U sa -P
############################################################################
###

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

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

[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

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

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

[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

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

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

[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

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

SQL Server configuration failed.

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

23:00:16 Process Exit Code: (-1)

--------------------

It all appears to be some sort of SSL issue. Aside from being an sql server
the machine is also a root CA, so perhaps that is involved. Really I have no
need to use an SSL connection to the server since I am only connecting from
a local machine and I am not really concerned about security in this case.
Interestingly enough the same SSL error seems to occur when I connect via
named pipes instead of TCP/IP. I was not aware that SSL could be used over
anything besides TCP/IP. I would really just like to get the server running.
I have no need for this SSL business.

 
 
 

SSL Security error ConnectionOpen (SECDoClientHandshake())

Post by Richard Waymir » Fri, 27 Apr 2001 13:54:52


in either client network utility or server network utility on the server
someone has set the "force protocol encryption" option on and you don't have
a certificate installed in the fully qualified DNS name of the server that's
valid for SSL.  The SPN error is totally unrelated.

There is a known issue with SSL encryption being turned on and certificate
services being on the same server - this is fixed in SQL 2000 SP1.  You can
call product support to get a hotfix...

--
Richard Waymire, MCDBA, MCSE

Quote:> I recently started to get error messages that look like this

> SSL Security error
> ConnectionOpen (SECDoClientHandshake())

> That made me completely unable to connect to my SQL server. The messages
> come up when I try to connect through the Enterprise Manager or through
the
> ODBC applet or through the coldfusion pages that use the ODBC connection.

> The only error in the Window's log is this warning that appears once in
the
> Application log

> MSSQLServer Event ID 19011
> SuperSocket info (SpnRegister): Error 1355

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

> I've tried reinstalling the SQL server but it hangs when it says it is
> "starting and configuring the server" and puts the same error in the setup
> log:

> 22:57:59 K:\Program Files\Microsoft SQL

erver\80\Tools\Binn\cnfgsvr.exe  -F
Quote:> "K:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
> "SQL_Latin1_General_CP1_CI_AS" -H 197126 -U sa -P

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

- Show quoted text -

Quote:> ###

> Starting Service ...

> SQL_Latin1_General_CP1_CI_AS

> -m -Q -T4022 -T3659

> Connecting to Server ...

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> SQL Server configuration failed.

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

- Show quoted text -

Quote:> ###

> 23:00:16 Process Exit Code: (-1)

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

> It all appears to be some sort of SSL issue. Aside from being an sql
server
> the machine is also a root CA, so perhaps that is involved. Really I have
no
> need to use an SSL connection to the server since I am only connecting
from
> a local machine and I am not really concerned about security in this case.
> Interestingly enough the same SSL error seems to occur when I connect via
> named pipes instead of TCP/IP. I was not aware that SSL could be used over
> anything besides TCP/IP. I would really just like to get the server
running.
> I have no need for this SSL business.


 
 
 

SSL Security error ConnectionOpen (SECDoClientHandshake())

Post by Franklin Eugene Rhoad » Thu, 03 May 2001 06:30:05



> I recently started to get error messages that look like this

> SSL Security error
> ConnectionOpen (SECDoClientHandshake())

> That made me completely unable to connect to my SQL server. The messages
> come up when I try to connect through the Enterprise Manager or through
the
> ODBC applet or through the coldfusion pages that use the ODBC connection.

> The only error in the Window's log is this warning that appears once in
the
> Application log

> MSSQLServer Event ID 19011
> SuperSocket info (SpnRegister): Error 1355

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

> I've tried reinstalling the SQL server but it hangs when it says it is
> "starting and configuring the server" and puts the same error in the
setup
> log:

> 22:57:59 K:\Program Files\Microsoft SQL Server\80

\Tools\Binn\cnfgsvr.exe  -F
Quote:> "K:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
> "SQL_Latin1_General_CP1_CI_AS" -H 197126 -U sa -P

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

- Show quoted text -

Quote:> ###

> Starting Service ...

> SQL_Latin1_General_CP1_CI_AS

> -m -Q -T4022 -T3659

> Connecting to Server ...

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> SQL Server configuration failed.

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

- Show quoted text -

Quote:> ###

> 23:00:16 Process Exit Code: (-1)

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

> It all appears to be some sort of SSL issue. Aside from being an sql
server
> the machine is also a root CA, so perhaps that is involved. Really I
have no
> need to use an SSL connection to the server since I am only connecting
from
> a local machine and I am not really concerned about security in this
case.
> Interestingly enough the same SSL error seems to occur when I connect via
> named pipes instead of TCP/IP. I was not aware that SSL could be used
over
> anything besides TCP/IP. I would really just like to get the server
running.
> I have no need for this SSL business.

--
Posted via CNET Help.com
http://www.help.com/
 
 
 

SSL Security error ConnectionOpen (SECDoClientHandshake())

Post by Franklin Eugene Rhoad » Thu, 03 May 2001 06:30:05


Greetings,
   Are you aware that the transliteration of the Name of our Heavenly
Father and Creater ('YAHWEH') is in what you have posted? I have a website
with MANY LINKS to those that "make mention of" the Name YAHWEH at:
http://scroll.to/YAHshua .

Franklin Eugene Rhoads


> I recently started to get error messages that look like this

> SSL Security error
> ConnectionOpen (SECDoClientHandshake())

> That made me completely unable to connect to my SQL server. The messages
> come up when I try to connect through the Enterprise Manager or through
the
> ODBC applet or through the coldfusion pages that use the ODBC connection.

> The only error in the Window's log is this warning that appears once in
the
> Application log

> MSSQLServer Event ID 19011
> SuperSocket info (SpnRegister): Error 1355

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

> I've tried reinstalling the SQL server but it hangs when it says it is
> "starting and configuring the server" and puts the same error in the
setup
> log:

> 22:57:59 K:\Program Files\Microsoft SQL Server\80

\Tools\Binn\cnfgsvr.exe  -F
Quote:> "K:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q
> "SQL_Latin1_General_CP1_CI_AS" -H 197126 -U sa -P

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

- Show quoted text -

Quote:> ###

> Starting Service ...

> SQL_Latin1_General_CP1_CI_AS

> -m -Q -T4022 -T3659

> Connecting to Server ...

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> driver={sql server};server=YAHWEH;UID=sa;PWD=;database=master

> [Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

> [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
> (SECDoClientHandshake()).

> SQL Server configuration failed.

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

- Show quoted text -

Quote:> ###

> 23:00:16 Process Exit Code: (-1)

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

> It all appears to be some sort of SSL issue. Aside from being an sql
server
> the machine is also a root CA, so perhaps that is involved. Really I
have no
> need to use an SSL connection to the server since I am only connecting
from
> a local machine and I am not really concerned about security in this
case.
> Interestingly enough the same SSL error seems to occur when I connect via
> named pipes instead of TCP/IP. I was not aware that SSL could be used
over
> anything besides TCP/IP. I would really just like to get the server
running.
> I have no need for this SSL business.

--
Posted via CNET Help.com
http://www.help.com/
 
 
 

1. Install fails: SSL Security Error / ConnectionOpen (SECDoClientHandshake())

Trying to install SQL Server 2000 component from BackOffice 2000 on Windows 2000
Advanced Server.

Here are the sqlstp.log messages:

Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

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

[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error

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

... repeated twice more ...

SQL Server configuration failed.

---

I can find nothing in the knowledge base. Assistance would be appreciated.

2. backup script

3. ASP VFP Memo Fields

4. SSL Security error (??)

5. Number of Files Open on Network Limitation

6. SSL Security Error

7. Contractor Available

8. Client Force Encryption SSL Security error

9. SSL Security error

10. SQL2000: Can't connect in enterprise mgr: SSL Security Error

11. SSL Security error

12. SQL Server 2000 - [Shared Memory]SSL Security error