This information was copied from http://social.technet.microsoft.com/wiki/contents/articles/1084.aspx
and then edited to apply for AD RMS in Windows Server 2012.
When an organization chooses to migrate its Active Directory Rights Management Services (AD RMS) databases from Windows Internal Database (WID) on the AD RMS server to a separate
SQL server, the migration process can be complex and challenging. This article steps you through the process of migrating these databases from WID in Windows Server 2012 to SQL Server 2012. It describes the actions that you need to take to prepare for the
migration, the steps of the migration itself, and help for troubleshooting SQL connection problems.
This article presents a high-level description of the tasks required to perform the migration. It is assumed that you are familiar with the various tools and methods required to administer computers running SQL Server and AD RMS.
Before you begin the actual migration, you should first prepare your network infrastructure by performing the following tasks:
Although not required to perform the migration, the following are best practices that you should consider implementing as part of the migration:
Perform the following procedures in the indicated order to complete the migration.
Log on to the AD RMS server and perform all of these steps.
Log on to the target SQL Server and perform the following steps.
Configure the AD RMS server to use the new SQL Server
Log on to the AD RMS server and perform the following steps.
Do the following if this error message appears when you open the AD RMS console: “Cannot open database … requested by the login. The login failed. Login failed for user….”