Skip to main content
Aug 4, 2024 9:36 AM UTC

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,

1 reply

pshashipreethamAuthorAnswer
Aug 4, 2024 9:36 AM UTC

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,