search cancel

Failed to login to Endpoint protection manager installed with SQL Express database

book

Article ID: 253016

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

Failed to login to Endpoint protection manager (SEPM)

In the scm-server-0.log we could see:

2022-10-16 00:27:27.662 THREAD 1 SEVERE: 
java.sql.SQLException: Cannot create PoolableConnectionFactory (Cannot open database "sem5" requested by the login. The login failed. ClientConnectionId:1afb43a3-d14a-4b9a-90f6-18cd8d7e4d50)

Management server configuration ends with following error at 99%:

In ConfigurationWizard-0.log:

PRODUCTTYPEREG_SZSERVERNT, targetLineKeyWord(trimmed): REG_SZLANMANNT
2022-09-21 15:41:47.330 THREAD 30 WARNING: SQLExpressDbHelper>>checkIfDomainController, result: false


2022-09-21 15:41:53.627 THREAD 30 WARNING: DbUtil>>executePowshellCommand standard output: 
Error Output: 
File E:\Program Files (x86)\Symantec\Symantec Endpoint Protection 
Manager\Temp\1A945157C0A84A3157138385C00DBA83\ConfigSQLExpressInstanceCertificate.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

On executing the below command in Powershell (elevated privileges) would give the same error as above:

C:\Windows\system32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy Bypass -File "E:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Temp\1A945157C0A84A3157138385C00DBA83\ConfigSQLExpressInstanceCertificate.ps1"

Environment

Release : 14.3 RU1 or later

Cause

Powershell script execution is not allowed on the system.

Resolution

Allow the powershell script execution and re-run the management server configuration wizard.

Attachments