Previous RMS servers, old RMS v1 servers, failed AD RMS servers, and other scenarios may leave behind the RMS server name. This purely cosmetic artifact manifests in the AD RMS Servers tab on the properties tab of the Active Directory Right Management Services server. Example of the UI displaying old RMS servers which are no longer in service.
There is no harm with these servers being in the database or the UI. If one needed to remove these servers it is possible.
WARNING: The contents of this article discuss making changes to one of the RMS databases. This document describes how to make these changes. However this does not imply these steps should be undertaken. I show you most of the steps. I omit some of the details on actually creating and running a SQL query. If you do not know know to get around in SQL Server Management Studio (SSMS) then do not start learning in your RMS databases. If you are going to proceed on and make these changes in your environment please make a backup of the database.
These steps take place in the RMS configuration database, typically named DRMS_Config_adrms_443. The 443 number may be port 80 if RMS is configured to use http. The table to be modified is DRMS_ClusterServer.
Two SQL queries are used. One is a query to ensure the desired server is the server we actually remove from the table. The second query does the delete action.
--Test that we are using the desired server
USE DRMS_Config_adrms_443
SELECT
*
FROM
DRMS_ClusterServer
WHERE
ServerName=
'RMS01'
-- This deletes the server.
-- Please backup the database before doing this.
DELETE
Maheshkumar S Tiwari edited Original. Comment: Added tags