CODEWITHSUNDEEP
iisasp-classicadossl-security
ryw
ryw

Reputation: 9655

[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error

Our ASP/IIS web server talks to a SQL 2005 db server.

Eventually, without a pattern, some pages start showing error instead of the page content:

[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

Rebooting web server resolves it.

Anyone know about it?

Upvotes: 4

Views: 29592

Answers (2)

Par6
Par6

Reputation: 389

In case others happen to come across this when their certs expire and wonder why their SQL Server is giving SSL errors...

This worked for me after removing unwanted certs... setting Certificate=0 in registry:

HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib REG_SZ Certificate=0

Read more about it here: http://blogs.technet.com/b/taraj/archive/2009/01/07/sql-server-the-best-database-server-to-work-on.aspx

Upvotes: 0

AviD
AviD

Reputation: 13112

Some things you should look at:

  • Low bandwidth to the DB server (see http://support.microsoft.com/kb/322144)
  • Problematic certificates on the DB server, e.g. self-signed certificates
  • SQL Authentication mode - Windows only, or SQL and Windows

Upvotes: 2

Related Questions