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. Required fields are marked *

BizTalk360
BizTalk Server

Over 500+ customers across
30+ countries depend on BizTalk360

Learn More
Serverless360
Azure

Manage and monitor serverless
components effortlessly

Learn More
Atomicscope
Business Users

Monitor your Business Activity in iPaaS
or Hybrid integration solutions

Learn More

Back to Top