SEPM 14.3 RU1 installation with default configuration failed with error "The SQL Server Express database installation failed. Failed to enable database TCP port!" in management server configuration wizard.

Products

• Endpoint Protection

Issue/Introduction

While installing SEPM 14.3 RU1 with default configuration (with SQL Express), installation interrupted in management server configuration wizard while creating the database with an error message "The SQL Server Express database installation failed. Failed to enable database TCP port!".

Environment

Release : 14.3 RU1 with SQL Express and Above

Component : Database

Cause

The ConfigurationWizard-0.log shows below error;

2021-01-22 18:54:17.474 THREAD 149 WARNING: DbUtil>>executePowshellCommand standard output: 

 Error Output: 
File C:\Users\sepm\AppData\Local\Temp\2\B7766CD60A090D8C34AF23CB72EF662A.ps1 cannot be loaded because running scripts 
is disabled on this system. For more information, see about_Execution_Policies at 
http://go.microsoft.com/fwlink/?LinkID=135170.
    + CategoryInfo          : SecurityError: (:) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : UnauthorizedAccess

 

The above error occurs if the execution of the Powershell script is blocked/disable in server.

Resolution

Enable PowerShell script execution by following any of the below methods;

Method 1:

1) Open Run Command/Console (Win + R)

2) Type: gpedit.msc (Group Policy Editor)

3) Browse to Local Computer Policy -> Computer Configuration -> Administrative Templates -> Windows Components -> Windows Powershell.

4) Enable "Turn on Script Execution"

 Method 2:

Open PowerShell with the Admin privilege and run the below command;

set-executionpolicy unrestricted