Could not create SSOCSTX. To fix the problem, reinstall SSO or install SSOCSTX.dll into a COM+ library application.

First of all, let me apologize for my long absence, almost passed a month since I wrote the last time on my blog and for me is a long time but I’m back… and I assure you that I haven’t been standing doing nothing, on the contrary, I’m working on several white papers, reviewing others, speaking of events, a lot of work and so on… so I still will publish a lot of content this year.

Today after installing .NET Framework 4.0 in my BizTalk Server 2006 Lab environment and of course restart the machine, the Enterprise Single Sign-On Service stopped working.

The first error that I found was:

“Could not create SSOSQL. To fix the problem, reinstall SSO or try ‘regasm SSOSQL.dll’ from a Visual Studio command prompt.
Error Code: 0x80131700”

This was an error that I already blogged in the past and you can find more information here. But basically, you need to fix the Enterprise Single Sign-On by running the following command: regasm SSOSQL.dll.

After solving this problem I tried to start it manually the SSO Service but surprisingly, I got two new errors in the event viewer:

“Could not create SSOCSTX. To fix the problem, reinstall SSO or install SSOCSTX.dll into a COM+ library application.
Additional Data: 93
Error Code: 0x8004E00F, COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator”

Could not create SSOCSTX error

Followed by:

“The SSO service failed to start.
Error Code: 0x8004E00F, COM+ was unable to talk to the Microsoft Distributed Transaction Coordinator”

The SSO service failed to start error

At this point for me, it was clear I have issues with MSDTC.

After searching a little I found the first possible solution that basically told me to u reinstall the Microsoft Distributed Transaction Coordinator (MSDTC) to resolve the issue, of course, this was a solution that I was trying to avoid.

Solution

The first thing you must do is to check if the MSDTC is running and make sure the MSDTC security settings are configured correctly:

  • Network DTC Access – Checked
  • Client and Administration
    • Allow Remote Clients – Checked
  • Transaction Manager Communication
    • Allow Inbound – checked
    • Allow Outbound – Checked
    • No authentication required – checked

In my case everything was properly configured so next step:

  • Why not try to restart the Microsoft Distributed Transaction Coordinator (MSDTC) service?

Since that is the cause of the current problems… that seems a good idea, better this that reinstall the MSDTC J

Wow! Bingo! Found the solution to all my problems! After restarted successfully the MSDTS Service I was able to start the Enterprise Single Sign-On Service and of course the BizTalk Services with success.

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.

1 thought on “Could not create SSOCSTX. To fix the problem, reinstall SSO or install SSOCSTX.dll into a COM+ library application.”

Leave a Reply

Your email address will not be published. Required fields are marked *

turbo360

Back to Top