Issues Installating BizTalk on Windoes 2007
If you get the following error: Installing BizTalk on the Windows 7 platform,
[5:02:36 PM Info SSOServerCfg] (ssoconfigobj2.cpp:5125) Returning error description: <Exception Message=”Failed to connect to the SQL database ‘SSODB’ on SQL Server ”.” Source=”SSO” HelpID=””><Exception Message=”(0x80131700)” Source=”Win32″ HelpID=””/></Exception>
1. You can use the cmd prompt or the visual studio command prompt
2. For command prompt use the following
3.Using Command prompt
a. C:\Program Files\Common Files\Enterprise Single Sign-On>C:\WINDOWS\Microsoft.NET \Framework\v2.0.50727\RegAsm.exe ssosql.dll
Microsoft (R) .NET Framework Assembly Registration Utility 2.0.50727.4927
Types registered successfully
Microsoft (R) .NET Framework Assembly Registration Utility 2.0.50727.4927
Types registered successfully
4. Using VS.NET
a. C:\Program Files\Common Files\Enterprise Single Sign-On> regasm ssosql.dll
If the above approach still does not resolve the issue then follow either of these steps
1. Enable TCP/IP and Named Pipes?
2. Check the account has proper rights with in the SQL Server