Skip to main content
Aug 2, 2021 12:28 PM UTC
Solved

Requires configuration of thing with Windows authentication

Hi All,

Without DB username and DB Password, can configure a thing. Which means in SQL, Through Windows Authentication i can access DB. I Dont have any access or user credentials with SQL Server authenticaton. Is there any way to configure a THING and establish a connection between thing and DB? 

slangleyAnswer
Aug 4, 2021 7:59 PM UTC

Hi @Muthu_chithira.

 

The jdbc driver defines the access allowed and as far as I know, only SQL Server authentication is supported.  For that reason, ThingWorx does not support Windows authentication. 

 

You may want to talk with your DBA about setting up a SQL Server account for the database you need to connect to in order to create the needed connection from ThingWorx.

 

Regards.

 

--Sharon

2 replies

Aug 3, 2021 5:35 PM UTC

I'd go with no, sorry.

Not sure if you have specific security rules that won't allow you to set up a DataBase Thing, but permissions and pre-built queries/views/procedures should be able to cover your scenarios.

slangleyAnswer
Aug 4, 2021 7:59 PM UTC

Hi @Muthu_chithira.

 

The jdbc driver defines the access allowed and as far as I know, only SQL Server authentication is supported.  For that reason, ThingWorx does not support Windows authentication. 

 

You may want to talk with your DBA about setting up a SQL Server account for the database you need to connect to in order to create the needed connection from ThingWorx.

 

Regards.

 

--Sharon