Article By:

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.
 
 

Need Assistance?

Speak with an Engineer

Not sure where to start? We're here to help walk you through the process, understand your environment, and provide the guidance you need to achieve cybersecurity maturity. Get in touch today.

Get in Touch