The issue is due to the collation setting of the database. The DSM database supports the SQL_Latin1_General_CP1_CI_AS setting. Applying this setting makes the server treat strings as case-insensitive, accent-sensitive, kanatye-insenstive, and width-insensitive. The SQL sort order for Unicode Data is 52 on the Code Page and 1252 for the non-Unicode Data.
To resolve the issue, use the supported SQL_Latin1_General_CP1_CI_AS server collation:
- Stop the DSM service.
- Go to the SQL server hosting the DSM database.
- Go to the DSM database.
- Click Properties > Options > Collation.
- Change the collation used to "SQL_Latin1_General_CP1_CI_AS".
- Start the DSM service.
For more information, you may refer to this Microsoft KB article: Set or Change the Server Collation.
When the installer fails to modify the DSM database schema, check the database integrity and manually upgrade the database schema:
- Back up the DSM database.
- Manually update the DSM database schema.
- Apply Deep Security Manager 9.5 SP1 Patch 1 Build 9.5.6008 or higher.