Skip to main content
V
vi116-Pearl
16-Pearl
January 20, 2021
Solved

Thingworx 8.5.1 with MSSQL version 2017

  • January 20, 2021
  • 1 reply
  • 1700 views

Hi,

 

I have installed Thingworx version 8.5.1 with MSSQL server 2017 as default persistence provider.

I have one doubt on thingworx database creation on SQL.

 

Do we need to add the name "twschema" under thingworx database?. I have not added twschema name but schema tables are created when I run the below schema command. Refer the attached screenshot for schema thingworx tables after running the schema script. I have created manually database name "thingworx".

 

thingworxMssqlSchemaSetup.bat -h <server> -i <server-instance> -p <port> -l <login-name> -d <thingworx-database-name> -o all

 

Regards,

Latha

 

Best answer by c_lowy

Yes, so right now the schema containing your ThingWorx tables is called "dbo" which is the default schema in SQL Server for a newly created database (The dbo Schema).
When you run the thingworxMssqlDBSetup.bat script you can choose to use a different schema name using the -s option as per MSSQL Database Setup for ThingWorx: Windows but this is not a requirement. If you do not set any specific value, schema "dbo" will be used.

 

I hope this helps.

1 reply

C
c_lowy16-Pearl
16-Pearl
January 20, 2021

Hi @vi1,

 

No schema needs to be created manually when setting up SQL Server for ThingWorx. 

  • If you are using the ThingWorx Foundation Installer, the required steps before running the Installer are documented at the following link in the "Prerequisites for Windows with Microsoft SQL Server" paragraph : ThingWorx Foundation Installer
    • Only the twadmin user and the thingworx database are created manually
  • If you are performing the installation manually, the required steps are documented here : MSSQL Database Setup for ThingWorx: Windows
    • Only the twadmin user is created manually
V
vi116-PearlAuthor
16-Pearl
January 20, 2021

Hi,

 

Thank you for response. I have not created schemas manually. I have performed scripts which they have mentioned on install.

My doubt is do we need to add the schema name(<schema-name>) under database?. Currently all schemas are created under Table which I have shared screenshot in previous.

 

thingworxMssqlDBSetup.bat -h <server> -i <server-instance> -p <port> -a <database-admin-user-name> -l <login-name> -d <thingworx-database-name> -u <thingworx-user-name> -s <schema-name>

 

Regards,

Latha

C
c_lowy16-PearlAnswer
16-Pearl
January 21, 2021

Yes, so right now the schema containing your ThingWorx tables is called "dbo" which is the default schema in SQL Server for a newly created database (The dbo Schema).
When you run the thingworxMssqlDBSetup.bat script you can choose to use a different schema name using the -s option as per MSSQL Database Setup for ThingWorx: Windows but this is not a requirement. If you do not set any specific value, schema "dbo" will be used.

 

I hope this helps.

Terms & ConditionsCookie settingsAccessibility statement