Solution to Web Reports does not load UI after login attempt

Web Reports does not load UI after login attempt

Cause: Database collation may be set to a case sensitive collation: SQL_Latin1_General_CP1_CS_AS

Solution: Change the database collation to be case insensitive: SQL_Latin1_General_CP1_CI_AS

See the following KB article:

1 Like

Thanks @BigFixNinja Can you please mention the version of Web Reports?

1 Like

At the time I documented this, the BigFix server had the following configuration:

BigFix Server Version:
Server OS: Windows Server 2012 R2
SQL Server: 2008 R2 Standard

However, I do not believe the problem is constraint to server/database platform or application version. The problem seems to be with the way the SQL server was configured and during re-installation/upgrading of the server components the re-created Web Reports database was created and inherited SQL_Latin1_General_CP1_CS_AS from how the SQL server instance was configured.