These error message relates to the Enterprise Single Sign-On Service, and may produce one of the following error codes:
Windows could not start the Enterprise Single Sign-On Service service on Local Computer.
Error 0x80131700: 0x80131700
ERROR: Could not contact the SSO server ‘localhost’. Check that SSO is configured and that the SSO service is running on that server.
(RPC: 0x800706D9: There are no more endpoints available from the endpoint mapper.)
Could not create SSOSQL. To fix the problem, reinstall SSO or try ‘regasm SSOSQL.dll’ from a Visual Studio command prompt.
Error Code: 0x80131700
Failed to connect to the SQL database ‘SSODB’ on SQL Server ‘SQLServerName’ 0x80131700 (Win32)
This problem can be resolved relatively easily.
The first thing to try with regard to this error is to attempt to clean the registry of your computer. A good way to do this is to download the Total System Care, which will do an excellent job of cleaning your registry and often sort out the problem in itself.
More Information and Manual Resolution
This is either an incredibly complex problem to deal with, or a very simple one, and the straightforward solution is to be recommended!
Simply install the fix available on the ENTSSO server. This hotfix will update the ENTSSO assembly registration with the correct version of the .NET framework, thus resolving the problem. It is not necessary to restart your computer after applying this hotfix.
If this doesn’t work then the issue can also be resolved by utilising the regasm tool, which will enable you to re-register the SSOSQL assembly. Regasm.exe is included within the .Net Framework.
This is carried out differently depending on whether you’re using a 32 or 64-bit server.
For a 32-bit Server firstly open a command window through the Start menu.
Go to C:\Windows\Microsoft.NET\Framework\v2.0.50727
Finally, type ‘regasm “C:\Program Files\Common Files\Enterprise Single Sign-On\ssosql.dll’
For a 64-bit server, open a command window and then go to C:\Windows\Microsoft.NET\Framework64\v2.0.50727
Type each of the following and then click Enter.
32bit: regasm “C:\Program Files\Common Files\Enterprise Single Sign-On\win32\ssosql.dll”
64bit: regasm “C:\Program Files\Common Files\Enterprise Single Sign-On\ssosql.dll”
This should resolve the problem. If this fails, a system restore is to be recommended. System restore can be accessed through the Start menu, by simply typing “System Restore” into the search box.
If the system restore utility will not run correctly then you can attempt to activate safe mode. To run Windows in Safe Mode, restart your computer and press F8 (if you have Windows installed). Once you’ve reached the desktop in Safe Mode, type ‘System’ into the Start search box and press Enter once ‘System Restore’ is highlighted. You should then be able to run the system restore utility.