Install Sana Commerce Webshop on Web and Database Server

Configure the Providers

Configuration of providers for users of Sana Commerce - SQL Provider 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" type=
"Sana.Commerce.Customization.Catalog.DatabaseExtendedCatalogProvider, Sana.Commerce.Sdk, Culture=neutral" 
   description="CatalogProvider which retrieves catalog information from Sql server" 
   serviceConnection="LocalSqlServer" />
          </providers>
        </catalog>
        <customer defaultProvider="SanaCommerceSqlCustomerProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlCustomerProvider" type=
"Sana.Commerce.Customization.Customer.DatabaseExtendedCustomerProvider, Sana.Commerce.Sdk, Culture=neutral" 
   description="CustomerProvider which retrieves catalog information from Sql server" 
   serviceConnection="LocalSqlServer" />
          </providers>
        </customer>
        <order defaultProvider="SanaCommerceSqlOrderProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlOrderProvider" type=
"Sana.Commerce.Customization.Order.DatabaseExtendedOrderProvider, Sana.Commerce.Sdk, Culture=neutral" 
   description="OrderProvider which retrieves catalog information from Sql server" 
   serviceConnection="LocalSqlServer" />
          </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 shop information (baskets, ect) from SQL database" 
   serviceConnection="LocalSqlServer" />
          </providers>
        </shop>
        <common defaultProvider="SanaCommerceSqlCommonProvider">
          <providers>
            <clear />
            <add name="SanaCommerceSqlCommonProvider" type=
"Sana.Commerce.Customization.Common.DatabaseExtendedCommonProvider, Sana.Commerce.Sdk, Culture=neutral" 
   description="CommonProvider which retrieves catalog information from Sql server" 
   serviceConnection="LocalSqlServer" />
          </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 information (content pages, product descriptions) from SQL DB" 
   serviceConnection="LocalSqlServer" />
          </providers>
        </content>
</modules>