This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am having an issue with Azure Data Studio and connecting to my linked account. I previously could use data studio with my account but now when connecting it just spins and spins and actually never finds my linked account. I have un-installed and re-installed using the 'User Installer'.
Hi @Anonymous , Thanks for your query. Community SME's on this topic or our team will review your scenario and circle back at the possible earliest time.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi @Anonymous
Welcome to Microsoft Q&A platform and thanks for using Azure services.
As I understand, you are unable to fetch Accounts in ADS.
Could you please follow this documentation with step by step on how to connect to Azure SQL using Data Studio to make sure you are not missing anything.
Please also make sure that client Ip is added in the firewall rule in Azure.
Refer to the solutions helped users in Login issues which might be useful: Unable to login to Azure
7619
Additionally, could you please let us know the Operating system of your machine in use?
Are the Accounts to be used in ADS on premise or Cloud based?
Please let us know if this helped. If not, do share your inputs to help further.
Thank you!
Hi @ShaktiSingh-MSFT ,
Thank you for the articles.
Some additional background:
Thank you
Hi @Anonymous ,
We are sorry about the inconvenience you are facing.
If not already, could you please try to reinstall ADS and check once?
Could you please also log an issue for this on our GitHub for Azure Data Studio?
https://github.com/microsoft/azuredatastudio/issues
Let me know if you are able to log issue and get response from the concerned team.
Thanks!
I was running into the same problem, and it was because I had logged in using my Email Address rather than my User Principal Name (UPN).
Some organizations (mine included) give each user an Email Address that is different from their UPN, and while most SSO login dialogs will allow you to login with either one, apparently some Azure-based SQL endpoints only recognize the UPN as a valid login.
To authenticate with my UPN instead of my Email Address, I clicked the little "person" icon near the bottom of the menu bar on the left side of the Azure Data Studio window, then clicked the "plus" button on the "Azure" bar in the Linked Accounts pane. When the SSO dialog popped up, instead of selecting my usual Email Address, I clicked "Use another account" and entered my UPN and password. Once I did that, everything worked as expected.
Hope this helps!
Hi James D. Bartlett III •,
Many thanks for sharing the detailed solution you adopted with the community.
Appreciate your efforts.
Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 63%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHV%3C/text%3E%3C/svg%3E)
Hi,
I had faced similar issue in the past. When I tried to add account, the link was opening in browser and I wasn't able to login.
it was network related.
Are you getting redirected to the browser when you click on Add Account?
if yes and if you are unable to login , maybe you should try clear cache on Edge browser and try again.
Thanks
Hijesh
Hi @hijesh vl
Unfortunately, it does not even open up the web browser. I did however clear all cache and history and nothing happened.
Murry
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 21%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Related Question, not an answer... I have a similar issue, but I am trying to log in using "Authentication type" "Azure Active Directory - Universal with MFA support", as instructed by my DBA. The error I get says: "Error. Source: Azure (Core) (Extension)", no further error description or identifiers.
This recommendation from a GitHub user forum: #22227 (comment) resolved my issue - Disabling 'HTTP: System Certificates' in Settings.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
Any updates on this? I'm experiencing the same -- just now uninstalled/ reinstalled ADS.
@chrisrdba I found the soltuion when posting on GitHub - https://github.com/microsoft/azuredatastudio/issues/21948 . Which points you to https://github.com/microsoft/azuredatastudio/issues/21422 It had to do something with @builtin being disabled. https://github.com/microsoft/azuredatastudio/issues/21422#:~:text=Dec%2020%2C%202022-,weirdly%20the%20insider%20build%20i%20have%20installed%20doesn%27t%20show%20that%20extension.%20I%20don%27t%20even%20see%20a%20category%20for%20features.,-scratch%20that.%20i
Thats a lot to take in. I think the answer is for @builtIn Azue (Core) to be enabled and mine is globally. If that's not the answer please advise, thanks.
@chrisrdba That is correct, you need to enable @builtin Azure Core.
Thanks, unfortunately that didnt fix it for me.
Disregard my previous comments, I'm in now. I had to uninstall/ reinstall, then add the new connection to Azure SQL DB. I thought adding the connection required a Linked Account and still having an issue there, but was able to add a connection without it via SQL authentication. Previously nothing was working, but I didn't retry a new connection after the reinstall until just now.
Hi
chrisrdba •,
We apologize for the inconvenience you are facing.
In order to address the issue, we recommend you to look into the workaround shared at the above mentioned GitHub link.
Also, would request you to share your feedback in the Azure SQL Feedback Channel where concerned team will look into the requests depending on the priority and up-votes.
Thank you.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.