Home
> Dynamics 365 > D365 Data Export Service – Unable to connect to Azure SQL Server from Profile
D365 Data Export Service – Unable to connect to Azure SQL Server from Profile
Other day while configuring Data Export Service to replicate the CDS data to Azure SQL Server’s Database, I encountered following error from the ‘Profile’ creation step:
Unable to connect to the Destination mentioned in the KeyVault URL
Troubleshooting steps and Fix:
From the error message its clear that, Data Export Service unable to connect to the Destination which is Azure SQL Server’s DB in my case. Following checks helped me to resolve the issue.
- Make sure you copy the Azure SQL DB connection string using the ‘Copy’ option. This is super important when you are creating the ‘Key vault URL’.
- Post the Azure Key vault generation, validate the ‘Secret value’ from Azure portal.
- Test the Azure SQL DB connection from either SSMS or .udl file using the same ‘User ID’ and ‘Password’ specified while generating the Azure Key Vault URL.
- Make sure following ‘Firewall settings’ made to your Azure SQL server.
- Open the ‘SQL Server’ from Azure Portal and click on ‘Show firewall settings’
- Make settings as below
- Now try validating the Data Export Service’s ‘Key Vault URL’ from the ‘Profile’ and it should work.
Refer my Step by step configuring Data Export Service article on the usage of Data Export Service.
🙂
Rajeev Pentyala - Microsoft Power Platform 
Hi
Great content, it was very helpful.
I have Power Apps per user plan license. DES installation always failing. Do you have an idea ? will be the license issue?
Please suggest?
Whats the error you getting? Hope you are making sure “To use the Data Export Service the model-driven apps in Dynamics 365 and Azure Key Vault services must operate under the same tenant and within the same Azure Active Directory”. Refer this https://rajeevpentyala.com/2020/03/14/step-by-step-data-export-service-replicate-cds-data-to-azure-sql-server-database/ and make sure you are not missing any step.
Hi Rajeev,
Thanks for quick response.
I have gone through your steps and failed here
Installing ‘Data Export Service’ from AppSource
The first step of installation failing.
Data export service installation failed.
I am not able to share the screen shot here.
Please share your email so, I can share the screen shots to understand.
Many Thanks.
Hi Rajeev,
Thanks for quick response.Here is error message.
How to troubleshoot
To fix this problem retry installation. For directions on how to do this see here.
DataExportService
ImportSolutionError
Solution manifest import: FAILURE: The following solution cannot be imported: DataExportService. Some dependencies are missing. The missing dependencies are : , ProductUpdatesOnly : False
Error code
-2147188685
Please suggest?