[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

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