Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
103 questions
0 answers
Azure Data Studio Cannot get to the programmability group for Azure SQL Serverless
I'm having trouble accessing the programmability group for Azure SQL Serverless in Azure Data Studio. For example, when I create a stored procedure in the Serverless pool, I cannot see it or access it. Additionally, the sp_helptext procedure is not…
asked 2024-06-02T23:01:19.78+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(278.4, 66%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jorge L Dominguez
46
Reputation points
asked 2024-06-02T23:01:19.78+00:00
Jorge L Dominguez
46
Reputation points
1 answer
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
edited the question 2024-05-30T04:07:12.6266667+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(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT
28,756
Reputation points Microsoft Employee
1 answer
cannot access to my azure sql server via azure data studio
I have a remote connection between azure data studio and azure sql server and it works pretty well before. I cannot access to my azure sql server via azure data studio and power bi since yesterday. I check my ip address and my instant name, everything…
asked 2024-05-29T09:03:15.3433333+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(134.4, 75%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZM%3C/text%3E%3C/svg%3E)
Zhuoqiong Mo
20
Reputation points
answered 2024-05-30T03:44:33.4033333+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
14,081
Reputation points Microsoft Employee
2 answers
Should I update statistics immediately after migrating to Azure SQL Server Managed Instance
I am migrating my 4TB database of Microsoft SQL Server 2016 2 node AG cluster from on-premises to Azure SQL Managed Instance. I am using Azure Data Studio to migrate through full backup and continuously applying log backup. This backup will be ongoing…
asked 2024-05-27T11:15:24.8966667+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(272, 35%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Aakash CK(P)
0
Reputation points
answered 2024-05-27T21:41:18.89+00:00
Erland Sommarskog
102.6K
Reputation points
1 answer
During database migration in online mode using Azure data studio status is restoring only on sqlmi.
During database migration in online mode using Azure data studio status is restoring only on sqlmi. it's not changing since long time. Though Azure data studio shows restored and Data migration service shows ready for cutover. Data is around 24 GB only.
asked 2023-10-11T09:35:48.61+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, 97%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pratibha Agrawal
0
Reputation points
commented 2024-05-24T03:48:03.2033333+00:00
ShaktiSingh-MSFT
14,081
Reputation points Microsoft Employee
2 answers
Can't connect to Azure Sql with SSMS or Azure Data Studio
I used to be able to get to me Azur Sql database via SSMS (Sql Server Management Studio) or Azure Data Studio but now I can't. Firewall rule error The server you specified x does not exist in any subscription in y Either you have signed in with an…
asked 2024-05-20T16:55:23.8433333+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(9.6, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
John Marsing
0
Reputation points
edited an answer 2024-05-21T11:11:23.7966667+00:00
GeethaThatipatri-MSFT
28,142
Reputation points Microsoft Employee
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-13T14:22:30.33+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(76.8, 64%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David Wolf
5
Reputation points
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
102.6K
Reputation points
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
496
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
28,142
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
28,142
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
ShaktiSingh-MSFT
14,081
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
28,142
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
14,081
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,901
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
14,081
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
Bhattacharjee, Rupajiet
0
Reputation points
answered 2024-02-19T04:08:01.93+00:00
ShaktiSingh-MSFT
14,081
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
14,081
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
14,081
Reputation points Microsoft Employee