Certificate in master DB

  • msimone

    SSCommitted

    Points: 1634

    Hello, I have a problem.

    I create a certificate from a file and it works fine.

    I drop the certificate and no problem

    When I want to create other time the same certificate, SQL gives me an error, the error 15232

    "A certificate with name 'MyCertificate' already exists or this certificate already has been added to the database"

    I don't understand, how is posible?

    Thanks for all.

     

     

  • Sue_H

    SSC Guru

    Points: 90121

    Did you check for the certificate by querying sys.certificates in the database?

    Sue

  • msimone

    SSCommitted

    Points: 1634

    Hello Sue_H, of course, for that I don't understand.

     

  • Sue_H

    SSC Guru

    Points: 90121

    Open the certificate that you are trying to create on disk and check the thumbprint  and then compare it to the thumbprint for the other existing certificates on the instance. The duplicate could be by thumbprint, not necessarily the name of the cert.

    Sue

     

  • msimone

    SSCommitted

    Points: 1634

    Hello Sue-H, it was my mistake, your answer woke up me, I put the correct certificate (there was a confusion) and all Works fine.

    Thank you

     

  • Sue_H

    SSC Guru

    Points: 90121

    Glad it got worked out - thanks for posting back!

    Sue

Viewing 6 posts - 1 through 6 (of 6 total)

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