Additional Step for BTS 2006 Config Using Pre-June SQL CTP

In case you are installing BizTalk Server 2006 on a machine with a SQL Server 2005 CTP older than June, here's a tip. When I was trying to deploy BAM configurations, I kept getting the error "The SaveToSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.)" Apparently the June CTP build fixed an issue around security authorization and certificates. After fumbling around a bit and messing with certificates on my server, I came across a useful post that saved me.

Check out the response to this post by pmcdermott. Basically, there are just a couple steps to follow to get the SQL Server to use encryption and utilize a certificate. Once I did that, I'm golden.