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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy