Installation question

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
15 years ago
This is an error message I have received after loading default.aspx from NopCommerceWeb folder:


Server Error in '/NopCommerceWeb' Application.
--------------------------------------------------------------------------------

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)
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:


Line 37:         Exception ex = Server.GetLastError();
Line 38:         if (ex != null)
Line 39:             LogManager.InsertLog(LogTypeEnum.Unknown, ex.Message, ex.ToString());
Line 40:
Line 41:     }


Source File: c:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\WebSites\NopCommerce\NopCommerceWeb\Global.asax    Line: 39

Stack Trace:


[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.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
   System.Data.SqlClient.SqlConnection.Open() +111
   Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection() +123
   Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) +74
   NopSolutions.NopCommerce.Common.DAL.Managers.LogDBManager.InsertLog(Int32 LogTypeID, Int32 Severity, String Message, String Exception, String IPAddress, Int32 CustomerID, String PageURL, DateTime CreatedOn) in D:\Work\Own\NopCommerce\Solution\NopCommerce\Nop.Common\DAL\Managers\LogDBManager.cs:113
   NopSolutions.NopCommerce.Common.BLL.Managers.LogManager.InsertLog(LogTypeEnum LogType, Int32 Severity, String Message, String Exception, String IPAddress, Int32 CustomerID, String PageURL) in D:\Work\Own\NopCommerce\Solution\NopCommerce\Nop.Common\BLL\Managers\LogManager.cs:111
   NopSolutions.NopCommerce.Common.BLL.Managers.LogManager.InsertLog(LogTypeEnum LogType, String Message, String Exception) in D:\Work\Own\NopCommerce\Solution\NopCommerce\Nop.Common\BLL\Managers\LogManager.cs:91
   ASP.global_asax.Application_Error(Object sender, EventArgs e) in c:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\WebSites\NopCommerce\NopCommerceWeb\Global.asax:39
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.HttpApplication.RaiseOnError() +160


Connection Strings configuration:
<connectionStrings>
    <add name="NopSqlConnection" connectionString="Data Source=(SQLServer_name);Initial Catalog=NopCommerce;Integrated Security=False;User ID=********;Password=********"/>

Please advice, thank you in advance.
15 years ago
Error in you connection string. "Could not open a connection to SQL Server"
15 years ago
I am new to this, could you help please, what part of connection strings I need to change/modify? Thank you.
15 years ago
Look at http://www.connectionstrings.com/ and https://www.nopcommerce.com/Documentation/Installation.aspx
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.