Показать сообщение отдельно
Старый 24.11.2022, 12:12   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
Art Of Creation: 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
Источник: 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:
  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

Источник: http://www.artofcreation.be/2022/11/...asswordplaceh/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.