Critical Error: Data Store Unavailable

The data store used by eCommerce Framework cannot be opened.


Resolution:
Please ensure that your data service is online and running and that the connection string in your web.config file is correct and make sure the key specified by
ConnnectionStringName exists in connectionStrings section.

To configure your connection string:

1. Open [Install Location of eCommerce Framework]\PublicStore\web.config

2. Within web.config find the configuration section (highlighted) below:

<configuration>
   <ClientConfig>
        <Settings ConnectionStringName="EcfSqlConnection" SubscriptionId="{SUBSCRIPTION_GUID}" 
CartKey="ShoppingCartKey" AffiliateKey="AffiliateKey" Expires="24"></Settings> 
   </ClientConfig> 
   ...

   <connectionStrings>
        <add name="EcfSqlConnection" connectionString="{connection string to your database}"/>
   </connectionStrings>
</configuration>
Error Message:
System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Mediachase.eCF.DataLayer.TransactionScope.Enlist(IDbCommand cmd, String connectionString, ConnectionDelegate connection) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\SupportProjects\Data\DataProvider\TransactionScope.cs:line 101 at Mediachase.eCF.DataLayer.Provider.SqlDataProvider.LoadTable(DataCommand command) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\SupportProjects\Data\SqlDataProvider\SqlDataProvider.cs:line 251 at Mediachase.eCF.DataLayer.Provider.DataService.LoadTable(DataCommand command) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\SupportProjects\Data\DataProvider\DataService.cs:line 52 at Mediachase.eCF.DataLayer._GlobalSetting.LoadAll() in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\BusinessLibrary\Data\Generated\_GlobalSetting.cs:line 45 at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.LoadHash() in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 71 at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetParamValue(String ParamName) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 120 at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetBooleanValue(String ParamName, Boolean DefaultValue) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 143 at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetBooleanValue(String ParamName) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 158 at Mediachase.eCF.BusLayer.FrameworkContext.get_StoreClosed() in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\BusinessLibrary\FrameworkContext.cs:line 242 at Mediachase.eCF.BusFacade.Engine.ServicePipeHelper.CheckSubscription(String SubscriptionId, IList`1& errorArray) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\FacadeLibrary\Engine\ServicePipeHelper.cs:line 495 at Mediachase.eCF.BusFacade.SiteNodeManager.SiteNodeLookup(SiteNodeLookup lookup) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\BusinessLayer\FacadeLibrary\SiteNodeManager.cs:line 119 at Mediachase.eCF.ClientLib2.ClientCatalog.LookupPages(String[] pages, String[] responseGroups, ErrorsError[]& errors) in C:\DevLocal\Websites\BT_TB_ECF\Mediachase_4_1_2\PublicLayer\ClientLibrary\ClientCatalog.cs:line 280

  For more information visit http://www.mediachase.com.