SSO Problem :- Failed to connect to the SQL database 'SSODB' on SQL Server 'VPC-XXXXXXXX'. (SSO)

Problem: - Failed to connect to the SQL database 'SSODB' on SQL Server 'VPC-XXXXXXXXX'. (SSO)

Reason / Cause: - This issue occurs after installing .NET Framework 4.0. The registration of the assembly used by ENTSSO to access SQL Server (SSOSQL.dll) does not specify the correct version of the .NET Framework.  When .NET Framework 4.0 is installed, the assembly will try to use the newer framework and then fail to load.

Solution: -

1.      Download ESSOv4-KB2252691-x64-ENU.exe from http://support.microsoft.com/kb/2252691 (Make sure that you download 64 bit or 32 bit depending upon your system)

2.      Install it on the BizTalk Server.

3.      Start Visual Studio Command Prompt

4.      Run C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm.exe  "C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll"
(Make sure that you are referring to latest .NET framework RegAsm.exe)

5.      Now try Configuring BizTalk Server and Bingo you are done.