After enabling private end point connection on Azure SQL service,Thingworx server is not running

[vi1]

Hello,

After enabling private end point connection on Azure SQL service, Thingworx server is not running. Is there any other configuration do we need to do on Thingworx side. I have updated private end point link for database in Platform settings file.

Below is configuration in Platform-Settings.json file for Azure SQL .

"PersistenceProviderPackageConfigs": {
"AzuresqlPersistenceProviderPackage": {
"ConnectionInformation": {
    "driverClass": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"jdbcUrl": "jdbc:sqlserver://xxxxx.privatelink.database.windows.net:1433;databaseName=thingworx;applicationName=Thingworx;encrypt=true;trustServerCertificate=true",
"password": "x",xxxxxx
"username": "twadmin"
},

.....................................

........................................

Thanks&Regards,

Latha

[odukiya]

Hello @vi1 

I am not sure about your Thingworx version but you can refer following guide which can help you with the configuration for azure sql

https://support.ptc.com/help/thingworx/platform/r9.7/en/index.html#page/ThingWorx/Help/Installation/Installation/install_java_and_apache_tomcat__ubuntu_.html

Please feel free to revert in case it doesn't help or you have any further queries.

Thanks

[TonyZhang]

Hi @vi1,

What error message is logged in the ApplicationLog?

Additionally, could you confirm if the jdbcUrl is correct and accessible from the ThingWorx server network?