To resolve this issue, modify the SRM database.
To modify the SRM database:
Caution: Take a back up of the SRM database and take snapshots of all servers being modified before making changes to the database.
- Open the SRM database in SQL Management Studio.
- Locate these tables:
dbo.pd_acedata
dbo.pd_authorization
- Delete the contents of both tables:
- Right-click the table and click Edit Top 200 Rows.
- Right-click the rows in the table and click Delete.
During SRM startup if the pd_authorization table is empty, SRM creates administrative permissions for all users and groups that have Administrator role on vCenter root folder.
4. After SRM servers at both sites successfully start, reconfigure the connection between them if broken.