Any way to re-create ##MS_AgentSigningCertificate## user in master database

Question

Hi, the ##MS_AgentSigningCertificate## user from the master database on one of our QA instances got deleted by mistake.  I was wondering if there was any way to re-create the user without restoring the master database ..

Thanks

Answer 1

Sorry ...  a little more details.  We are running SQL Server 2005 SP3 (build 9.0.4053).  Thanks

Answer 2

Hi,

Try the following statements:

USE master;
GO
CREATE USER [##MS_AgentSigningCertificate##] FOR CERTIFICATE [##MS_AgentSigningCertificate##];
GO

If there are any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***