cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

Connecting to external DB using AD

jensc
17-Peridot

Connecting to external DB using AD

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

3 REPLIES 3
VladimirN
24-Ruby II
(To:jensc)

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
17-Peridot
(To:VladimirN)

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

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

Top Tags