celedonpartners.com

“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

by | Dec 22, 2016 | Blog, Microsoft Dynamics |

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=”http://schemas.microsoft.com/xrm/2011/Contracts” xmlns:i=”http://www.w3.org/2001/XMLSchema-instance”>
<ActivityId>00000000-0000-0000-0000-000000000000</ActivityId>
<ErrorCode>-2147187410</ErrorCode>
<ErrorDetails xmlns:a=”http://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=”http://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=”http://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.