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.
- 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