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: Login failed for user 'triplexmoto'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
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.Provider.DataService.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.FrameworkContext.get_StoreClosed()
at Mediachase.eCF.BusFacade.Engine.ServicePipeHelper.CheckSubscription(String SubscriptionId, IList`1& errorArray)
at Mediachase.eCF.BusFacade.SiteNodeManager.SiteNodeLookup(SiteNodeLookup lookup)
at Mediachase.eCF.ClientLib2.ClientCatalog.LookupCategories(Int32[] categories, String[] responseGroups, ErrorsError[]& errors) in C:\Team Projects\TripleXMoto\TripleXMoto\ClientLibrary\ClientCatalog.cs:line 120
|