Service Broker needs to access the master key in the database ‘BRM_TEST’. Error code:32. The master key has to exist and the service master key encryption is required.


Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58

日志错误:
Service Broker needs to access the master key in the database 'BRM_TEST'. Error code:32. The master key has to exist and the service master key encryption is required.

原因:
SqlDependency在清理服务,队列,存储过程时需要一个转换,这个转换需要数据库的master key去存储产生的会话key,虽没多大影响,但会产生错误日志。解决方法是创建一个key给他用。
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '23987hxJ#KL95234nl0zBe';

参考:SqlDependency问题大全