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
Article Type
How To


Subject


SQL Service Broker warning when restoring a customer database to a different server

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:

http://msdn.microsoft.com/en-us/library/aa337551(SQL.90).aspx

See Synchronization errors after you rename the SQL Server computer


Legacy ID



v20951600_v41328187


Article URL http://www.symantec.com/docs/HOWTO58557


Terms of use for this information are found in Legal Notices