Add support for Azure SQL Server (and Azure AD auth) about beekeeper-studio HOT 5 OPEN

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

from beekeeper-studio.

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

from beekeeper-studio.

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.

from beekeeper-studio.

@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

from beekeeper-studio.

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

from beekeeper-studio.