Enterprise SSO service start failure due to installation of VS2010
March 30, 2010 11 Comments
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
—————————
Services
—————————
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
Architecture for cloud and integration 
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.
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.
Thank you. You just saved me a lot of troubleshooting time. =)
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. 🙂
This helped me too. Thanks!
Works, thank you.
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.
Many Thanks,
You have save me days of looking a work around. I thought that I was the only person experiencing this.
Do you have any clue why the SSO database could not be accessed after running the regasm SSOSQL.dll??
Yes I do if you can see the first comment “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.”
Thanks a lot, it worked.Was struggling with configuration since last two days 🙂