|
Hi,
I am trying to install the 1.1 version of the code.
I was able to run through the instdsc.exe without a problem, but when i tried to load the page, i get the following error:
I have made all the required changes to point to the server/database that was created, but cannot seem to bypass this.
can you help?
thanks,
Jerry
<span>
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
</span>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: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:
<table width="100%" bgcolor="#ffffcc">
<tbody>
<tr>
<td>
Line 88: NamedTimeStamp timeStamp = null;
Line 89: Database db = DBController.CreateDatabase(host);
Line 90: DbCommand cmd = db.GetStoredProcCommand(TimeStampProc, key);
Line 91: dep = DBController.GetSqlCacheDependency(host, (SqlCommand)cmd);
Line 92: using (IDataReader dataReader = db.ExecuteReader(cmd)) {
</td>
</tr>
</tbody>
</table>
Source File: C:\Inetpub\wwwroot\DotShop1\Common\Object\DbFileBase.cs Line: 90
Stack Trace:
<table width="100%" bgcolor="#ffffcc">
<tbody>
<tr>
<td>
[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +435
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +84
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection() +136
Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command) +36
Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database) +125
Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues) +84
XShan.DotShoppingCart.Common.Object.DbFileBase.GetTimeStamp(String host, Object key, SqlCacheDependency& dep) in C:\Inetpub\wwwroot\DotShop1\Common\Object\DbFileBase.cs:90
XShan.DotShoppingCart.Common.Object.DbFileBase.GetFile(String host, Object key) in C:\Inetpub\wwwroot\DotShop1\Common\Object\DbFileBase.cs:66
Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection() +136
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +663
Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command) +36
Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database) +125
Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues) +84
XShan.DotShoppingCart.Common.Object.Task.IsScheduledToRun(String host, String taskName, Int32 intervalInMiniute, Nullable`1 startAt) in C:\Inetpub\wwwroot\DotShop1\Common\Object\Task.cs:27
XShan.DotShoppingCart.OrderPipeline.TaskProvider.Proccess(String host) in C:\Inetpub\wwwroot\DotShop1\OrderPipeline\OrderPipeline\TaskProvider.cs:48
XShan.DotShoppingCart.OrderPipeline.ProcessorProvider.Run() in C:\Inetpub\wwwroot\DotShop1\OrderPipeline\OrderPipeline\ProcessorProvider.cs:32
XShan.DotShoppingCart.OrderPipeline.RunnableProvider.StartRun() in C:\Inetpub\wwwroot\DotShop1\OrderPipeline\OrderPipeline\RunnableProvider.cs:43
System.Threading.ThreadHelper.ThreadStart_Context(Object state) +58
System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) +128
System.Threading.ThreadHelper.ThreadStart() +63
</td>
</tr>
</tbody>
</table>
|