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
- Launch the SQL Server Management Studio.
- Login using Windows Authentication click Connect.
- In the Object Explorer, right-click the Databases node and choose New Database....
- Enter a database name in the Database name field, and click OK.Note:
When starting fresh with Elastic Path 6.14.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
- In the Object Explorer, right-click the Security node and choose New -> Login....
- Select SQL Server authentication and specify a Login name and Password.Note:
ep/ep is the default login/password combination used by Elastic Path.
- In the Select a page list, select User Mapping.
- Select your Elastic Path Database
- Click OK.