Failed to connect to the SQL database SSODB on SQL Server

Looks like in the setup you left the default value "SQLServerName" for the database.  Try putting in the actual db there. 

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.

Thank u very much PanzerFaustNL .............

i am tried for 4hrs to resolve the problem by your help i configured sucessfully.......

thank u very much............

Thanks & Regards,

AboorvaRaja.R

Thank u very much PanzerFaustNL .............

i am tried for 4hrs to resolve the problem by your help i configured sucessfully.......

thank u very much............

Thanks & Regards,

AboorvaRaja.R

Hi.

Did you run after installation the Microsoft VizTalk Server Best Practices Analyser? Perhaps it has some more information.

Have you tried to configure your BizTalk 2009 Server using Basic Configuration?

Did you enable TCP/IP and Named Pipes?

//Edit ... uuups ... too late ...

It works fine. Thank you

Thanks a loot i works, saved a loot of time

Thanks

Prabhakar

Awesome! Worked for me as well!

It Works...Thx a lot

Hi, Thanks for this solution,

I did this, however it is still it is failing, there is a service, Enterprise Single Signon. which is not getting started.

Please suggest.

Thanks

Harish

It worked for me too, thanks a lot!

WOW PanzerFaustNL u r the man. That really solved the problem.

I went to this path, but when I run the regasm ssosql.dll command, it says unrecognised command.

Please help.