So the Chief tells me that we need to get on BizTalk 2k6 for our internal use and to start migrating our client demos. As I previously reported before, LCS works perfectly fine with Sql2k5, so I thought I would use Sql2k5 for my BizTalk box.
Big mistake.
Unfortuantely, I couldn't get BizTalk to work with the Sql 2k5 CTP release (the one that ships with VS.NET 2k5 - which is required for BizTalk 2k6). Install proper completed normally, but configuration kept failing. I tried various configuration settings, but Enterprise Single Sign On kept failing, and consequently the BizTalk Runtime Engine kept failing. All of the other components managed to configure correctly, which struck me as odd, because I know that they also add databases to SQL Server.
I tried to install about four times unsucessfully (which wasn't that time consuming since I was using VPC w/ undo disks). After the last time, I broke down and installed Sql 2000 sp3a, and with the same configuration settings, it worked. Nothing was different except the version of Sql Server.
It says in the BizTalk documentation that it requires Sql2k, but it also mentions later some things about installing it with Yukon (Sql 2k5). It's pretty unclear about whether it's supported or not, so I'm here to post that I don't think that BizTalk 2k6 works with the Sql 2k5 CTP release.
If anyone has gotten it to work, please let me know.