Skip to main content
C
CM_104257921-Visitor
1-Visitor
September 22, 2022
Solved

Linux Installer (demo) not able to connect to MS SQL Server

  • September 22, 2022
  • 1 reply
  • 1298 views

Hi there, 

 

We are hoping to migrate our current TW env out of a Postgres back end and move it into SQL Server. We are running the application on a RHEL7 Linux box. I am finding the PTC installer fails to connect to SQL server.

 

By using SQLCMD in Linux we can connect to SQL Server using the -C switch which turns off certificate validation. Can this switch be used the installer ?

Best answer by PEHOWE

@CM_10425792, @pshashipreetham, 
Because you are moving an application from ThingWorx with Postgresql to ThingWorx with SQL Server, Please review Article - CS303818 - ThingWorx migration from other databases to Microsoft SQL Server

If you have a requirement to move existing data from Postgresql to SQL Server the articles discuss some issues which need to be considered. 
 

HTH

PEHowe

1 reply

P
18-Opal
pshashipreetham18-Opal
18-Opal
September 30, 2022

Hi @CM_10425792 ,

Can you share the logs of when this issue occurred? The logs are found in ThingworxStorage Folder---> Logs ---> Application Logs; sharing the Application log or posting the Error that is happening will help.

Thanks,

P
PEHOWE17-PeridotAnswer
17-Peridot
October 3, 2022

@CM_10425792, @pshashipreetham, 
Because you are moving an application from ThingWorx with Postgresql to ThingWorx with SQL Server, Please review Article - CS303818 - ThingWorx migration from other databases to Microsoft SQL Server

If you have a requirement to move existing data from Postgresql to SQL Server the articles discuss some issues which need to be considered. 
 

HTH

PEHowe

Terms & ConditionsCookie settingsAccessibility statement