Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond

Edit Re: Failed to connect to the SQL database SSODB on SQL Server

BizTalk 2009

This group is for all content related to BizTalk Server 2009. This includes a forum, samples, and videos. Most of the content here also applies to other versions of BizTalk beyond 2009.
Create/Edit Post
The message you are editing: Re: Failed to connect to the SQL database SSODB on SQL Server
  • One of the very commone things, but hard to solve because most people don't know the answer. I have searched days for an answer and hopefully this answer is the one for you too.

    The best solution I found was to re-register the ssosql.dll on the following manner:

     

    1. start the visual studio command prompt

    2. go to the ssosql.dll C:\Program Files\Common Files\Enterprise Single Sign-On

    3. regasm ssosql.dll

     

    and probably you are finished.

    Quote
  • (Click to Add)
  • :