Wednesday, July 28, 2010

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: ,,

2 comments:

siraykut said...

RegAsm : error RA0000 : Unable to locate input assembly 'ssosql.dll' or one of i
ts dependencies.

Winson Woo said...

Check out this thread for your problem

http://forums.asp.net/t/1392455.aspx