Add support for Azure SQL Server (and Azure AD auth)

[ransagy]

I'd really like to give this app a good run in my day to day workload.
Most of the time, I'm working on SQL Server instances in our Azure subscription with AD/MFA authentication to use my Azure account to log in.

Please consider adding support for this connection scenario.
Thanks!

[rathboma]

👍 Thanks for adding an issue. It is on our radar for sure, in fact we can use this issue to track it. Not sure when we'll get to it, but it's an important use case we want to support.

[rathboma]

Looks like this will require moving our mssql implementation to tediusjs instead http://tediousjs.github.io/tedious/getting-started.html

[ransagy]

Quite possibly; I believe that is what is used for a vscode mssql extension i was using as well, So there's basis for that direction.

[rathboma]

@ransagy I think this was fixed a while ago right? You should be able to use AD credentials to log in now. Please close if so

[ransagy]

@rathboma I grabbed the latest released portable and tried again; Since the AAD username is an email, It thinks im trying to connect to the host part of the email as a domain and fails. So i don't think it works right now, Unless im missing some specific way to indicate its Azure SQL.
Also, By the fact i have to enter a password, It doesn't support MFA mode yet, Which my organization now uses (MS Authenticator app approval, etc).

However, I CAN connect using the serveradmin sql account that was created when the Azure SQL instance was made; But i don't think that's the case either of us were thinking about.