Home Forums SQL Server 2008 SQL Server 2008 - General TDE does not make the is_master_key_encrypted_by_server value to 1. RE: TDE does not make the is_master_key_encrypted_by_server value to 1.

  • July 1, 2015 at 1:11 am

    #1809374

    SQL-DBA-01 (6/30/2015)

    Hello Experts,

    Any reason why the TDE does not turn the is_master_key_encrypted_by_server value to 1. The column in table "databases" database.

    Is there anything special to be done to get it 1?

    Please suggest

    As i said before in a previous post to you this column in sys.databases will not be set for a TDE protected database.

    The DMK used for TDE is created in master, it is this database that will have this column set to 1 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉