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 :)