When attempting to upgrade from a previous version of Enterprise Reporter to version 2.5 Hotfix #1 an error is received during when running the Database Wizard:
"A security group with this name already exists, but its group type differs from the one you have selected. Please enter a unique security group name or enter an existing group name with the correct group type"
Change the group type in Active Directory from Universal to Domain Local and then click Next in the Database Wizard to continue with the upgrade.
Depending on the environment you may need to wait for replication to complete before the change is recognized by the wizard.
Once the Database Wizard continues you will then see the usual Database Maintenance Wizard warning regarding replication of the security groups. Click OK and the upgrade will continue as expected.
An Enhancement Request number 593298 has been submitted to Development for consideration that Universal Security groups will be accepted during the Database Upgrade Wizard to prevent this issue. The Product team will consider this in a future release of Enterprise Reporter