Requires configuration of thing with Windows authentication

[Muthu_chithira]

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? 

[PaiChung]

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.

[slangley · Accepted solution]

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