Skip to main content
S
Sheetal_sable1-Visitor
1-Visitor
January 29, 2019
Question

post

  • January 29, 2019
  • 1 reply
  • 1251 views

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.

 

1 reply

R
rosharma16-Pearl
16-Pearl
January 29, 2019

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;

S
slangleyCommunity Manager
Support
March 14, 2019

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

Terms & ConditionsAccessibility statement