Fixing BizTalk ENTSSO – Could not create SSOSQL. To fix the problem, reinstall SSO or try ‘regasm SSOSQL.dll’ from a Visual Studio command prompt.

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
Author: Sandro Pereira

Sandro Pereira lives in Portugal and works as a consultant at DevScope. In the past years, he has been working on implementing Integration scenarios both on-premises and cloud for various clients, each with different scenarios from a technical point of view, size, and criticality, using Microsoft Azure, Microsoft BizTalk Server and different technologies like AS2, EDI, RosettaNet, SAP, TIBCO etc. He is a regular blogger, international speaker, and technical reviewer of several BizTalk books all focused on Integration. He is also the author of the book “BizTalk Mapping Patterns & Best Practices”. He has been awarded MVP since 2011 for his contributions to the integration community.

Leave a Reply

Your email address will not be published.

BizTalk360
BizTalk Server

Over 650+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Operate efficiently with enterprise-grade Azure monitoring,
tracing, remediation & governance in one platform

Learn More

Back to Top