After installing Visual Studio 2010 in order to install BizTalk Server 2010, I’ve encountered a problem when I try to start the SSO Service (because, in the BizTalk Installation, setup indicate that this service must be started)
So when I try to start this service, the problem 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
I found the solution on this blog post : http://tomas-simonavicius.blogspot.com/2010/02/sso-service-failed-to-start-after.html
As it is explain in the Event log Application,you’ve a problem with the SSOSQL.dll file, you have to register this dll again with regasm BUT if you’re on x64 platform, you have to explicilty use the regasm of the folder
EDIT : Good thing to know — If you plain to update to BizTalk 2010, you don’t need to do this. Just launch the upgrade. It will first update the SSO engine to the 6.0.4219.0. Then It will ask you to launch this service before following the steps of the upgrade.