Sep 242007
 

When running the configuration wizard for the HIPAA accelerator, I have come across an occurrence where I get the following error:

Error 1

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 = 80040e14

c:\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

Existing Property

to

New Property