Failed to create the SQL database ‘SSODB’ on SQL Server

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

Viewing 1 reply thread
  • Author
    Posts
    • April 12, 2010 at 10:40 PM #24554
      community-content

        Hi Friends, I am unableto configure Biztalk server on my machine

        I am getting the error message

         

        Failed to create the SQL database ‘SSODB’ on SQL Server ‘HSG-PCS373169’ (with SSO Administrator account ‘SSO Administrators’).” Source=”SSO” HelpID=””><Exception Message=”(0xC0002A21) An error occurred while attempting to access the SSO database.
        ” Source=”SSO” HelpID=””><Exception Message=”An error occurred while attempting to access the SSO database. See the event log (on computer ‘HSG-PCS373169’) for more details.

      • April 13, 2010 at 9:44 AM #24560
        community-content

          Hi,

           

            What does the error message say when you check the Application log in the Event Viewer?

           

             You could be facing a permissions issue: before you run the BizTalk installation, make sure that you create these four groups on the database server where the BizTalk databases will be created (BizTalk Server Administrators, BizTalk Server Operators, BizTalk Application Users, BizTalk Isolated Host Users) and make sure that the user account you are using to configure BizTalk Server is also a member of the aforementioned groups…

           

             Daniel.

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