Add the ability to have MFA authentication - for Azure DBs about sqlquerystress HOT 8 CLOSED

duplicate of #113

from sqlquerystress.

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

from sqlquerystress.

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

from sqlquerystress.

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.

from sqlquerystress.

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

from sqlquerystress.

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

from sqlquerystress.

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

from sqlquerystress.

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

from sqlquerystress.