Sunday, May 22, 2011

SQL Server-Level Principal Login Certificate

On one of our SQL2005 instances, a certificate used for SQL Server-level principal login, ##MS_SQLAgentSigningCertificate##, is currently not trusted as a CA Root cert.  It needs to be installed/added back as a Trusted Root CA.

Technet discusses these certificates.  I have not found much on these certs except an incident where MSDB was moved to another instance and permissions needed to be fixed.

My assumption is the cert store on the server lost its reference to the CA Cert and just needs to be added back in.  I added in the cert and that solved the problem.

No comments:

Post a Comment