Which SQL collation setting should be used with StruxureWare WebReports?

Issue

Which SQL collation setting should be used with StruxureWare WebReports?

Product Line

SmartStruxure Solution

Environment

StruxureWare WebReports installation and settings.

Cause

IT departments may wish to know which settings are/should be used if they are managing the Reports server SQL database.

Resolution

During the installation of Report Server,  the collation settings are configured automatically for 'StruxureWareReportsDB' at the database level and not at the SQL Server level. Irrespective of any collation settings at the SQL Server level.