D365 F&O: Incorrect connection string. The connection string should be of format Data Source=serverName;Initial Catalog=databaseName;Integrated Security=False;User ID=PlaceholderUserId;Password=PlaceholderPassword

November 24, 2022 at 10:21
filed under Dynamics 365
Tagged ,

On the Configure entity export to database page in Data management, you can create new source data formats of the type Azure SQL DB.
When you have correctly configured the connection string and click the Validate button, you can get the following error:

Incorrect connection string. The connection string should be of format Data Source=serverName;Initial Catalog=databaseName;Integrated Security=False;User ID=PlaceholderUserId;Password=PlaceholderPassword

You can get this error even when the format is incorrect. The issue is that Dynamics cannot connect to your database server.

In my case the firewall rules were not setup correctly. To fix this:

  1. Go to the Azure portal at https://portal.azure.com/
  2. In All resrouces, go to you database server
  3. Under Security, go to Networking
  4. Enable Allow Azure services and resources to access the server
  5. Click Save

no comments

RSS / trackback

respond