Issue
Which SQL collation setting should be used with StruxureWare WebReports?
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.