Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
esauaguilar-kr opened this issue Feb 10, 2022 · 5 comments
Assignees

Comments

@esauaguilar-kr
Copy link

esauaguilar-kr commented Feb 10, 2022

  • MSSQL Extension Version: 1.12.0
  • VSCode Version: 1.64.1
  • OS Version: 11.6.2

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:

  • SQL Login
  • Integrated
  • Azure Active Directory - Universal w/ MFA Support <- select this

3

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?

@esauaguilar-kr esauaguilar-kr changed the title AAD Sign in not works on mssql but works on azure tools plugin (with proxy)) AAD Sign in not works on mssql but works on azure tools plugin (with proxy) Feb 10, 2022
@meiswjn
Copy link

meiswjn commented Jul 30, 2024

Hello,
We are facing the same issue.

Any updates?

Thanks!

@kburtram kburtram added this to the October 2024 Release milestone Aug 16, 2024
@meiswjn
Copy link

meiswjn commented Aug 21, 2024

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
Copy link
Member

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

@cssuh
Copy link
Member

cssuh commented Aug 22, 2024

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

@meiswjn
Copy link

meiswjn commented Aug 22, 2024

Hey,

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

Thanks
Jan

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

6 participants