Return
-
Title
Database upgrade fails with error ExecuteNonQuery failed for Database. The role has members. It must be empty before it can be dropped. -
Description
Database upgrade fails with the following error:
ExecuteNonQuery failed for Database. The role has members. It must be empty before it can be dropped. Error: 15144
-
Cause
During the database upgrade, trying to delete roles that have members may fail. -
Resolution
Follow these steps:1. In SQL Management studio, under databases->dbReporter->Security->roles, find each of the Enterprise Reporter roles and look at the properties.2. If they contain more members than the screenshots below, record the extra members, then remove them from each of the four (4) Enterprise Reporter roles and run the database upgrade again.3. After the upgrade completes, add the removed role members back into the roles if desired.
