Set Up User Access to the Store Database

After installing the eCommerce, set up the user account to access the database and establish your Store Site. To do this,

• Open the SQL Server Management Studio. Go to Start > Programs > Microsoft SQL Server 2008 R2 then select the SQL Server Management Studio option.
• On the Connect to Server dialogue, indicate the server name or instance where the database is installed and the authentication mode.
• Click Connect after entering all the required data.
• The SQL Express Management Studio will be displayed. From the Object Explorer section, open the Security folder and select the Logins folder. Right click on the Logins folder and select New Login option.
• In the Login-New window, enter the desired login name in the Login Name field. For the authentication mode, select SQL Server Authentication. Enter and confirm the desired password.
• Uncheck the Enforce Password Policy checkbox. (This is recommended so you can create your own passwords with less restriction. You can also leave this option enabled if preferred.)
• Next, click on the User Mapping option. Select the store database/s where the user will have access to.
• Enable the db_Owner checkbox to set the role membership for the database selected. Click OK to apply the settings. The newly created login has been added to the login list.

This method of setting up the database user is helpful especially if you have more than one database in your ecommerce system.