sql-server - Service Broker 主 key 的要求

Question

我在各种 MSDN 页面和 SQL Server 博客中读到，Service Broker 数据库“通常”需要主 key 。

确实，当尝试接收消息时，我收到以下应用程序事件日志消息:

Service Broker needs to access the master key in the database 'MDR_REPLICATION_Z'. Error code:26. The master key has to exist and the service master key encryption is required.

令我困惑的是，当我所有的对话都已关闭加密时，为什么会发生这种情况。

有没有一种方法可以在 ENCYRPTION 处于关闭状态的单个数据库内部使用 Service Broker，而无需创建数据库主 key ？

Answer 1

来自Service Broker Dialog Security :

Service Broker dialog security lets your application use authentication, authorization, or encryption for an individual dialog conversation (or dialog). By default, all dialog conversations use dialog security. When you begin a dialog, you can explicitly allow a dialog to proceed without dialog security by including the ENCRYPTION = OFF clause on the BEGIN DIALOG CONVERSATION statement. However, if a remote service binding exists for the service that the conversation targets, the dialog uses security even when ENCRYPTION = OFF.

换句话说，请确保您没有任何匹配的远程服务绑定(bind)。