DBMK, Certificate linkage? RRS feed

  • Question

  • When I attemped to create a Certificate I was told I needed to create a Database Master Key first.  Of course, it worked as advertised but where in the "Create Certificate" command is this connection between the two established?



    Thursday, March 26, 2009 8:32 PM

All replies

  •    When creating a CERTIFICATE with a private key, the private key needs to be protected either by the master key (DBMK, this is the default), or by a password.  If in the CREATE CERTIFICATE DDL statement there is no password specified, it is required that the DBMK is accessible.

      For more detailed information please visit BOL: http://msdn.microsoft.com/en-us/library/ms187798.aspx
    I hope this information helps,
      -Raul Garcia
       SQL Server Engine

    This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, March 27, 2009 12:14 AM