To change the SQL port that RMAD connects to for the Comparison Report database:
-
Close the RMAD console
-
Open regedit
-
Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Quest\Recovery Manager for Active Directory\DBReporting
-
Modify ConnectString by adding a comma and the port number after SERVER=SQLServerName
For example: DRIVER={SQL Server};SERVER=SQLServerName\SQLInstance,SQLPort;DATABASE=RecoveryManager-Reporting-SQLServerName;Integrated Security={SSPI}
-
Modify Server by adding a comma after the SQL server name
For example: SQLServerName,SQLPort
-
Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest\Recovery Manager for Active Directory\DBReporting
-
Modify ConnectionString and Server the same as in steps 4 and 5
If you are using RMAD FE, the SQL port that the Forest Recovery console uses to connect to the Persistence database:
-
Open each project
-
Select Tools | Recovery Project Settings
-
Select the Persistence tab
-
Add a comma and the port number after the SQL Server name (SQLServerName,Port)