Does Tiny TDS support using Azure Active Directory for authentication?

[williamthom-as]

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]

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]

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]

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]

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

[metaskills]

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

[metaskills]

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

[ChrisGoodnight]

Is there any timeline for supporting active directory authentication?

[metaskills]

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]

Anybody has any update on this issue?

[Jonny-B]

@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.