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

[CM_10425792]

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 ?

[pshashipreetham]

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,

[PEHOWE · Accepted solution]

@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