Connect SQL with Dynamics 365 CRM Online - Setup OrgDBOrgSettingsTool
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/... to connect to the remote server
Error 2:
Creating Organization Service Proxy with Url- https://yourorg.crm.dynamics.com/XRMS...
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?ProdNa...
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