cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

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

CM_10425792
1-Newbie

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 ?

2 REPLIES 2

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,

Shashi Preetham

@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

Top Tags