Post reply

Column Master Key Certificate

  • March 13, 2018 at 6:22 am

    #329849

    When i create a CMK i would like to use an existing local machine certificate but i can only see a Generate Certificate Button.
    My question is:  Is it possible to import a certificate? If so, how can i do it?

    PS : This certificate was generated by the infrastructure team not by SQL Server
    Thanks

  • March 13, 2018 at 6:02 pm

    #1983068

    You can use the CREATE CERTIFICATE command in order to import a certificate with the private key, check this out - https://docs.microsoft.com/en-us/sql/t-sql/statements/create-certificate-transact-sql

  • March 14, 2018 at 9:37 am

    #1983202

    Jose Marcelo Dias de Oliveira - Tuesday, March 13, 2018 6:22 AM

    When i create a CMK i would like to use an existing local machine certificate but i can only see a Generate Certificate Button.
    My question is:  Is it possible to import a certificate? If so, how can i do it?

    PS : This certificate was generated by the infrastructure team not by SQL Server
    Thanks

    In order to use your own certificate it will need to adhere to minimal requirements, detailed here.

    Use the powershell cmdlet

    New-SelfSignedCertificate

    to create a suitable selfsigned certificate

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

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

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

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