June 12, 2019 at 10:49 am
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.
June 12, 2019 at 11:10 pm
Did you check for the certificate by querying sys.certificates in the database?
Sue
June 13, 2019 at 6:33 am
Hello Sue_H, of course, for that I don't understand.
June 13, 2019 at 4:21 pm
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
June 18, 2019 at 1:17 pm
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
June 18, 2019 at 4:43 pm
Glad it got worked out - thanks for posting back!
Sue
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply