Symantec Data Center Security (DCS) management server installation fails with SQL Collate setting other than default

Products

• Data Center Security Server
• Data Center Security Server Advanced

Issue/Introduction

The SQL Instance is installed with a Collate set to something other than SQL_Latin1_General_CP1_CI_AS causing the installer to fail generating a password for SCSPDBA and the installation fails. In the SISManagementInstallWrapper.log there are the below messages at the end:
Unable to Generate the Password.. 
Unable to Generate the Internal Passwords for Database Or SSL.
Entering FailedInstall().. 
The Installation has failed. Click Finish to exit the wizard.
Leaving FailedInstall().. 

Cause

The SQL Instance Collation setting differs from SCSPDB and DCSC_UMC database collation

This issue can occur when DCS databases are restored to the new SQL instance that had a different collation set during the installation. 

Resolution

To install the DCS Manager successfully:

1. Remove the SQL Instance that was created for this install.
2. Create the SQL Instance that is matching SCSPDB and DCSC_UMC database collation
3. Install the DCS Manager.