none
unable to continue with upgrade because the current user is not a member of the bitalk administrator group or SQL server is not running. RRS feed

  • Question

  • Hello,

    i was trying to install Microsoft BizTalk Accelarator for SWIFT 2009 message pack and was getting following error

    "unable to continue with upgrade because the current user is not a member of the bitalk administrator group or SQL server is not running. please correct this condition and try again."

    I logged into machine as the Administrator and already in the biztalk administrator group. As well as the SQL Server is running. so why i am getting the above errror?

    please advice,

    thanks,

    Ammar

    Thursday, August 4, 2011 10:19 AM

Answers

  • Check whether the user is sysadmin in SQL Server.
    --------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    • Marked as answer by AmmarBIZ Thursday, August 11, 2011 11:23 AM
    Monday, August 8, 2011 8:33 AM
  • Computer Management -  Local users and Groups - Groups

     SSO Administrators - Properties

    Check the account with which you logged in is present in Members.

    Similarly check  for SSO Affiliate Administrators

    You can also check

    Computer Management -  Local users and Groups

    BizTalkUser is Member of SSO Administrators


    MPramod
    • Marked as answer by AmmarBIZ Thursday, August 11, 2011 11:23 AM
    Friday, August 5, 2011 9:59 PM
  • Check whether the user is a member of the group Biztalk server Administrators.
    • Marked as answer by AmmarBIZ Thursday, August 11, 2011 11:23 AM
    Monday, August 8, 2011 10:25 AM

All replies

  • Potentially the user you are logged in with doesn't have sufficient privileges (for whatever reason) on the SQL server box.  You could temporarily try adding your user account to the SA group while you set things up.

    This troubleshooting guide may be of some assistance.


    If this is helpful or answers your question - please mark accordingly.
    Because I get points for it which gives my life purpose (also, it helps other people find answers quickly)
    Thursday, August 4, 2011 3:09 PM
  • Computer Management -  Local users and Groups - Groups

     SSO Administrators - Properties

    Check the account with which you logged in is present in Members.

    Similarly check  for SSO Affiliate Administrators

    You can also check

    Computer Management -  Local users and Groups

    BizTalkUser is Member of SSO Administrators


    MPramod
    • Marked as answer by AmmarBIZ Thursday, August 11, 2011 11:23 AM
    Friday, August 5, 2011 9:59 PM
  •  

    Computer Management -  Local users and Groups - Groups

     SSO Administrators - Properties

    Check the account with which you logged in is present in Members.

    Similarly check  for SSO Affiliate Administrators

    You can also check

    Computer Management -  Local users and Groups

    BizTalkUser is Member of SSO Administrators


    MPramod

    Hii Promod,

    I have checked both the groups and the currently logged in user (i have logged in as the Administrator) belongs to both the groups.

    • SSO Administrators
    • SSO Affiliate Administrators.

    any other options?


    Monday, August 8, 2011 8:14 AM
  • Potentially the user you are logged in with doesn't have sufficient privileges (for whatever reason) on the SQL server box.  You could temporarily try adding your user account to the SA group while you set things up.

    This troubleshooting guide may be of some assistance.


    If this is helpful or answers your question - please mark accordingly.
    Because I get points for it which gives my life purpose (also, it helps other people find answers quickly)

    Hello Grant, I checked the privileges in the SQL Server box and tried adding but it says the user permission already exists. :(
    Monday, August 8, 2011 8:16 AM
  • Check whether the user is sysadmin in SQL Server.
    --------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    • Marked as answer by AmmarBIZ Thursday, August 11, 2011 11:23 AM
    Monday, August 8, 2011 8:33 AM
  • Check whether the user is sysadmin in SQL Server.
    --------------------------------------
    Mark As Answer or Vote As Helpful if this helps.
    yeah and i have granted the sysadmin, securityadmin, dbcreator server roles even.
    Monday, August 8, 2011 8:54 AM
  • Check whether the user is a member of the group Biztalk server Administrators.
    • Marked as answer by AmmarBIZ Thursday, August 11, 2011 11:23 AM
    Monday, August 8, 2011 10:25 AM