CRM Dynamics Connection Manager

[diana....@naht.org.uk]

Hi

I am trying to connect to our on-premise CRM server using the Connection Manager.

I am not getting the options you describe on your website.  I have the options 365, Federation, Live.

When I try to connect to my 2011 on-premise server I am getting the following error.  Can you give me any ideas as to what I need to check on the on-premise server with regards to accessing the Discovery service.

===================================

Failed to download from 'https://naht.nahtedge.org.uk/XRMServices/2011/Discovery.svc?wsdl=wsdl1'. (CozyRoc.Dynamics)

------------------------------

Program Location:

   at CozyRoc.Dynamics.Crm2011.TokenProxy._Authenticate()

   at CozyRoc.Dynamics.Crm2011.TokenProxy.GetToken()

   at CozyRoc.Dynamics.Crm2011.DiscoveryService.DiscoveryServiceClientWCF.CreateChannel()

   at System.ServiceModel.ClientBase`1.CreateChannelInternal()

   at System.ServiceModel.ClientBase`1.get_Channel()

   at CozyRoc.Dynamics.Crm2011.DiscoveryService.DiscoveryServiceClient.Execute(DiscoveryRequest request)

   at CozyRoc.SqlServer.SSIS.CrmConnection2011.Connect()

   at CozyRoc.SqlServer.SSIS.CrmConnection.Connect()

   at CozyRoc.SqlServer.SSIS.CrmConnectionManagerForm.btnTestConnection_Click(Object sender, EventArgs e)

===================================

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. (System)

------------------------------

Program Location:

   at System.Net.HttpWebRequest.GetResponse()

   at CozyRoc.Dynamics.Crm2011.TokenProxy._CallService(String url, String soapMessage)

   at CozyRoc.Dynamics.Crm2011.TokenProxy._Authenticate()

===================================

The remote certificate is invalid according to the validation procedure. (System)

------------------------------

Program Location:

   at System.Net.Security.SslState.StartSendAuthResetSignal(ProtocolToken message, AsyncProtocolRequest asyncRequest, Exception exception)

   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.ProcessReceivedBlob(Byte[] buffer, Int32 count, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartReadFrame(Byte[] buffer, Int32 readBytes, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartReceiveBlob(Byte[] buffer, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.CheckCompletionBeforeNextReceive(ProtocolToken message, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.StartSendBlob(Byte[] incoming, Int32 count, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.ForceAuthentication(Boolean receiveFirst, Byte[] buffer, AsyncProtocolRequest asyncRequest)

   at System.Net.Security.SslState.ProcessAuthentication(LazyAsyncResult lazyResult)

   at System.Net.TlsStream.CallProcessAuthentication(Object state)

   at System.Threading.ExecutionContext.runTryCode(Object userData)

   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)

   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

   at System.Net.TlsStream.ProcessAuthentication(LazyAsyncResult result)

   at System.Net.TlsStream.Write(Byte[] buffer, Int32 offset, Int32 size)

   at System.Net.PooledStream.Write(Byte[] buffer, Int32 offset, Int32 size)

   at System.Net.ConnectStream.WriteHeaders(Boolean async)

[Ivan Peev]

Hi Diana,

The certificate of your on-premise Dynamics CRM server is invalid. You have two options:

1. Correct your server certificate.

2. Setup the machine where you use COZYROC's Dynamics CRM adapters to explicitly trust the current Dynamics CRM server certificate.

[diana....@naht.org.uk]

I have just installed the latest version of cozy roc to resolve the 'Federation' issue.  However although our CRM Dynamics is 'on premise', it is hosted remotely which I think is probably the issue.  Is there anyway around this, we have access to the server etc but not sure your connnection manager will let us do the double hop?

[Ivan Peev]

Diana,

Your issue is not the double hop. Your issue is the invalid server certificate.

[naht...@gmail.com]

Hi Ivan

So I have resolved the cerfication error message which was an issue our side with a very old server.  I am now connecting from a new server.  Can you confirm the syntax required in the 'server' dialogue and the credentials, ie are they the AD credentials used to access the CRM, or are they credentials to access the server.

Many thanks.

Di

[Ivan Peev]

Hi Diana,

You have to provide credentials to access the CRM.