Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. This Developer Center contains the guides for Commerce 6.13.0 through 7.4.1.Visit new site

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

Creating the Database in Microsoft SQL Server 2008

Creating the Database in Microsoft SQL Server 2008

Note: Before You Begin

Make sure you have Microsoft SQL Server 2008 installed to your production server.

Creating the Database

  1. Launch the SQL Server Management Studio.
  2. Login using Windows Authentication click Connect.
  3. In the Object Explorer, right-click the Databases node and choose New Database....
  4. Enter a database name in the Database name field, and click OK.

    When starting fresh with Elastic Path 6.13.0, it is recommended you name the database schema COMMERCEDB. This will make configuring Liquibase simpler, as this has been set as the default.

Creating a Database User Account

  1. In the Object Explorer, right-click the Security node and choose New -> Login....
  2. Select SQL Server authentication and specify a Login name and Password.

    ep/ep is the default login/password combination used by Elastic Path.

  3. In the Select a page list, select User Mapping.
  4. Select your Elastic Path Database
  5. Click OK.