Set up a store database profile

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

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.

Note

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.