SQL Server Database Permissions Reset; may fail to reset Permissions

The SQL Server Database Permissions Reset function may fail with the message "Failed to reset Database permissions. Failed to execute SQL. There is already an object named 'appPOWER' in the database. CREATE SCHEMA failed due to previous errors.".

When the 'appPOWER' Application Role is created it also creates a Security Schema with the same name. The Database Permissions Reset function drops the Application Role, but if for some reason the Security Schema fails to also be dropped at the same time this error occurs.

finPOWER Connect now tests that after attempting to drop the 'appPOWER' Application Role the 'Database Principal' and 'Security Schema' both no longer exist. If either exists an error is reported back to the User with more specific information on the issue.