If you’re one of those shops that skipped over 5.1, and are now catching up and going to 5.5, you will run into problems with your SRM upgrade. Here’s how to fix them.
After you perform the upgrade, per the VMware Site Recovery Manager Installation Guide, you may run into permissions issues when launching the SRM plugin.
The error message is: Connection Error: Lost connection to SRM Server x.x.x.x:8095 – Permission to perform this operation was denied.
To fix this, you’ll have to go into the database, and do some editing.
First, stop the VMware Site Recovery Manager service.
Connect to the SRM database server. If you’re not using SQL, adjust these procedures accordingly. This is SQL specific.
First, make sure you BACKUP your database.
Under your SRM Database, you’ll see a table called dbo.pd_acedata. Right click that table, and Select Top 1000 rows.
In your Results window, you’ll see that the only permissions that exist are old school pre-SSO “Administrators”. We need to fix that.
To fix it, we’re going to delete that row. Right click the table again, and select Edit Top 200 Rows.
Now, select that row with the old Administrators permission, and right click to delete it.
Now we have to do the same thing to the dbo.pd_authorization table. Edit the first 200 rows.
Delete the first line that says DR_ACEData, and click yes again.
Now go start the SRM service. This will automatically populate your database with the new permissions you’ll need to launch the SRM plugin, and connect.
If you go back to the table, you can see it has the correct permissions.
For some reason, this is a known issue, but the KB is not public. So here’s your KB.
Don’t forget to backup your database, so you can restore if you blow it up. Happy upgrading.