|
Group: Forum Members
Last Active: Mon 21 May 2018
Posts: 94,
Visits: 266
|
I'm trying the cart out on shared hosting which has a decent for tool for SQL admin. I ceated a blank database in preparation to the Kartris install procedure and when the web config procedure ran, I chose to connect to an existing database. There were no errors so I assume the connection was successful. Upon trying to access the home page I get the following connection error:
Server Error in '/' Application.
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) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: 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)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[SqlException (0x80131904): 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)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849015 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +4862333 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +90 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +342 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +221 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +189 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +433 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +499 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117 System.Data.SqlClient.SqlConnection.Open() +122 System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +115 kartrisConfigDataTableAdapters.ConfigCacheTblAdptr._GetConfigCacheData() +90 ConfigBLL.GetConfigCacheData() +15 Kartris.KartSettingsManager.RefreshCache() +105 Kartris.KartSettingsManager.GetKartConfig(String Config_Name, Boolean RefreshCache) +75 ASP.global_asax.Application_BeginRequest(Object sender, EventArgs e) +896 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75 |
Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955
Looking in the SQL admin it does appear that connection was successful during setup as there are lots of Kartris tables now populated in the schema.
I'm not an SQL admin so this sort of error leaves me out of my depth...
|
|
Group: Forum Members
Last Active: Fri 31 Oct 2014
Posts: 18,
Visits: 96
|
I have just worked through these issues when running kartris on a hosted site (1and1). The first issue is that the web.config file is not updated on the hosted site so you will need to edit manually. in the following section edit servername, databasename, username and password.
<connectionStrings><add name="KartrisSQLConnection" connectionString="Data Source=SERVERNAME;Initial Catalog=DATABASENAME;User ID=USERNAME;Password=PASSWORD" providerName="System.Data.SqlClient" /></connectionStrings>
copy the saltstring kartris showed you on installation to PutSomeRandomTextHere
<add key="HashSalt" value="PutSomeRandomTextHere"/>
then uncomment the string below
<!-- <globalization resourceProviderFactoryType="Kartris.SqlResourceProviderFactory" culture="auto" uiCulture="auto" enableClientBasedCulture="true"/> -->
kartris should then run with no errors
Wed 9 Mar 2011 by
thopcroft
|
|
Group: Forum Members
Last Active: Mon 21 May 2018
Posts: 94,
Visits: 266
|
Ahaaaaa...the curse of 1&1 shared hosting strikes again. Then again, it was better-the-devil-you-know that made me choose them instead of fast2host.co.uk.
Well; many thanks for that solution, it certainly worked. Not the fastest of page generation on this shared hosting mularky though. Don't think the boss will stretch to a dedicated server though...
|
|
Group: Administrators
Last Active: Wed 18 Nov 2020
Posts: 148,
Visits: 3,450
|
Shared hosting can be quite variable in speed/reliability, even different servers from the same host.
Sometimes sites will be slow when you first hit them, but speed up as they load into memory... on a site getting regular traffic it'll be kept alive through regular page calls, but can slow down if its not hit too often (as it has to load into memory when someone does hit it).
|