Views:

Applies to Product - Dynamics 365 Supply Chain Management
 

What’s happening?
The customer is experiencing a validation error when attempting to connect from the development environment to Azure SQL.
 

Reason:
The connection string provided by the customer may not be in the correct format, or it may contain special characters in the password that are causing the validation error.
 

Resolution:

  1. Verify that the connection string is correctly formatted. The appropriate format is: Data Source=serverName;Initial Catalog=databaseName;Integrated Security=False;User ID=PlaceholderUserID;Password=PlaceholderPassword
  2. Check the password used for the SQL Server connection to ensure it does not contain any special characters that may cause validation issues.
  3. Refer to the documentation on strong passwords for guidance: Strong Passwords.