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

Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X

post

Sheetal_sable
12-Amethyst

post

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.

 

2 REPLIES 2

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
23-Emerald II
(To:rosharma)

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

Top Tags