NopCommerce 1.9 The network path was not found Issue after migration to new server

2 weeks ago
Dear Sirs,

I need help to solve the following issue Which we encounter on the : Jordancomputers.com

Server Error in '/' Application.
The network path was not found
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.ComponentModel.Win32Exception: The network path was not found

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:


[Win32Exception (0x80004005): The network path was not found]

[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.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) +357
   System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) +79
   System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +201
   System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +156
   System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +22
   System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +92
   System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +219
   System.Data.SqlClient.SqlConnection.Open() +101
   System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +41

[EntityException: The underlying provider failed on Open.]
   System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +220
   System.Data.EntityClient.EntityConnection.Open() +105
   System.Data.Objects.ObjectContext.EnsureConnection() +77
   System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +42
   System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +37
   System.Linq.Enumerable.ToDictionary(IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer) +150
   System.Linq.Enumerable.ToDictionary(IEnumerable`1 source, Func`2 keySelector) +93
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetAllSettings() +552
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingByName(String name) +148
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValue(String name) +63
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValueBoolean(String name, Boolean defaultValue) +68
   NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings.SettingManager.GetSettingValueBoolean(String name) +52
   NopSolutions.NopCommerce.BusinessLogic.Directory.LanguageService.get_CacheEnabled() +66
   NopSolutions.NopCommerce.BusinessLogic.Directory.LanguageService.GetAllLanguages(Boolean showHidden) +240
   NopSolutions.NopCommerce.BusinessLogic.NopContext.get_WorkingLanguage() +495
   NopSolutions.NopCommerce.BusinessLogic.Profile.MembershipHttpModule.Application_AuthenticateRequest(Object sender, EventArgs e) +2142
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +144
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +50
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +73

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4330.0

-----------
Additional information :

- NopCommerce Version : 1.9
- Web Hosting : Deluxe Windows Hosting with Plesk
- PHP version: 7.3.27
- ASP.NET Version : 4.8.3761
- Database Manager : myLittleAdmin for SQL Server 3.8


Kindly Note that app Data file is empty .

Thanks
2 weeks ago
This means one of the following:

1. The Database has been removed/renamed
2. The UserId/Password/Catalog name in the connection string are wrong.
3. The connection string has the wrong path to the database.
2 weeks ago
@untiedshoes thanks ,
but i couldn't find setting.txt to check the old database name or change any path
2 weeks ago
Did you copy it over during the migration to a new server?

If not, do you have access to the previous  server, or a backup?
2 weeks ago
@untiedshoes
Unfortunately no , The transfer was done by my host provider and the data has been removed from the old server when i them about the backup files they say that The files that have been uploaded are of the same size for backup .
2 weeks ago
Okay, so a lesson to be learned here... make sure you have your own backup!

Anyway, are you using a custom theme on top of 1.90?

Download 1.90 from here, then you can copy what you need over (and add the required connection string etc to settings.txt).

https://github.com/nopSolutions/nopCommerce/releases/tag/release-1.90