Set up a store database profile [AX 2012]

Updated: January 27, 2014

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack

A database profile provides the information that enables Microsoft Dynamics AX to communicate with a retail store database or an online channel database.


The information in this topic applies only to Microsoft Dynamics AX 2012 R2 and Microsoft Dynamics AX 2012 Feature Pack.

  1. Click Retail > Setup > Retail scheduler > Channel integration > Database profiles.

  2. Press CTRL+N to create a new database profile. Optionally, you can click Copy to create a new profile that is based on the currently selected profile.

  3. Complete the following information:

    • Name – Type a name for the profile.

    • Version – Select the version of Microsoft SQL Server for the database.

    • Server name – Type the name of the database server.

    • Database name – Type the name of the database that is used for the selected store or register.

    • Encrypt database connection – Select the check box to use the encrypted connection option in SQL Server for this database connection.

    • Commerce Data Exchange: Synch Service – Select the profile for the correct instance of Commerce Data Exchange: Synch Service.

  4. Click Test connection to test the connection string for the selected database profile. For information about how to resolve connection errors, see Troubleshoot a connection.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).