Skip to main content
Sep 22, 2022 9:52 AM UTC
Solved

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

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 ?

PEHOWEAnswer
Oct 3, 2022 7:33 PM UTC

@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

2 replies

Sep 30, 2022 4:31 PM UTC

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,

PEHOWEAnswer
Oct 3, 2022 7:33 PM UTC

@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