Failed to connect to the SQL database SSODB on SQL Server

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Failed to connect to the SQL database SSODB on SQL Server

Viewing 4 reply threads
  • Author
    Posts
    • April 14, 2010 at 7:33 PM #24564
      community-content

        Hi Everyone,

        I trying to config the Biztalk Server 2009 on a Windows Server 2008 Std and SQL Server 2008 Std. And I got this error when I tried to config the Biztalk Server:

        Failed to connect to the SQL database SSODB on SQL Server ‘SQLServerName’. (SSO).

        This happens when I enable the Enterprise Single Sign-On, then appears the X symbol on Data Store Name.

        I created the account to run the services for biztalk and put it on Administrators Group and SQL Administrators, too.

        Any idea why about this?

        Thanks in advanced.

      • April 21, 2010 at 9:42 AM #24609
        community-content

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

        • May 11, 2010 at 5:24 AM #24668
          community-content

            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.

            • June 16, 2010 at 3:50 AM #24975
              community-content

                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

              • June 16, 2010 at 4:26 AM #24976
                community-content

                  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

                • August 2, 2010 at 1:04 AM #25471
                  community-content

                    It works fine. Thank you

                    • August 6, 2010 at 4:55 AM #25547
                      community-content

                        Thanks a loot i works, saved a loot of time

                         

                        Thanks

                        Prabhakar

                    • November 3, 2012 at 4:37 AM #25897
                      community-content

                        Thanks .. It was quite helpful.

                      • February 7, 2013 at 8:17 PM #25987
                        community-content

                          Thanks

                        • July 19, 2013 at 6:03 AM #26104
                          community-content

                            Thanks!! [:)]

                          • July 23, 2013 at 10:06 AM #26107
                            community-content

                              Thanks a ton. You just solved my days of research.. Thank you so much…

                            • August 3, 2013 at 10:01 AM #26115
                              community-content

                                PanzerFaustNL, thank you so much for this! You've saved me from a bucketload of problems 🙂

                              • November 5, 2013 at 7:12 AM #26199
                                community-content

                                  Excellent! Works like a charm.

                                • June 12, 2014 at 5:57 AM #26381
                                  community-content

                                    Thanks a lot.It worked and saved time. 🙂

                                  • May 18, 2015 at 5:54 AM #26512
                                    community-content

                                      Thank u very much PanzerFaustNL …………. U R lighting biztalk in every computer 🙂

                                  • June 23, 2010 at 3:50 AM #25036
                                    community-content

                                      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 …

                                    • March 7, 2014 at 7:47 AM #26292
                                      community-content

                                        Thank you verymuch

                                    • Author
                                      Posts
                                    Viewing 4 reply threads
                                    • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.