Symantec Endpoint Protection Manager Upgrade failed 14.3 MP1 to 14.3 RU2 [Embedded Database]

book

Article ID: 222073

calendar_today

Updated On:

Products

Endpoint Security Complete

Issue/Introduction

Errors appear during Management server configuration wizard:

Clicked Continue

ERROR : The SQL Server Express database installation failed. Failed to enable the database TCP Port.

From the install_log.err (\\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\logs\install_log.err)

Aug 19, 2021 1:53:42 AM  STDERR: Port 2638 is available.

Aug 19, 2021 1:55:55 AM  STDERR: MainFrame> prepareDatabase>> Creating database failed. ErrorCode = 386727936. Error message is = Failed to enable database TCP port!

Aug 19, 2021 1:55:55 AM  STDERR: com.sygate.scm.server.util.ServerException: Failed to enable database TCP port!

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.server.db.util2.SQLExpressDbHelper.setInstanceTcpPort(SQLExpressDbHelper.java:670)

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.server.db.util2.SQLExpressDbHelper.installSQLExpressEx(SQLExpressDbHelper.java:368)

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.install.ui.MainFrame.createEmbeddedDB(MainFrame.java:7952)

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.install.ui.MainFrame.prepareDatabase(MainFrame.java:7771)

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.install.ui.MainFrame.configureDB(MainFrame.java:1269)

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.install.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:4902)

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.install.ui.MainFrame$5$1.construct(MainFrame.java:4431)

Aug 19, 2021 1:55:55 AM  STDERR:    at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:151)

Aug 19, 2021 1:55:55 AM  STDERR:    at java.base/java.lang.Thread.run(Thread.java:834)

Aug 19, 2021 1:56:11 AM  STDERR: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <HostName>, port 2638 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

Aug 19, 2021 1:56:11 AM  STDERR:    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)

Aug 19, 2021 1:56:11 AM  STDERR:    at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:285)

Aug 19, 2021 1:56:11 AM  STDERR:    at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2462)

 

From ConfigurationWizard-0.log (\\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\logs\install_log.err) match the time stamp:

Error Output:

2021-08-19 01:55:53.069 THREAD 42 WARNING: SQLExpressDbHelper>>uninstallSQLExpressByCommands, successfully deleted file: D:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\SymcInstanceUninstallCmd

2021-08-19 01:55:53.069 THREAD 42 WARNING: SQLExpressDbHelper>>uninstallSQLExpressByCommands, done! Cost(seconds)2

2021-08-19 01:55:53.069 THREAD 42 SEVERE: installSQLExpressEx -> InterruptedException, Failed to enable database TCP port!

2021-08-19 01:55:57.288 THREAD 42 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://<HostName>:2638;instanceName=SQLEXPRESSSYMC;integratedSecurity=false;encrypt=true;trustServerCertificate=true, user: DBA

2021-08-19 01:56:11.726 THREAD 42 SEVERE: exception retrieving connection

2021-08-19 01:56:11.726 THREAD 42 SEVERE: exception retrieving connection

-----------

Powershell script is run by the SEP installer and it cannot run due to limitations through GPO:

Error we can see in ConfigurationWizard-0.log is as follows:

2021-08-19 01:55:49.866 THREAD 42 WARNING: SQLExpressDbHelper>>executePowshellCommand processing:

args[0]: C:\Windows\system32\WindowsPowerShell\v1.0\powershell.exe

args[1]: -ExecutionPolicy

args[2]: Bypass

args[3]: -File

args[4]: C:\Users\SEPMADMINISTRATOR\AppData\Local\Temp\2\BD05C7C9C0A86B650040D14911A90725.ps1

 

2021-08-19 01:55:50.350 THREAD 42 WARNING: SQLExpressDbHelper>>executePowshellCommand processing result: 1

2021-08-19 01:55:50.350 THREAD 42 WARNING: DbUtil>>executePowshellCommand standard output:

Error Output:

File C:\Users\SEPMADMINISTRATOR\AppData\Local\Temp\2\BD05C7C9C0A86B650040D14911A90725.ps1 cannot be loaded. The file

C:\Users\SEPMADMINISTRATOR\AppData\Local\Temp\2\BD05C7C9C0A86B650040D14911A90725.ps1 is not digitally signed. You cannot run

this script on the current system. For more information about running scripts and setting execution policy, see

about_Execution_Policies at http://go.microsoft.com/fwlink/?LinkID=135170.

    + CategoryInfo          : SecurityError: (:) [], ParentContainsErrorRecordException

    + FullyQualifiedErrorId : UnauthorizedAccess

----------

Cause

Powershell is blocked.

Environment

Release : Symantec Endpoint Protection Manager 14.3 RU2

Component : Upgrade to 14.3 RU2

Resolution

Allowing the Powershell script to run resolves the issue. Windows/AD Administrator need to perform the task.

 

Additional Information

For reference : About_Execution_Policies

Attachments