Database upgrade fails with error ExecuteNonQuery failed for Database. The role has members. It must be empty before it can be dropped. (4315429)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

Database upgrade fails with error ExecuteNonQuery failed for Database. The role has members. It must be empty before it can be dropped.
说明

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
原因

During the database upgrade, trying to delete roles that have members may fail.
解决办法

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.