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

Products

• Data Center Security Server

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 Installce Collate setting is set to something other than SQL_Latin1_General_CP1_CI_AS.

Resolution

To install the DCS Manager successfully:

1. Remove the SQL Instance that was created for this install.
2. Create the SQL Instance again and this time leave the Collate setting as Default.
3. Install the DCS Manager.