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

Question

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?

Answer 1

Any resoultion or ideas about this? I am getting the same error with the same setup you have.

Thanks

Answer 2

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

Answer 3

Have you tried the steps posted here

Answer 4

Same exact issue here. Intermittent error for no particular users. SSL is not enabled, certificate value in registry is set to zero, no certificate exists under local computer / personal in the MMC for certificates.

Anyone have an idea?

Answer 5

Same problem. MS SQL Server 2008 Web Edition. No SSL cert installed on client (server has 1). Connecting via SQLOLEDB. Intermittent. Rebooting the server solves it too...