Here is the error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.
I am running SQL Server 2008 R2
I have tried to debug this and it doesn't seem to be related to anything. It pops up about once a day and the way to reactivate the application is by restarting IIS.
The connection to the db is remote and this is the string I use:
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=SQLOLEDB; Data Source=126.96.36.199; Initial Catalog=database; User ID=dbID; Password=password"