Thing is not running - SQL JDBC


#1

Hello,

I try to connect a Microsoft SQL Database to ThingWorx … I installed the JDBC MSSQL Connector Extension from the Marketplace and imported it … Then I created a Thing “DB1” with the Base Thing Template MSSqlServer… In the Configuration page I tried to configured…

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

JDBC Connection String:
jdbc:sqlserver://127.0.0.1\SQLEXPRESS;databaseName=thingworx

connectionValidationString:
SELECT GETDATE()

Database User Name:
sa

Database Password:

after saving I get the Message Thing[DB1] is not running…

can anybody help me?

best regards!
D.


#2

Hello,
This forum is exclusively for PTCU courses content. I’d suggest for you to direct this question in the IoT section of the PTC Community.
Thanks,
Carla