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>
|
System.Data.SqlClient.SqlException: Cannot open database "PSS5_Web" requested by the login. The login failed.
Login failed for user 'UNL-AD\pressruntimeuser'.
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)
at Mediachase.eCF.DataLayer.Provider.SqlDataProvider.LoadTable(DataCommand command)
at Mediachase.eCF.DataLayer._GlobalSetting.LoadAll()
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.LoadHash()
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetParamValue(String ParamName)
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetBooleanValue(String ParamName, Boolean DefaultValue)
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetBooleanValue(String ParamName)
at Mediachase.eCF.BusLayer.FrameworkContext.get_StoreClosed()
at Mediachase.eCF.BusFacade.Engine.ServicePipeHelper.CheckSubscription(String SubscriptionId, IList`1& errorArray)
at Mediachase.eCF.BusFacade.SiteManager.SiteLookup(SiteLookup lookup)
at Mediachase.eCF.ClientLib2.ClientProduct.LookupProducts(SiteLookupRequestIdType type, Int32[] objects, String[] responseGroups, ErrorsError[]& errors)
|