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.
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;
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.