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 Duc Huyen Friday, May 15, 2015 3:54 AM

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 Duc Huyen 1 hour 55 minutes ago

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

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 Duc Huyen Saturday, May 16, 2015 5:30 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 !

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.