I recently got the following errors when starting Enterprise Single Sign-On on a pre-production BizTalk Server:
The SSO service failed to start.
Error Code: 0x80131700
The first error gives two suggestions on how to fix this error.
The first suggestion is to reinstall SSO. I tried a repair which did not do the job so what about a full re-install? Unfortunately I could not uninstall Enterprise Single Sign-On due it being used by other programs (BizTalk anyone?).
The second suggestion is to run regasm from a Visual Studio command prompt. With this being a Pseudo-Live server visual studio is not installed; fortunately you can still find regasm in the .net framework folders C:\Windows\Microsoft.NET\Framework\. I was then able then run a standard command prompt, navigate to this location and run:
regasm "C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll"
Following this the SSO service ran successfully.
Could not create SSOSQL. To fix the problem, reinstall SSO or try 'regasm SSOSQL.dll' from a Visual Studio command prompt.
Error Code: 0x80131700
AND