Connect D365 CRM CDS Database From SQL Server

Connect D365 CRM CDS Database from SQL Server


Many times, we feel like why I can’t access D365 CRM Database directly from MS SQL Server, so here is my blog that will guide you on how you can connect D365 CRM CDS Database using MS SQL Server.

Steps to enable D365 CRM CDS Database to make it connect from MS SQL Server:

  1. Login to https://admin.powerplatform.microsoft.com/ using administrator credentials.
  2. In Environment section, click on your environment for which you want to enable D365 CRM CDS for MS SQL Server. (In my case I am clicking on DemoEnvironment as shown below.)
  3. When Environment opens click on settings in header.
  4. Settings page will open, Click on Product and then click on Features.
  5. When features Page opens enable TDS Endpoint (Preview) and click save.
  6. Now, we have successfully enabled D365 CRM CDS to connect it from MS SQL Server.

Steps to Connect CDS Database from MS SQL Server:

  1. Open MS SQL Server.
  2. In connect to SQL Server Window enter Server name (It will be your D365 CRM URL) followed by comma and Port Number (5558) e.g. of server name yourdomain.crm.dynamics.com,5558.
  3. Select Authentication as Azure Active Directory – Password.
  4. Enter Username: Your admin user id e.g. admin@xyz.com
  5. Enter Password: (Your Login password) ********
  6. Click Connect.
  7. Now, you have successfully connected to D365 CRM DB.
  8. Write a select query and test if it’s working.

Enjoy!!!

Comments

Popular posts from this blog

Make D365 CRM Entity as Read only

Convert an Array to comma separated string in Power Automate

Trigger an Email when account is created in D365 CRM using Azure Logic App