Raul Garcia - MS
I am talking about the *.cer files that are under the Data folder for SQL Server.
When SQL Server Agent is installed or updated via setup, the modules (i.e. SPs, etc.) are re-signed by a newly generated certificate.
Because this certificate is not under the control of Microsoft, a copy of the certificate public data (*.cer) is copied (i.e. a backup) in the Data folder (which is the default folder for certificate BACKUP operations).
The copies of these public certificates in the data folder are simply copies of the latest MS agent signing certificate as well as probably some copies from old MS agent certificates, but SQL Sever server itself doesn’t use them anymore.
I would suggest opening them (just open them, do not install them), you should see something like this:
General:
Issued to: MS_AgentSigningCertificate
Issued by: MS_AgentSigningCertificate
And if you click on the details tab, you will see different thumbprint for each of them.
I hop this answers your question
-Raul Garcia
SDE/T
SQL Server Engine
-------------------------
короче, делай либо свежую установку МайСкюэля либо апдейт через setup и свежий *.cer подтянется
