Voltar
-
Título
Database upgrade fails with error ExecuteNonQuery failed for Database. The role has members. It must be empty before it can be dropped. -
Descrição
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
-
Causa
During the database upgrade, trying to delete roles that have members may fail. -
Resolução
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.
