none
Encyption key to connect to DB at DR Site? RRS feed

  • Question

  • Hi all,

    I'm planing to have FIM server and SQL Server for FIM at DR site

    I'm not sure that when I install FIM at DR Site to connect to SQL DB at DR site (SQL DB is replicated from DC to DR). Does it require me to input an exist encryption key to connect to DB at DR?

    Anyone can help?

    Thanks !







    • Edited by Kzb Friday, May 15, 2015 3:54 AM
    Friday, May 15, 2015 3:53 AM

Answers

  • Encryption key is strictly related to database. So it doesn't matter what you want to achieve - to install passive node using the same DB on the same DB server, move DB to another DB server or maybe copy DB backup to test environment to check code changes - all of those need the same encryption key to be used.

    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.

    • Marked as answer by Kzb Monday, May 18, 2015 3:56 AM
    Sunday, May 17, 2015 4:24 PM

All replies

  • Thanks for the reply but actually I'm not really understand since lack of knowledge about SQL. And seem that encryption key using for FIM is exactly "encryption key" in term of SQL.

    Simply if anyone can provide me a YES/NO answer and explain a bit why, appreciate that.

    Thanks a lot.


    • Edited by Kzb Saturday, May 16, 2015 5:30 AM
    Saturday, May 16, 2015 5:28 AM
  • Hi Duc,

    Yes, if you install FIM Sync at other node than the first node, and use existing database, you need to point FIM Sync key file exported during installation of first node. If you haven't exported it during installation, you can do it using Encryption Key Management Tool.

    Also please read this thread about HA for FIM Sync


    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.

    Saturday, May 16, 2015 9:09 AM
  • Thanks for the reply Dom,

    But the thing is that DB in DR Site is on another server (DB Server at DR site). So in that case, I wonder the Encryption key at DC site can be used to connect to DB at DR Site?

    Please correct me if I'm wrong.

    Thanks !

    Sunday, May 17, 2015 2:51 PM
  • Encryption key is strictly related to database. So it doesn't matter what you want to achieve - to install passive node using the same DB on the same DB server, move DB to another DB server or maybe copy DB backup to test environment to check code changes - all of those need the same encryption key to be used.

    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.

    • Marked as answer by Kzb Monday, May 18, 2015 3:56 AM
    Sunday, May 17, 2015 4:24 PM