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:
- Login to https://admin.powerplatform.microsoft.com/ using administrator credentials.
- 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.)
- When Environment opens click on settings in header.
- Settings page will open, Click on Product and then click on Features.
- When features Page opens enable TDS Endpoint (Preview) and click save.
- Now, we have successfully enabled D365 CRM CDS to connect it from MS SQL Server.
Steps to Connect CDS Database from MS SQL Server:
- Open MS SQL Server.
- 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.
- Select Authentication as Azure Active Directory – Password.
- Enter Username: Your admin user id e.g. admi[email protected]
- Enter Password: (Your Login password) ********
- Click Connect.
- Now, you have successfully connected to D365 CRM DB.
- Write a select query and test if it’s working.