locked
How to move AD-RMS Server 2012 R2 databases to new SQL Server? RRS feed

  • Question

  • I have a question I am hoping someone can help with. We have the following environment:

    - AD-RMS Server 2012 R2

    - SQL Server (Old)

    - SQl Server (New)

    We now have an issue where the old SQl Server is being removed and we did not use a CNAME for the SQL databases. (Yes I know bad idea we didnt but we have learnt now). So I have created a new CNAME in DNS for the new SQL Server but I need to update the AD-RMS configuration now to point to the new databases.

    I found the following guide but this looks to be related to an older version of AD-RMS:

    https://dilshansaminda.wordpress.com/2014/01/03/how-to-migrate-adrms-database-to-another-server-with-cname-records

    The guide details about stopping the logging service but with Server 2012 R2 there is none..

    Does anyone know the steps or have a guide on how to migrate databases to a new SQL server for AD-RMS 2012 R2?

    Friday, January 16, 2015 4:44 PM

Answers

  • I decided to create a test lab and do all these steps in a test environment. I followed the following guide:

    https://dilshansaminda.wordpress.com/2014/01/03/how-to-migrate-adrms-database-to-another-server-with-cname-records/

    Everything was as expected except for AD RMS Logging Service registry change. This service looks like t has been removed in the Server 2012 R2 version.

    I tested protecting new documents, unprotecting them and genrating reports in the RMS Manager which was all successful.

    • Marked as answer by JRATechNet Friday, January 23, 2015 3:16 PM
    Friday, January 23, 2015 3:16 PM

All replies

  • Anyone have any ideas?
    Monday, January 19, 2015 8:22 AM
  • I decided to create a test lab and do all these steps in a test environment. I followed the following guide:

    https://dilshansaminda.wordpress.com/2014/01/03/how-to-migrate-adrms-database-to-another-server-with-cname-records/

    Everything was as expected except for AD RMS Logging Service registry change. This service looks like t has been removed in the Server 2012 R2 version.

    I tested protecting new documents, unprotecting them and genrating reports in the RMS Manager which was all successful.

    • Marked as answer by JRATechNet Friday, January 23, 2015 3:16 PM
    Friday, January 23, 2015 3:16 PM
  • Hi JRA,

    I've been following https://dilshansaminda.wordpress.com/2014/01/03/how-to-migrate-adrms-database-to-another-server-with-cname-records/ to migrate my database server. Unfortunately i still have an issue where my logging database in AD RMS management console still point to previous database server. Do you know what i've been missed out? 



    • Edited by maliqiakbar Thursday, October 13, 2016 10:16 AM
    Thursday, October 13, 2016 10:15 AM
  • Have you changed

    LoggingDatabaseServer  DB setting and ConnectionString, LoggingDatabaseServer  and PASSWORDDERIVEDKEY registry setting?

    Thursday, October 13, 2016 12:46 PM
  • Hi Martin,

    Thanks for replying. I cannot find LoggingDatabaseServer everywhere, do you know where is it? I am using AD RMS 2012 R2 and i can only find that parameter in AD RMS 2008 R2.

    Friday, October 14, 2016 2:03 AM
  • Sorry was a little confused,

    AFAIK LoggingDatabaseServer setting is in Windows Server 2012 R2 present only in DRMS_Config database. You need to change only following keys in database:

    LoggingDatabaseServer
    CertificationUserKeyStorageConnectionString
    DirectoryServicesCacheDatabase

    Moreover you need to change following registry:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DRMS\ConnectionString

    ConfigDatabaseConnectionString

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DRMS\KeyProtection

    PASSWORDDERIVEDKEY_OLDSERVER\INSTANCE

    to

    PASSWORDDERIVEDKEY_NEWSERVER\INSTANCE

    and restart IIS.

    HTH

    Martin

    Friday, October 14, 2016 6:54 AM
  • My stripped down version of how to do this should cover everything.
    That other article is a little convoluted IMHO

    http://social.technet.microsoft.com/wiki/contents/articles/14887.relocating-the-ad-rms-database-the-simple-but-complete-guide.aspx
    Wednesday, October 19, 2016 8:26 PM