Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
How to change the SQL port in the Recovery Manager for AD configuration?
Description
After changing the port the SQL server uses, how do you update the RMAD configuration to use the new SQL port?
Resolution
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\Dell\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\Dell\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)
If you have the RMAD Portal installed there are 2 methods to change the SQL port:
Uninstall and then reinstall the Dell Recovery Manager Portal again specifying the new SQL Server address as SQLServerName,PortNumber. It is not required to reinstall Dell RMAD/RMAD FE, just the Portal
Run the attached Powershell script which will request the new SQL server address (specified as SQLServerName,PortNumber) and the authentication type
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
Product(s):
Recovery Manager for AD Forest Edition
8.7.1, 8.7, 8.6.4, 8.6.3
Recovery Manager for AD
8.7.1, 8.7, 8.6.4, 8.6.3
Topic(s):
How To
Article History:
Created on: 4/10/2015 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.