post

[Sheetal_sable]

Hi,

     I have installed SQL server 2016 and SQL management studio 2017. I am facing an issue while connecting sql to thingworx. The configuration details in thingworx are already filled.

Below are the JDBC settings:

JDBC Driver Class Name : com.microsoft.sqlserver.jdbc.SQLServerDriver

JDBC Connection String :jdbc:sqlserver://localhost;databaseName=thingworx

Below is the error i received when i connect to database.

[rosharma]

you probably missing valid credentials configurations over entity

check jdbc connection URL as well

it should be like :(missing port 1433 in your URL)
jdbc:sqlserver://localhost:1433;databaseName=thingworx;applicationName=Thingworx;

[slangley]

Hi @Sheetal_sable.

If the response provided by @rosharma allowed you to solve your issue, please mark it as the Accepted Solution for the benefit of others with the same issue.

Regards.

--Sharon