Skip to main content
M
Muthu_chithira1-Visitor
1-Visitor
August 2, 2021
Solved

Requires configuration of thing with Windows authentication

  • August 2, 2021
  • 2 replies
  • 3544 views

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? 

Best answer by slangley

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

P
PaiChung22-Sapphire I
22-Sapphire I
August 3, 2021

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.

S
slangleyCommunity ManagerAnswer
Support
August 4, 2021

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

Terms & ConditionsAccessibility statement