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

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

JDBC Connector Extension to MSSQL

WilsonT
13-Aquamarine

JDBC Connector Extension to MSSQL

Hi,

 

I tried to use JDBC Connector extension in Thingworx to connect to an external MSSQL server (to read data into Thingworx) via Windows Authentication (Integrated Security = SSPI). On the configuration section, I have tried append the connection string with "Integrated Security = SSPI" and leaving the username and password as blank, but it didnt help.

 

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

JDBC Connection string: jdbc:sqlserver://localhost;databaseName=AdventureWorks2012;Integrated Security=SSPI

connectionValidationString: SELECT GETDATE()

 

Anyone can shed some light on how to connect via Windows Authentication in JDBC Connector? 

 

*Have tried using MSSQL Relational Database Connector and still could not get it work.

1 REPLY 1

Hi @WilsonT ,

 

In JDBC Connection string also mention port number. And for Windows Authentication please look at this link.

 

/VR

Top Tags