how can i configure biztalk on cluster sql server 2005.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › how can i configure biztalk on cluster sql server 2005.

Viewing 1 reply thread
  • Author
    Posts
    • July 16, 2008 at 8:14 AM #20172
      community-content

        Hi,

        I am facing one problem during configuration of biztalk server 2006 R2.

        I have cluster SQL server 2005 and i need to use that server as biztalk database server.

        At the time of configuration i am facing one error :

        TITLE: Microsoft BizTalk Server 2006 Configuration Wizard

        The SQL Server <‘sql01’> cannot be used with the SSO Administrator account ‘SSO Administrators’. Local accounts cannot be used with clustered SQL Servers. (SSO)

        My user is membere of administrator group of biztalk server.

        Please let me know how can i configure biztalk on cluster sql server 2005.

        Regards,

        – Dhaval M.

      • July 16, 2008 at 8:23 AM #20173
        community-content

          Are you using a domian account?

          Check this hardcore documentation http://www.microsoft.com/downloads/details.aspx?FamilyID=5251f103-329d-4f8d-95b5-64f99f2f6dfc&DisplayLang=en

          Cheers,

          Pedro, O Moleiro

          • July 16, 2008 at 9:04 AM #20174
            community-content

              Yeah I am using domain account.

              My user is  administrator  member of Sql server as well as biztalk machine

              Regards,

              Dhaval M.

              • July 16, 2008 at 11:38 AM #20175
                community-content

                   Your user is in the SSO administrators group?

                  • July 18, 2008 at 7:19 AM #20187
                    community-content

                      From the error message (The SQL Server <‘sql01’> cannot be used with the SSO Administrator account ‘SSO Administrators’), it sounds like it is trying to use “SSO Administrators” as the account, whereas “SSO Administrators” sounds like a local group.  Are you sure you have entered the correct SSO service account?  This service account should be a member of SSO Administrators, but for security reasons, should NOT be a local administrator on any of the servers.  However, your logon account to configure BizTalk SHOULD be a local administrator on all of the servers.

                      • August 13, 2008 at 3:27 PM #20411
                        community-content

                           Had exactly the same error today. Changed to “DomainName\SSO Administrators” and it worked fine. Same for SSO Aff Admins. Take note though that it stil shows an error until you deselect/reselect the tick box.

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