Applies to Product – Dynamics 365 Commerce
What’s happening?
Customers inquired about the prerequisites for using the BYOD (Bring Your Own Database) feature with Azure SQL Database, specifically regarding connection settings and collation requirements.
Reason:
The underlying cause of the inquiries was related to security concerns regarding the connection string and the need for proper collation settings to ensure compatibility between the BYOD feature and Azure SQL Database.
Resolution:
- For connection authentication, it is noted that currently, the BYOD feature only supports specific connection authentication methods as documented.
- Customers are advised to ensure that the collation settings for the Azure SQL Database match the required collation settings for the BYOD feature. The supported collation for cloud deployments is specified in the official documentation.
- For detailed guidance on configuring the entity export option and connection authentication methods, refer to the official documentation: Configuring the Entity Export Option.
- If there are security concerns, customers can implement security practices such as adding firewall rules to restrict access.
- For further assistance regarding security practices and configurations, customers are encouraged to consult the Azure SQL Database support team.