When an organization chooses to migrate its Active Directory Rights Management Services (AD RMS) databases from Windows Internal Database (WYukon) 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 WYukon to SQL Server 2005 SP2. 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.
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….”