AD RMS "Side Migration" with new SQL server
This is a good method of doing a "Side Migration" while leaving the original servers in place.
The steps upgrade from previous versions of RMS (ADRMS or RMSv1 SP2) while moving the database to a new server (presumably a newer version of SQL) at the same time.
The following steps assume that you are currently using a CNAME alias for RMS and will continue to use the same name.
You must know your Cluster Key Password and the RMS service account and password before these steps.
Copy the database:
1) Copy the SQL databases (Stop the AD RMS logging service and IIS on all your RMS servers, and ensure there are no connections to the DRMS_ databases.) Backup the databases on the original server and Restore them on the New server.
2) Extract and Run RMSConfigEditor.exe one any machine.
Download RMSConfigEditor.exe as part of the RMS Toolkit
(
http://go.microsoft.com/fwlink/?LinkId=98961
)
(You can also make the edits directly with the SQL Management Studio)
Edit the values in the database to point to the new name:
3) Type the name of the new SQL server in the Server text box and click "Go". (Note: If you are using an instance or port it needs to be included i.e. SQLSVR01\RMSDB,11553)
4) Pick the DRMS_Config database from the Database drop down list and click "Go".
5) Open the DRMS_ClusterPolicies and find the following PolicyName entries. In the corresponding PolicyData entry, you will find the name of the SQL server being referred to. Adjust the PolicyData entry to the new SQL server name and click the "Persist" button on each.
LoggingDatabaseServer
CertificationUserKeyStorageConnectionString
DirectoryServicesCacheDatabase
6) Make sure that the user you will be installing with has SA rights and Local Administrator rights on the new SQL server.
Install AD RMS:
7) Add the AD RMS role to the new server.
8) Choose to join the existing cluster. (It should see that there is a service connection point registered and only offer you this option.)
9) When prompted for the database server, specify the NEW database server that you just moved the databases to.
The rest of the steps will be like a normal join. You will be prompted for the Cluster Key Password and the rms service account and password.
Point DNS to the new server:
10) Change the CNAME to point to the new server so clients will request licenses from the new server and database. The old server can be left in place until testing is complete.