Enterprise Single Sign-On not working

I encountered the following problems when installing BizTalk 2009 on a Windows 7 64-bit environment. The SSO (Enterprise Single Sign-On) wasn’t able to connect to the database at first, and after fixing that, I encountered the second entry in the event log.

1. Failed to connect to the SQL database ‘SSODB’ on SQL Server ‘MCARR’0×80131700 (Win32)
2. Could not create SSOSQL. To fix the problem, reinstall SSO or try ‘regasm SSOSQL.dll’ from a Visual Studio command prompt.Error Code: 0×80131700
3. The SSO service failed to start.Error Code: 0×80131700

To fix the first error you should use the resolution mentioned in the second. Use regasm to register SSOSQL. Allthough, when dealing with a 64-bit system you should explicitely use the 64-bit version of regasm. I didn’t do that the first time, so after registering the DLL to solve problem 1, problem 2 and 3 came up. To register it with the 64-bit regasm, start the visual studio command prompt and use the following line of code (replace the slash with a backslash, WP is messing with my backslashes!):

C:/windows/microsoft.net/Framework64/v2.0.50727/regasm.exe “C:/Program Files/Common Files/Enterprise Single Sign-On/SSOSQL.dll”

This finally fixed the (pretty annoying) problem. Hopefully it helps others as well.