Access & Query CDS/Dynamic 365 database using SQL (SSMS)

NOTE: This feature only allows read-only queries. You can not perform any other operations.

1- First off, check the version for your target environment. It must be at least?9.1.0.17437?but chances are, if you’re trying this, you are toying in a new trial instance. Anyway, you can check that by going to the little cog icon at the top-right side of the screen, and select About, as shown below.

2- Once you confirmed you have that version or a newer one, you now have to enable this feature(TDS Endpoint). from Power Platform Admin Center. You can find it by going to the Admin Center and selecting Environments > [your environment] > Settings > Features.

Make sure you hit?Save?on that screen, the Save button is under the fold on some screens.

3- Now, fire up SQL Server Management Studio and give it a whack. Connect to your CDS by putting in the server name field the URL of your instance, on port 5558. Your URL will look like this:

[org_name].crm[x].dynamics.com,5558

NOTE in the connection string you separate the port with a comma [,]

For Authentication select to use Azure Active Directory – Password, and plug in your user name and password.

4- Now hit Connect