For some stupid reason, the Enterprise Single Sign-On Service stopped working in one of my BizTalk machines. When I tried to start it manually, I got this error in the event log:
“Could not create SSOSQL. To fix the problem, reinstall SSO or try ‘regasm SSOSQL.dll’ from a Visual Studio command prompt.
Error Code: 0x80131700”
Solution
- Execute ‘Visual Studio Command Prompt’ (Start → All Programs → Microsoft Visual Studio 2005 → Visual Studio Tools → Visual Studio Command Prompt)
- Navigate to “SSOSQL.dll” folder, usually in:
- C:\Program Files\Common Files\Enterprise Single Sign-On\
- And execute the following command to fixed the problem:
regasm SSOSQL.dll
Another problem that you can catch, associated with this is the error:
“BizTalk 1068 the dependency service or group failed to start”
When you try to start BizTalk Service BizTalk Group : BizTalkServerApplication service, because some dependency service is not running, in my case it was the Enterprise Single Sign-On Service.
If you don’t have Visual Studio in the machine, you need to call regasm.exe utility explicitly from the .NET folder:
- Execute cmd (Start → cmd)
- Type “cd C:\Windows\Microsoft.NET\Framework\v2.0.50727” (in my case)
- And execute the following command to fixed the problem:
regasm.exe C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll
