When running the configuration wizard for the HIPAA accelerator, I have come across an occurrence where I get the following error:
In looking at the log you will see the following enties
Executed SQL statement on database: BizTalkMgmtDb on computer: {Server}
Executed SQL statement on database: BizTalkMgmtDb on computer: {Server}
User, group, or role ‘{USERID}’ already exists in the current database.
SQL error: 42000 Native error code: 15023
c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(1747): FAILED hr = 80040e14c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(1955): FAILED hr = 80040e14
c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(1365): FAILED hr = 80040e14
c:\depotsetupv2\private\common\configwizard\confighelper\sqlhelper.cpp(720): FAILED hr = 80040e14
Failed to execute SQL statement on database: BizTalkMgmtDb on computer: {Server}
User, group, or role ‘{User}’ already exists in the current database.
c:\depots\depothipaav33\private\source\hipaaconfig\dll\hipaaconfig.cpp(2179): FAILED hr = 80040e14
The solution is to go into the database and for the property that is running the service uncheck Management database
to