Enterprise Single Sign-On Service not getting started on BizTalk 2006 R2

PROBLEM DESCRIPTION

After installing the .NET framework 4.0, I wasn't able to start the Enterprise Single SignOn service for BizTalk 2006 R2. The ENTSSO services were failing with the following error message:

Event Type:    Error
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7023
Description:
The Enterprise Single Sign-On Service service terminated with the following error:
%%2148734720

SOLUTION
This issue can also be repaired by using the regasm tool to re-register the SSOSQL assembly. Regasm.exe is included with the .Net Framework.

1. Open a command window
2. Go to C:\Windows\Microsoft.NET\Framework\v2.0.50727
3. Type: regasm "C:\Program Files\Common Files\Enterprise Single Sign-On\ssosql.dll"

I hope this helps :)