Hello,

If you don't have your enterprise web.config it means that all passwords used in SolidCP will not work.

You will be best to reinstall SolidCP and then copy the old database inplace of the new one. You could then use the installer to reset the serveradmin password and continue on there to reset all other passwords.

Regards,

Trevor

this " reinstall SolidCP and then copy the old database inplace of the new one " mean restore DB or other solution?

hi      after restor old DB on new and try to reset serveradmin password in installer->enterprise->setting this error is view:

[3/12/2020 3:59:38 PM] END: Unzipped file
[3/12/2020 3:59:38 PM] START: Running installer SolidCP.Setup.EnterpriseServer145.Setup from C:Program Files (x86)SolidCP InstallerTmpsetupsetup.dll
[3/12/2020 3:59:39 PM] INFO: Setup wizard loaded.
[3/12/2020 3:59:39 PM] INFO: WebPage loaded.
[3/12/2020 3:59:39 PM] START: Loading IPs
[3/12/2020 3:59:40 PM] END: Loaded IPs
[3/12/2020 3:59:49 PM] INFO: ServerAdminPasswordPage loaded.
[3/12/2020 4:00:02 PM] INFO: ExpressInstallPage loaded.
[3/12/2020 4:00:02 PM] START: Updating serveradmin password
[3/12/2020 4:00:02 PM] ERROR: Update error
System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) ---> System.ComponentModel.Win32Exception (0x80004005): No process is on the other end of the pipe

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at SolidCP.Setup.SqlUtils.ExecuteQuery(String connectionString, String commandText)
at SolidCP.Setup.ExpressInstallPage.UpdateServerAdminPassword()
ClientConnectionId:b10be67f-6e09-48dc-b7d5-d5ee36ee648f
Error Number:233,State:0,Class:20

Hello,

You should ensure that the SQL user has access to the database with the correct schema. When you restore the database sometimes this has to be set again.

Regards,

Trevor