Changing SQL instance is not reflect and RMAD still points to previous SQL instance (4377506)

Changing SQL instance by running the RMAD installer or by selecting Change on RMAD installation in Control Panel  is not reflecting the change done to the new SQL instance and RMAD still points to previous SQL instance.

This issue has been identified as a defect  and it will be solved on a future release of RMAD. 

Defect ID 523509.

Workaround:

To change the Reporting database:

• Open the Registry Editor on the RMAD server
• Manually update with the new SQL instance the ConnectionString and Server values under:
  Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Quest\Recovery Manager for Active Directory\DBReporting
  Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Quest\Recovery Manager for Active Directory\DBReporting 

To change the Forest Persistence Database: 

• Open the Forest console
• Click on Tools | Fault Tolerance | Settings
• Change SQLServer\Instance for the Forest persistence database.