Install Sana Commerce Webshop on Web and Database Server

Configuration of providers for users of Sana Commerce - SQL Provider with interfaces is shown below:

Step 1: Open the 'web.config' file of the Sana Commerce Starter Site project in Visual Studio or any text editor
(do the same for the 'web.config' file of the 'Sana.Commerce.BackOffice' project).

Step 2: Locate the <modules> configuration section and replace it with the one provided below:

<modules>
  <catalog defaultProvider="SanaCommerceSqlCatalogProvider">
   <providers>
    <clear/>
    <add name="SanaCommerceSqlCatalogProvider" serviceConnection="LocalSqlServer"
 type="Sana.Commerce.Customization.Catalog.DatabaseExtendedCatalogProvider, Sana.Commerce.Sdk, Culture=neutral"/>
    <add name="AXCatalogProvider" serviceConnection="AxWebService"
 type="Sana.Commerce.Customization.Catalog.AXExtendedCatalogProvider, Sana.Commerce.Sdk, Culture=neutral"/>
   </providers>
  </catalog>
  <customer defaultProvider="SanaCommerceSqlCustomerProvider">
   <providers>
    <clear/>
    <add name="SanaCommerceSqlCustomerProvider" serviceConnection="LocalSqlServer"
 type="Sana.Commerce.Customization.Customer.DatabaseExtendedCustomerProvider, Sana.Commerce.Sdk, Culture=neutral"/>
    <add name="AXCustomerProvider" serviceConnection="AxWebService"
 type="Sana.Commerce.Customization.Customer.AXExtendedCustomerProvider, Sana.Commerce.Sdk, Culture=neutral"/>
   </providers>
  </customer>
  <order defaultProvider="SanaCommerceSqlOrderProvider">
   <providers>
    <clear/>
    <add name="SanaCommerceSqlOrderProvider" serviceConnection="LocalSqlServer"
 type="Sana.Commerce.Customization.Order.DatabaseExtendedOrderProvider, Sana.Commerce.Sdk, Culture=neutral"/>
    <add name="AXOrderProvider" serviceConnection="AxWebService"
 type="Sana.Commerce.Customization.Order.AXExtendedOrderProvider, Sana.Commerce.Sdk, Culture=neutral"/>
   </providers>
  </order>
  <shop defaultProvider="SanaCommerceSqlShopProvider">
   <providers>
    <clear/>
    <add name="SanaCommerceSqlShopProvider" type="Sana.Commerce.Customization.Shop.DatabaseExtendedShopProvider, Sana.Commerce.Sdk, Culture=neutral" description="ShopProvider which retrieves shopdata (baskets, ect) from SQL database" serviceConnection="LocalSqlServer"/>
   </providers>
  </shop>
  <common defaultProvider="SanaCommerceSqlCommonProvider">
   <providers>
    <clear/>
    <add name="SanaCommerceSqlCommonProvider" serviceConnection="LocalSqlServer"
 type="Sana.Commerce.Customization.Common.DatabaseExtendedCommonProvider, Sana.Commerce.Sdk, Culture=neutral"/>
    <add name="AXCommonProvider" serviceConnection="AxWebService"
 type="Sana.Commerce.Customization.Common.AXExtendedCommonProvider, Sana.Commerce.Sdk, Culture=neutral"/>
   </providers>
  </common>
  <content defaultProvider="SanaCommerceSqlContentProvider">
   <providers>
    <clear/>
    <add name="SanaCommerceSqlContentProvider" type="Sana.Commerce.Customization.Content.DatabaseExtendedContentProvider, Sana.Commerce.Sdk, Culture=neutral" description="Content provider which retrives content data(content pages, product enrichments) from SQL DB" serviceConnection="LocalSqlServer"/>
   </providers>
  </content>
</modules>