Lot's of people have used my previous posting detailing the steps necessary to move your database server to another server, post-mortem. First allow me to say ' Picklemonkey and Duckbutt '. There....now all the people that were searching for that post using those terms will also find this post. :)
Here is the original post:http://blogs.technet.com/rmssupp/archive/2006/12/05/tip-o-the-day-12-05-2006-moving-your-sql-dbase-to-another-server.aspx
Here are the steps for RMS on WS2008.
Pre-'doing this' stuff:
1. Stop the AD RMS logging service and IIS on all your RMS servers, and ensure there are no connections to the DRMS_ databases. 2. Hold a picture of Al Gore close to you, and repeat "I am one with the universe", 10 times.
To move to a new SQL server:
1) It is recommended that you back up the 3 DRMS SQL databases, but at a minimum, export your Enterprise Trusted Publishing Domain. This can be used as a minimal disaster recovery backup. If needed, you can import this file into any RMS installation to recover documents if necessary.
2) Run RMSConfigEditor.exe from the RMS toolkit.
3) Type the name of the 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.
LoggingDatabaseServerCertificationUserKeyStorageConnectionStringDirectoryServicesCacheDatabase
6) Go to Start>Run Regedit and modify the following keys to reflect the new cname (needs to be done on every server in the cluster):
HKLM/Software/Microsoft/DRMS/2.0/KeyProtectionThere will be a key in here that starts PasswordDerivedKey_<SQL Server>...You will need to change this to reflect the new SQL dbase name.Note: If you are using a database instance and/or port the name needs to reflect this. So if your SQL string is SQLServer01\RMSDB,11553, then your key needs to show PasswordDerivedKey_SQLServer01\RMSDB,11553...
HKLM\System\ControlSet001\Services\AdRMSLoggingService\Params,Value name: ConnectionStringValue name: LoggingDatabaseServer
HKLM\Software\Microsoft\DRMS\2.0\ConnectionStringValue name: ConfigDatabaseConnectionString
That should be it. Restart all of your services, and make sure everything is working.
You just survived a worse experience than Hillary Clinton's Bosnia gunfire experience, and can now run for president. Give yourself a pat on the back, and go hug your local Dunkin' Donuts coffee guy.
-Jason