Solving problems with SSODB during BizTalk 2009 Configuration
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.
Thanks man…saved my day with this tip.
I totally agree that bringing down the number of resources is the key here. My point is that you have to know and monitor your connections (consuming handles,RAM) BEFORE switching on keep-alive. Otherwise you risk a complete outage. I’ve seen exactly this case before, that’s why I wanted to mention.
Wow… this was a great help. I have been trying to fix this for almost a day. I tried everything including re-install. I fixed my issue.
Thanks
+1 from me!
This worked for me as well.
Hi,
thanx I found your solution but somehow it did not work for me. I read somewhere that UAC could play a role, so I did shut that one out, but still I could not get BTS to install. Then I found the original support article
http://support.microsoft.com/kb/2252691
In there I found that if you experience this problem on a 64 bit machine (thats me ok) you must regasm BOTH the 32 & 64 version of SSOSQL.dll
Hope this helps any one!
Thanks! Had the exact same problem, this solved it!