Connecting to external DB using AD

[jensc]

Hello,

We have always created SQL logins for our users to be able to connect to external databases from our  Thingworx platforms.

But it was recently brought up that for some external databases we have, it is more common to use AD as a way to give access  when accessing it through SSMS.

So I was wondering if there was any documentation or experience in the community on how we could use AD to connect to these external databases.

Any pointers would be very appreciated.

Thanks,

Jens

[VladimirN]

Article - "How to connect ThingWorx with an external database without extensions": https://www.ptc.com/en/support/article/CS318728 

"How to connect external Database with Thingworx": https://www.youtube.com/watch?v=8izaSLWLEaI 

[jensc]

Hello,

Thank you for your pointers, however, they just explain how to connect using SQL accounts.

I would like to (if possible) connect using the "integratedSecurity=true" in the connection string.

I have done some tests but haven't been able to get it to work.

How do we pass the username and password? Is it added to the connection string like:

jdbc:sqlserver://localhost:1433;databaseName=AdventureWorks;username=abc;password=123

From what I can tell, it should work to use the integratedSecurity parameter:

https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16

Thanks,

Jens

[Constantine · Accepted solution]

Hello Jens,

I remember I've seen some Support cases related to integratedSecurity parameter. Check out CS274473, for example. It suggests that with this parameter set to true you can omit credentials altogether.

/ Constantine