Hello all,
I'm not able to upgrade from SolidCP 1.4.3 to 1.4.4 Enterprise Server.
I get an error, see the log below.
Any pointers on how to resolve this?
Thanks,
-Sup.
[3/11/2021 11:27:29 PM] SolidCP.Installer 1.4.3.0 Started by WIN-PRODSRVR1Administrator
[3/11/2021 11:27:29 PM] INFO: WindowsServer2008 detected
[3/11/2021 11:27:29 PM] INFO: IIS 10.0 detected
[3/11/2021 11:27:29 PM] START: Loading application configuration
[3/11/2021 11:27:29 PM] END: Application configuration loaded
[3/11/2021 11:27:29 PM] START: Loading installed components
[3/11/2021 11:27:29 PM] END: 3 installed component(s) loaded
[3/11/2021 11:27:32 PM] START: Checking for component update
[3/11/2021 11:27:32 PM] INFO: Checking Enterprise Server 1.4.3
[3/11/2021 11:27:33 PM] END: Component update checked
[3/11/2021 11:27:33 PM] INFO: Version 1.4.4 is available for download
[3/11/2021 11:27:34 PM] START: Updating component
[3/11/2021 11:27:34 PM] INFO: Updating Enterprise Server
[3/11/2021 11:27:34 PM] INFO: Tmp directory created
[3/11/2021 11:27:34 PM] START: Downloading file
[3/11/2021 11:27:34 PM] INFO: Downloading file "~/Files/1.4.4/SolidCP-EnterpriseServer-Update.zip" to "C:Program Files (x86)SolidCP InstallerTmpSolidCP-EnterpriseServer-Update.zip"
[3/11/2021 11:27:37 PM] END: Downloaded 1916719 bytes
[3/11/2021 11:27:37 PM] START: Unzipping file
[3/11/2021 11:27:37 PM] INFO: Unzipping file "C:Program Files (x86)SolidCP InstallerDataSolidCP-EnterpriseServer-Update.zip" to the folder "C:Program Files (x86)SolidCP InstallerTmp"
[3/11/2021 11:27:37 PM] END: Unzipped file
[3/11/2021 11:27:37 PM] START: Running installer SolidCP.Setup.EnterpriseServer144.Update from setupsetup.dll
[3/11/2021 11:27:38 PM] INFO: Setup wizard loaded.
[3/11/2021 11:27:38 PM] INFO: IntroductionPage loaded.
[3/11/2021 11:27:40 PM] INFO: LicenseAgreementPage loaded.
[3/11/2021 11:27:48 PM] INFO: ExpressInstallPage loaded.
[3/11/2021 11:27:48 PM] START: Stopping IIS Application Pool
[3/11/2021 11:27:48 PM] INFO: Stopping "SolidCP Enterprise Server Pool"
[3/11/2021 11:27:48 PM] END: Stopped IIS Application Pool
[3/11/2021 11:27:48 PM] START: Creating backup directory
[3/11/2021 11:27:48 PM] END: Created backup directory
[3/11/2021 11:27:48 PM] START: Backing up database "SolidCP"
[3/11/2021 11:27:48 PM] ERROR: Backup 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 SolidCP.Setup.SqlUtils.ExecuteNonQuery(String connectionString, String commandText)
at SolidCP.Setup.SqlUtils.BackupDatabase(String connectionString, String databaseName, String& bakFile, String& position)
at SolidCP.Setup.ExpressInstallPage.BackupDatabase(String connectionString, String database)
ClientConnectionId:703a367a-4cf6-4a8a-a8b8-f57fd98d3d1b
Error Number:233,State:0,Class:20
[3/11/2021 11:27:48 PM] ERROR: Backup 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 SolidCP.Setup.SqlUtils.ExecuteNonQuery(String connectionString, String commandText)
at SolidCP.Setup.SqlUtils.BackupDatabase(String connectionString, String databaseName, String& bakFile, String& position)
at SolidCP.Setup.ExpressInstallPage.BackupDatabase(String connectionString, String database)
at SolidCP.Setup.ExpressInstallPage.Backup()
ClientConnectionId:703a367a-4cf6-4a8a-a8b8-f57fd98d3d1b
Error Number:233,State:0,Class:20
[3/11/2021 11:27:50 PM] INFO: RollBackPage loaded.
[3/11/2021 11:27:50 PM] START: Rolling back
[3/11/2021 11:27:51 PM] INFO: Setup wizard was canceled by user
[3/11/2021 11:27:51 PM] INFO: Setup wizard was canceled by user
[3/11/2021 11:27:51 PM] INFO: Setup wizard closed.
[3/11/2021 11:27:51 PM] INFO: Setup wizard was canceled by user
Hello,
The easiest way to update is via the powershell script, however via the Installer should also work.
A few requirements for it to work:
- stop SolidCP Scheduler service before you start updating Enterprise server.
- The Installer .config file has to have the correct information, this includes database. If it's set to use windows auth make sure the current logged in user has sysadmin permissions to the SQL server.
Regards,
Marco
Great !
somehow the 'sa' user in the database had a different password.
I've logged in with Windows Authentication to the SQL Server and reset the 'sa' password to the same password as in the SolidCP.Installer.exe.config file, stopped the SolidCP Scheduler service and finally I was successful at updating the SolidCP Enterprise Server.
Thanks!
-Sup
