SQL Service Broker warning when restoring a customer database to a different server
|Article:HOWTO58557|||||Created: 2011-08-01|||||Updated: 2013-07-12|||||Article URL http://www.symantec.com/docs/HOWTO58557|
SQL Server may record the following warning message in the event log if you restore a Compliance Accelerator customer database to a different server than that on which it originally resided:
Service Broker needs to access the master key in the database 'database_name'. Error code:25. The master key has to exist and the service master key encryption is required.
You can suppress this warning message by using the following SQL Server command to create a master key for the database:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'
For more information, see the following article on the Microsoft website:
Article URL http://www.symantec.com/docs/HOWTO58557