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

DES_22

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’.

DES_12

  • Post the Azure Key vault generation, validate the ‘Secret value’ from Azure portal.

DES_28

  • 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.

DES_27

  • Make sure following ‘Firewall settings’ made to your Azure SQL server.
    • Open the ‘SQL Server’ from Azure Portal and click on ‘Show firewall settings’
    • DES_26
    • Make settings as below
    • DES_25
  • Now try validating the Data Export Service’s ‘Key Vault URL’ from the ‘Profile’ and it should work.

DES_24

Refer my Step by step configuring Data Export Service article on the usage of Data Export Service.

🙂

  1. Prasad Vasadi
    September 9, 2020 at 7:30 AM

    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?

    • September 9, 2020 at 9:15 AM

      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.

      • Prasad Vasadi
        September 9, 2020 at 11:07 AM

        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.

      • Prasad Vasadi
        September 9, 2020 at 12:11 PM

        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?

  1. March 14, 2020 at 8:41 PM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: