Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
5 answers
User account 'me@myorg.com' not found in MSAL cache?
This used to work, but today I get this error when trying to open our company MS Sql server in azure data studio on mac: User account 'me@myorg.com' not found in MSAL cache, please add linked account or refresh account credentials. How do I work around…
asked 2023-09-25T15:37:27+00:00
![](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(265.6, 1%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
red stone
1
Reputation point
commented 2024-05-09T14:13:36.1366667+00:00
Erin Stellato
481
Reputation points Microsoft Employee
0 answers
Azure Data Studio: adding Entra ID user account fails with "Error: read ECONNRESET"
Hello, we are facing the situation in our organization that some users (on specific laptops) have problems to add their personal Entra ID user accounts (formally Azure Active Directory) in Azure Data Studio. We tried Code Grant authentication as well…
asked 2024-05-06T13:50:02.3133333+00:00
![](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(297.6, 42%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Martin B
21
Reputation points
commented 2024-05-06T18:03:52.8166667+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
0 answers
tại sao khi kết nối với máy chủ SQL 2022 Azure lại không có Restore Database
Khi tôi cài đặt Azure Data Studio kết nối với SQL bản 2022 và muốn restore advanturework 2022 để thực hành thì không có mục Restore dữ liệu khi nhấn chuột phải vào Database mà chỉ có mục Filter và Refesh. Làm thế nào để sửa lỗi này?
asked 2024-05-02T10:05:53.28+00:00
![](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(246.4, 23%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENC%3C/text%3E%3C/svg%3E)
Ngọc Yến Đặng
0
Reputation points
commented 2024-05-02T21:07:25.5733333+00:00
Erland Sommarskog
101.9K
Reputation points MVP
2 answers
How to connect to existing SQL Server in Azure Data Studio 3?
When I attempt to connect to my institution's SQL Server I get this message "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal…
asked 2024-03-26T15:51:01.0133333+00:00
![](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(83.2, 2%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nuako, A
0
Reputation points
answered 2024-04-24T00:51:49.43+00:00
Erin Stellato
481
Reputation points Microsoft Employee
2 answers
Unable to add account in Azure Data Studio
Getting the below error while trying to add account in azure data studio
asked 2024-04-18T14:47:50.75+00:00
![](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(236.8, 42%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tiwari, Aviral (NonEmp)
0
Reputation points
commented 2024-04-23T00:34:35.54+00:00
GeethaThatipatri-MSFT
27,722
Reputation points Microsoft Employee
1 answer
Have Azure Data Studio, auto update to version 1.48.0 no will not connect to SQL Server DBs
I am having an issue with the current version of Azure Data Studios (1.48.0). Will not connect to my SQL Server databases. I have SQL Server Management Studio version 20.0.70.0 It is working fine. My Azure Data Studio version 1.47.0 was working fine. …
asked 2024-04-12T13:38:54.24+00:00
Robbins, Brett K
0
Reputation points
answered 2024-04-16T19:23:24.64+00:00
GeethaThatipatri-MSFT
27,722
Reputation points Microsoft Employee
2 answers
Automatically Load Server on Azure Data Studio on Start Up
I have database on a cloud server. I use Azure Data Studios to make queries. However, every time I open Azure Data Studios, my server is disconnected. I need to click on it to connect. And whenever I run a query, I apparently have to connect it again.…
![](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(176, 52%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZ%3C/text%3E%3C/svg%3E)
![](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(54.400000000000006, 99%, 15%)' 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)
5 answers
connection error when trying to connect to sql database via azure data studio
I created an azure sql database and added my IP address to the firewall rules. In "Getting started" I use the button "Open Azure Data Studio" to connecto the database via Azure Data Studio. In Connection Details the Authentication…
asked 2024-03-13T10:01:28.0866667+00:00
![](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(246.4, 62%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
blubb
0
Reputation points
answered 2024-03-14T15:30:52.1266667+00:00
![](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)
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
students subsription
why im not eligible for microsoft azure student account i also have student mail
asked 2024-03-05T16:43:28.95+00:00
![](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(185.6, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERU%3C/text%3E%3C/svg%3E)
Rasheed usama
0
Reputation points
commented 2024-03-12T19:39:57.5433333+00:00
GeethaThatipatri-MSFT
27,722
Reputation points Microsoft Employee
2 answers
Schema Compare in Azure Data Studio delay when Include or Exclude objects
While choosing objects in Schema Compare in Azure Data Studio with the help of the Include checkbox we experiencing a delay, so when you press Apply too early the selection is not effective yet and all objects with differences are updated. You get a…
asked 2024-03-12T10:27:37.44+00:00
![](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(284.8, 12%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tigor Sinuraja
5
Reputation points
answered 2024-03-12T11:05:14.8266667+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Data Migration from One Environment to Other
I have a graph database on cosmos dB, and I need to migrate the data to a different environment. Need suggestions on how to move this. I did some research and figured out an Azure Data Migration tool but I am not sure what would be the partition key for…
asked 2024-03-07T16:59:36.0966667+00:00
![](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(25.6, 57.99999999999999%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Surya
0
Reputation points
commented 2024-03-11T18:13:14.82+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
Azure Data Studio Publish error
Hello, I out this error "Deploy dacpac: Object reference not set to an instance of an object." while trying to deploy into my database. Is there any particular troubleshooting tips I can go after to fix this. I tried deleting by bin folder…
asked 2024-02-28T22:49:32.59+00:00
![](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(19.2, 35%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA7%3C/text%3E%3C/svg%3E)
aK-7515
20
Reputation points
answered 2024-02-29T04:16:28.53+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
2 answers
I am unable to connect to Azure Data Studio due to "Connection Timeout Expired." error.
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while…
asked 2024-02-16T08:22:55.45+00:00
![](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(108.80000000000001, 8%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBR%3C/text%3E%3C/svg%3E)
Bhattacharjee, Rupajiet
0
Reputation points
answered 2024-02-19T04:08:01.93+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
When ı started Azure Data Studio I can get this error : Extension host terminated unexpectedly 3 times within the last 5 minutes.
You can access the document containing the steps I took for the error Azure Data Studio Extension Host.pdf
asked 2024-02-13T08:30:51.5166667+00:00
![](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(169.60000000000002, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOE%3C/text%3E%3C/svg%3E)
Onur ERDOĞAN
25
Reputation points
answered 2024-02-15T05:58:28.32+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
how can I find data sync in SQL database menu
I can find the data sync menu which is show in sql database document. How can I find the data sync? https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql#add-on-prem
asked 2024-01-29T09:14:07.3033333+00:00
![](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(41.6, 93%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yonghu shi
0
Reputation points
edited the question 2024-01-31T06:40:28.1166667+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
Filter Results in ADS does not work
Something weird with my ADS. I can't Filter or Sort Results after I complete query. Actually, I could filter only 100000 records. If my Results is more that 100000 it simply does not work. My simple query selects 150 K records of integer type. If I click…
asked 2024-01-27T13:33:47.25+00:00
![](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(294.40000000000003, 94%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Susja
711
Reputation points
answered 2024-01-30T06:00:36.23+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
AZURE DATA STUDIO NOT SHOWING ALL ROWS AFFECTED IN A QUERY
I am using Azure Data Studio notebook to query an Azure database. On some of the queries, it will say that it runs 96 rows for example, but only shows 8. I run the same query in SSMS and it shows all 96 rows. What's going on here? The query size is not…
asked 2024-01-26T21:39:18.1833333+00:00
![](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(310.4, 75%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Younkin, Kyle
0
Reputation points
edited the question 2024-01-29T05:01:01.8466667+00:00
![](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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
10,240
Reputation points Microsoft Vendor
0 answers
Unable to filter Results
Hello, I hit the issue when I can't filter out Results. In my case I have around 2,5 Millions records, When I click on arrow to filter the record it failed and throws the error I already increased Settings - Query Editor - Results ... Threshold till…
1 answer
How to improve performance with Azure Data Studios? SSMS on same computer/network is fine, but connection to Azure Data Studio is not usable.
We have been working to implement improvements to our workflow by migrating developers to use Azure Data Studios so we can utilize source control more seamlessly within our process. However, when we work to connect/complete actions within Azure Data…
asked 2024-01-15T23:07:21.76+00:00
![](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(256, 77%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
Kyle Kew
0
Reputation points
edited an answer 2024-01-19T04:19:46.0733333+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Creating a database project versus Synapse SQL pool from scratch
Hi, I'd like to find a good and complete reference tutorial in order to create from scratch a database project versus a Synapse dedicated SQL pool and to check a my project in progress. I've Visual Studio 2022 and SSDT extension (I can use this tool or…
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,422 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,647 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
![](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(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)