Skip to main content
J
jensc17-Peridot
17-Peridot
March 3, 2023
Solved

Connecting to external DB using AD

  • March 3, 2023
  • 2 replies
  • 1137 views

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

 

 

Best answer by Constantine

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

2 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
March 6, 2023

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 

J
jensc17-PeridotAuthor
17-Peridot
March 6, 2023

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

C
Constantine18-OpalAnswer
18-Opal
March 6, 2023

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

    Terms & ConditionsAccessibility statement