Источник:
http://www.artofcreation.be/2022/11/...asswordplaceh/
==============
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:
- Go to the Azure portal at https://portal.azure.com/
- In All resrouces, go to you database server
- Under Security, go to Networking
- Enable Allow Azure services and resources to access the server
- Click Save
Источник:
http://www.artofcreation.be/2022/11/...asswordplaceh/