search

rails-sqlserver / tiny_tds

TinyTDS - Simple and fast FreeTDS bindings for Ruby using DB-Library.
Other
607 stars 189 forks source link

Does Tiny TDS support using Azure Active Directory for authentication? #221

Open williamthom-as opened 8 years ago

williamthom-as commented 8 years ago

Just wondering if you support or plan to support Azure Active Directory authentication in the future (https://azure.microsoft.com/en-us/documentation/articles/sql-database-aad-authentication/)?

metaskills commented 8 years ago

We can only support it if FreeTDS supports it. Can you do some investigation work to that end? If not, I will investigate later when putting together some FreeTDS 0.92 road map stuff.

metaskills commented 8 years ago

I just found that Azure Active Directory authentication is in preview, but the question of if FreeTDS supports this still needs some investigation. I did a quick search and found this link but have not read thru it. Could someone please do some more investigation on this cc @saurabh500

http://lists.ibiblio.org/pipermail/freetds/2012q3/027978.html

saurabh500 commented 8 years ago

Adding a note for future reference. Azure Active Directory auth support utilizes the capabilities of TDS protocol v 7.4 In order to support the AAD auth support, we will need TDS 7.4 support in FreeTDS with AAD auth support

metaskills commented 8 years ago

Tagged and closing this issue till TDS v7.4 is supported.

metaskills commented 8 years ago

Reopening this issue. We are already passing 0.99 tests and I just saw this. https://github.com/FreeTDS/freetds/commit/d4705ca81d74feb1fce33177b3e57881b41b78ae

metaskills commented 8 years ago

Making a mental note... use this in the adapter when doing the sandbox argument to db console.

ChrisGoodnight commented 7 years ago

Is there any timeline for supporting active directory authentication?

metaskills commented 7 years ago

Is there any timeline for supporting active directory authentication?

That needs to first be answered at the FreeTDS DBLIB interface first. I'm busy with other things and have not sorted that out yet. Can you investigate?

hiramegl commented 6 years ago

Anybody has any update on this issue?

Jonny-B commented 1 year ago

@metaskills , Is there an update on this? I've looked over at FreeTDS and I'm still unsure if they support AD authentication yet or not.