"Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB" in Dynamics CRM 2016 with Azure Service Bus Integration

Ran into this error with one of our customers while trying to register a service endpoint for Azure Service Bus integration with Dynamics CRM 2016 SP1 (on-prem.) We were using a shared access key (SAS) for authentication.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=0x0x0x0x0x0x0x0x]]: Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.
Detail: <OrganizationServiceFault xmlns=”https://schemas.microsoft.com/xrm/2011/Contracts” xmlns:i=”https://www.w3.org/2001/XMLSchema-instance”>
<ActivityId>00000000-0000-0000-0000-000000000000</ActivityId>
<ErrorCode>-2147187410</ErrorCode>
<ErrorDetails xmlns:a=”https://schemas.datacontract.org/2004/07/System.Collections.Generic” />
<Message>Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.</Message>
<Timestamp>2016-12-16T22:02:24.6902993Z</Timestamp>
<ExceptionSource i:nil=”true” />
<InnerFault>
<ActivityId>00000000-0000-0000-0000-000000000000</ActivityId>
<ErrorCode>-2147187410</ErrorCode>
<ErrorDetails xmlns:a=”https://schemas.datacontract.org/2004/07/System.Collections.Generic” />
<Message>Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.</Message>
<Timestamp>2016-12-16T22:02:24.6902993Z</Timestamp>
<ExceptionSource i:nil=”true” />
<InnerFault>
<ActivityId>00000000-0000-0000-0000-000000000000</ActivityId>
<ErrorCode>-2147187410</ErrorCode>
<ErrorDetails xmlns:a=”https://schemas.datacontract.org/2004/07/System.Collections.Generic” />
<Message>Cannot open Sql Encryption Symmetric Key because Symmetric Key password does not exist in Config DB.</Message>
<Timestamp>2016-12-16T22:02:24.6902993Z</Timestamp>
<ExceptionSource i:nil=”true” />
<InnerFault i:nil=”true” />
<OriginalException i:nil=”true” />
<TraceText i:nil=”true” />
</InnerFault>
<OriginalException i:nil=”true” />
<TraceText i:nil=”true” />
</InnerFault>
<OriginalException i:nil=”true” />
<TraceText i:nil=”true” />
</OrganizationServiceFault>
 
 
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
 
 
Exception rethrown at [0]:
at Microsoft.Crm.Tools.Libraries.RegistrationHelper.RegisterServiceEndpoint(CrmOrganization org, CrmServiceEndpoint serviceEndpoint)
at Microsoft.Crm.Tools.ServiceEndPointRegistration.NewServiceBusEndPointConfigViewModel.SaveServiceEndpoint()

The solution to this issue was to enable data encryption on CRM 2016 by logging into your organization > Settings > Data Management > Security > Activating data encryption on the CRM organization.
 
 

Leave a Reply

Your email address will not be published. Required fields are marked *

Let's talk

If you want to get a free consultation without any obligations, fill in the form below and we'll get in touch with you.