Now we can connect Microsoft dynamics 365 Online with SQL and Query the Data.
It is Read only currently and can not be used in SSRS. but is a good start
Error :
Error occurred in OrgDBOrgSettings and the error details are Metadata contains a reference that cannot be resolved: ‘https://yourorg.crm8.com/XrmServices/2011/Discovery.svc?wsdl&sdkversion=8.2′.Unable to connect to the remote server
Error 2:
Creating Organization Service Proxy with Url- https://yourorg.crm.dynamics.com/XRMServices/2011/Organization.svc
Error occurred in OrgDBOrgSettings and the error details are Invalid Organization Setting passed in: EnableTDSEndpoint. Please check the datatype and pass in an appropriate value.
Error 3 :
Login failed: TDS protocol endpoint is disabled for this organization. For more information, please visit http://aka.ms/EnableSQLForCDS
RequestId: TDS;6d3b31e8-d260-410c-9a23-cca78cbd1795;2
Time: 2020-05-21T07:17:56.0358439Z (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
Setting up OrgDBOrgSettingsTool for enabling TDS ENDPOINT.
Table of Contents:
00:00 – Introduction
00:10 – SQL in Dynamics 365 crm Online CDS
01:22 – 1st attempt to connect
01:42 – Error TDS Endpoint
02:01 – Prerequisite for enable TDS ENDPOINT
02:39 – Download OrgDBOrgSetting
04:10 – Running Utility to enable TDS endpoint
04:55 – Succcesfully connected with SQL
05:25 – Query on SQL & MSCRM online
source
More About This Author
Array
YouTube26 March 2024MS D365 Sales Accelerator Demo: Unravelling Segmentation, Sequences, Assignment, & more – YouTube
YouTube20 March 2024Configuring Mailbox in Microsoft Dynamics 365 CE: Step-by-Step Guide – YouTube
YouTube18 March 2024How to Debug Canvas Apps with the Monitor Tool: Tutorial – YouTube
YouTube18 March 2024How to Launch Native Apps from Canvas Apps: Step-by-Step Tutorial Using Launch Function – YouTube
