Thingworx - MSSQL - COLLATE Change

Ahh found this work around quick, below are the commands need to be used as soon as the MS SQL DB is setup:

ALTER DATABASE thingworxv1 SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE thingworxv1 COLLATE Latin1_General_100_CS_AS_SC;
ALTER DATABASE thingworxv1 SET MULTI_USER;

  Change the "thingworxv1" with your database.

After the executing these commands, the then COLLATE should be good for the schema setup and Thingworx Installation

Thanks,