Failed to connect to the SQL database SSODB on SQL Server

 

This happens when trying to configure BizTalk 2009 on a SQL Server 2008 platform. Digging around the Net, I have seen this happen in SQL 2005 as well.

Visual indications show a red “X” on the Data Store name when configuring (sorry, no screen shot as this is on a remote VM with no access from this machine).

The fix ?

1. Use the Visual Studio Command Prompt (make sure you have the creds or run as administrator)
2. Type “cd C:\Program Files\Common Files\Enterprise Single Sign-On” (assuming drive C is where BizTalk is installed”
3. Type regasm ssosql.dll

Hope this helps.

Technorati Tags: ESSO,BizTalk 2009,SSODB