Add the ability to have MFA authentication - for Azure DBs

[BP-vismaNmbrs]

Currently we only have the "Integrated Authentication" and "SQL Server Authentication" but sometimes there is also the use of MFA, specially to prevent a SQL user to be added.
Something on the line of this .

[ErikEJ]

@BP-vismaNmbrs Have you tried the latest build? https://github.com/ErikEJ/SqlQueryStress/releases/download/102/SqlQueryStressNet6.zip

[ErikEJ]

duplicate of #113

[BP-vismaNmbrs]

Oh... what a rookie mistake. I'm sorry for this and thanks for pointing it out @ErikEJ

[ErikEJ]

@BP-vismaNmbrs No problem, let me know if it works for you

[BP-vismaNmbrs]

Hi there,
So I was testing this version and still can't connect to an Azure DB with MFA.
I might be doing it wrong:

1. I am connected with MFA to the database using SMS
2. opened the app and clicked on the database popup
3. filled in server name
4. selected MFA authentication
5. clicked on the database drop-down
6. a browser page opened asking for my Azure credentials - did the login, validated the access
7. browser window redirects to localhost:(random port) fails
8. the application freezes completely and pops up an error message after timing out
   "The user took too long to respond to the authentication request"

For me this means the authentication request got lost somewhere on the return redirect

[ErikEJ]

Works on my PC - I am using Edge as my default browser

[ErikEJ]

1: Enter name of server: abc.database.windows.net
2: Pick MFA from combo
3: enter login
4: Select database combobox and login process occurs

[BP-vismaNmbrs]

Today was the day I found some time to go over this on my machine.

Following up on this, I managed to get it working but with some workaround - maybe due to my network security policies.

I'm leaving the steps here in case it helps someone else:

1. Downloaded the latest version that @ErikEJ posted in this thread
2. Unzipped and run the .exe
3. Filled in the database popup with the correct values and as soon as I filled in my login name the azure login appeared on the browser
4. I filler in my credentials and it redirected to "localhost....(long code and stuff)" and the application got stuck on wait
5. The workaround is to use Azure CLI and login to azure with the az login --use-device-code command
6. Follow the instructions and the SQL QueryStress application get's the response back and works fine

I found the solution thanks to this link, after several interactions:
az login broken on chrome with ERR_SSL_PROTOCOL_ERROR

PS: I forgot to mention I'm using a windows machine, chrome and a VPN.