Post reply

Administering Database Master Keys in SQL Server

  • May 10, 2014 at 11:26 am

    #396730

    Comments posted to this topic are about the item Administering Database Master Keys in SQL Server

  • May 12, 2014 at 4:47 am

    #1712595

    Hello Steve,

    First - Thank you for taking time to write this article and help us understand more on SQL.

    Please help me. In your subtopic - Creating a DMK, you say ... as each database can only contain on DMK. Should I assume this is a typo and should be one.

    Thank you,

    Kind regards,

    Iliia

  • May 12, 2014 at 10:50 am

    #1712778

    Yes, fixing it now. One DMK per database

  • July 31, 2019 at 9:33 am

    #3667468

    Hi Steve

    When i try to add an extra password to the DMK i get the error below:

    Msg 15581, Level 16, State 7, Line 23

    Please create a master key in the database or open the master key in the session before performing this operation.

    So to confirm to create additional keys i must know the original password to open the DMK if i restore the database to a new server not hosting the same master database because the DMK is encrypted by the SMK.

    Is this true?

    Kal

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply