Enterprise SSO service start failure due to installation of VS2010

BizTalk and SSO was running smooth before the installation of VS2010 on my machine. I have a 64-Bit machine with Windows Server 2008 R2 and BTS 2009 installed. When I installed VS2010 my SSO was stopped and when I tried to start I started getting the error below

Windows could not start the Enterprise Single Sign-On Service service on Local Computer.

Error 0x80131700: 0x80131700

To issue started because it unregisterd SSOSQL.dll which is found on C:\Program Files\Common Files\Enterprise Single Sign-On folder. To register it again run regasm on the VS command prompt from your 32-Bit machine.

regasm C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll

On my 64-Bit it worked by running the 64-Bit regasm which is found on C:\Windows\Microsoft.NET\Framework64\v2.0.50727.

So go to the framework64 folder from the command prompt and run

regasm C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll

11 Responses to Enterprise SSO service start failure due to installation of VS2010

  1. res says:

    Did you propably forgot to disable “Microsoft SQL Server 2005 Express Edition” in the installation wizard of visual studio? In the installation Guide: http://www.microsoft.com/downloads/details.aspx?FamilyID=9C697E02-D1BC-4684-8748-28B3A292D5BF&displaylang=en (Installing BizTalk Server 2009 on Windows Server 2008.docx) on Page 16 is mentioned that this can cause trouble.

  2. Abdul Rafay says:

    I probably won’t see the BizTalk Installation guide on Windows server 2008 when I am Installing VS2010 on my box 🙂 The point is I had BTS 2009 and VSTS 2008 already installed. My SSO Service was working fine and after VS2010 installation it stopped working. I searched on the internet for error luckily other people faced the same issue and had the same above resolution for it.

  3. Oliver says:

    Thank you. You just saved me a lot of troubleshooting time. =)

  4. Manav says:

    Thanks a lot. I was faing a somewhat related problem. In my case I had a fresh windows 2008 machine on which I had installed VS 2008 and VS 2010. After that I installed BizTalk 2009, and while trying to configure, I was getting same error code.
    I was struggling for an hour, and then stumbled across your post. Tried it, and it worked like a charm. 🙂

  5. Ben March says:

    This helped me too. Thanks!

  6. Works, thank you.

  7. Keef says:

    Thank you Abdul! You just save me from as well. Hilarious that new software disables others. I wish the BizTalk team would give up on this delicate dependency on Single Sign-on.

  8. Ayoub Jummun says:

    Many Thanks,
    You have save me days of looking a work around. I thought that I was the only person experiencing this.

  9. Blaze says:

    Do you have any clue why the SSO database could not be accessed after running the regasm SSOSQL.dll??

  10. Meenu says:

    Thanks a lot, it worked.Was struggling with configuration since last two days 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: