search

microsoft / vscode-mssql

Visual Studio Code SQL Server extension.
Other
1.53k stars 455 forks source link

AAD Sign in not works on mssql but works on azure tools plugin (with proxy) #17234

Open esauaguilar-kr opened 2 years ago

esauaguilar-kr commented 2 years ago

Note: I use proxy... The sign in not works with the mssql plugin but works with azure tools

Steps to Reproduce:

1- Click Add Connection 2- Enter the server (AZURE_SERVER_NAME.database.windows.net)

1

3- Press Enter to select the default table

2

Options listed:

4- click on Add account, and press enter to optional step (set local profile name)

4 5

5- Opens Sign In page on a Web browser and you Sign in 6- Get stuck and still loading, and never finishes to add the account

6

Notes: The Sign-in with Azure tools plugin works, but mssql is better for the things which I need to do.

Azure tools plugin

1- in Azure tools plugin options y select sign in to azure

az1

2- Web browser opens, and select the account to sign in

Screen Shot 2022-02-10 at 1 34 37

3- It Works

Screen Shot 2022-02-10 at 1 35 18

Then my question is, why the sing-in works in the azure tools plugin but not in mssql?

meiswjn commented 1 month ago

Hello, We are facing the same issue.

Any updates?

Thanks!

meiswjn commented 3 weeks ago

Hello, @kburtram I saw that you added a milestone to this issue. Thanks!

Could you provide an update on this issue / acknowledge it somehow?

Thanks, Jan

kburtram commented 3 weeks ago

@cssuh I see you looked at similar issues for ADS, such as https://github.com/microsoft/azuredatastudio/issues/17356. Do you have any suggestions of how to move forward investigating this issue?

cssuh commented 3 weeks ago

@meiswjn can you please share how you are setting your proxy settings?

meiswjn commented 3 weeks ago

Hey,

Just via environment variables, but configuring it in VS Code directly also didn't change anything.

Thanks Jan