Connect SQL with Dynamics 365 CRM Online – Setup OrgDBOrgSettingsTool – YouTube

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