Error Occurred in the Management Server Upgrade window during a SEPM upgrade to SEP 14
search cancel

Error Occurred in the Management Server Upgrade window during a SEPM upgrade to SEP 14

book

Article ID: 164826

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

During an upgrade of the SEPM to SEP 14, specifically the Server upgrade stage, you get an error "Error Occurred"

In the log <SEPM Install Folder>\tomcat\logs\upgrade-0.log this error appear:

017-03-10 15:26:38.362 THREAD 23 WARNING: DbUtil> addReporterUser>> Add report login!
2017-03-10 15:26:38.480 THREAD 23 WARNING: Upgrade> updateTransactionLogFileSize>> final log size is 16384
2017-03-10 15:26:38.481 THREAD 23 SEVERE: com.microsoft.sqlserver.jdbc.SQLServerException: Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:426)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:372)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1793)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:354)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.sygate.scm.server.db.util.DbUtil.addReporterLogin(DbUtil.java:1246)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.sygate.scm.server.db.util.DbUtil.configReporterUser(DbUtil.java:1167)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:2123)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:123)
2017-03-10 15:26:38.482 THREAD 23 SEVERE:     at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:251)
2017-03-10 15:26:38.483 THREAD 23 SEVERE:     at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:159)
2017-03-10 15:26:38.483 THREAD 23 SEVERE:     at java.lang.Thread.run(Thread.java:745)
2017-03-10 15:26:38.483 THREAD 23 SEVERE: Upgrade.doUpgrade com.microsoft.sqlserver.jdbc.SQLServerException: Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
 

Cause

The password of the account connecting to the SQL server is not complex enough

Resolution

- Change the password for a password with Lower & upper case letters, digits, & non alphanumeric characters for this account with SQL management Studio on the SQL Server
- Launch the "Management Server Configuration Wizard" of SEP by going in Start > All Programs > Symantec Endpoint Protection Manager > Management Server Configuration Wizard
- Type the new password when connecting to the database during the reconfiguration of the Server
- Re-Launch the <SEPM Install Folder>\bin\upgrade.bat to complete the upgrade

Attachments