Article ID: 2000274 - View products that this article applies to.
Consider the following scenario:
You move msdb database from one instance to another either using the backup and restore process or by copying over the database files (mdf and ldf). Then, on the destination server, a user who is not part of Sysadmin fixed role in SQL Server tries to do either of the following operations:
In this scenario, the user will get anerror message similar to the following:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
This issue occurs because the SQL Agent certificate is different on different instances.
To resolve the issue you need to replace the certificate in the master with the certificate from the restored msdb database by using the following script at the destination server:
CREATE CERTIFICATE [MS_AgentSigningCertificate.remote_server] FROM FILE = 'MS_AgentSigningCertificate.remote_server.cer'
Note: In a scenario where the certificates in master and model are the same before running the script discussed in the article, executing the script results in the following error message:
Msg 15232, Level 16, State 1, Line 7
If you experience the symptoms discussed in the article even when the certificates are the same, please contact Microsoft Customer Support Services (CSS) for more help.
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2000274 - Last Review: June 26, 2009 - Revision: 1.0