Friday, July 30, 2010

SSO Problem :- Failed to connect to the SQL database 'SSODB' on SQL Server 'VPC-XXXXXXXX'. (SSO)

Problem: - Failed to connect to the SQL database 'SSODB' on SQL Server 'VPC-XXXXXXXXX'. (SSO)

Reason / Cause: - This issue occurs after installing .NET Framework 4.0. The registration of the assembly used by ENTSSO to access SQL Server (SSOSQL.dll) does not specify the correct version of the .NET Framework.  When .NET Framework 4.0 is installed, the assembly will try to use the newer framework and then fail to load.

Solution: -
1.      Download ESSOv4-KB2252691-x64-ENU.exe from http://support.microsoft.com/kb/2252691 (Make sure that you download 64 bit or 32 bit depending upon your system)

2.      Install it on the BizTalk Server.

3.      Start Visual Studio Command Prompt

4.      Run C:\Windows\Microsoft.NET\Framework64\v4.0.30319\regasm.exe  "C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll"
(Make sure that you are referring to latest .NET framework RegAsm.exe)

5.      Now try Configuring BizTalk Server and Bingo you are done.


1 comment:

  1. last week our class held a similar discussion about this subject and you show something we have not covered yet, appreciate that.

    - Laura

    ReplyDelete

FEEDJIT Live Traffic Map