I just spent an hour to figure out why I couldn’t get BizTalk 2009 installed on my test machine. I finally figured it out and want to share this information so that you don’t have to waste more time on this problem than necessary.
After installing BizTalk you run through the BizTalk Configuration Wizard. Either in Basic or Custom mode you specify the SQL Server that will host the Enterprise Single-Sign On Database (SSODB). For an unexplainable reason I constantly ran into the error message Failed to connect to the SQL database ‘SSODB’ on SQL Server ‘MYSERVER’. I double checked security settings, SQL Server Protocol settings, event logs, … – I finally found the solution in the following post by Michael Carr. You have to register the assembly SSOSQL.DLL with the Assembly Registration Tool (regasm). Here is the call to this tool I had to execute:
"C:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe" "C:\Program Files\Common Files\Enterprise Single Sign-On\ssosql.dll"
The path to REGASM.EXE depends on your installed version of the .NET Framework. The path to SSOSQL.DLL should be under Common Files\Enterprise Single Sign-on. After registering this assembly the BizTalk Configuration worked as expected. I am not sure whether this problem happens on every installation or if it has to do with the fact that I already run .NET 4.0 on my machine causing the BizTalk Installer not to find the regasm tool.
Information for 64Bit Windows Users
On 64Bit systems you have to use the 64bit version of regasm, e.g: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm.exe
Hope this information finds those that struggle with the same problem.