Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
127 questions
0 answers
Azure Data Studio SQL Migration waiting to start forever
After installing and enabling azure sql migration extension in azure data studio it was unable to launch and throwing error as "Failed to start service" then I have updated the required proxy setting in Azure data studio, error is gone but…
![](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(275.2, 10%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
1 answer
Azure Data Studio failed local connection to MSSQLSERVER Developer Edition
Hello Microsoft community members. I am having a very simple issue connecting ADS to MSSQLSERVER Developer Edition. Upon establishing the connection, I am entering the correct server and instance name (having verified through SQL Server Configuration…
asked 2025-01-10T16:33:39.5933333+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(54.400000000000006, 77%, 15%)' 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)
Sean
0
Reputation points
commented 2025-01-10T22:12:05.82+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(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,760
Reputation points Microsoft Vendor
2 answers
✗ Microsoft.SqlServer.Prose.Import.BcpProcessException: Error inserting data into table.
As I understand it, the issue is when importing csv files on Azure Data Studio, the data type is a string and has to convert to another data type. But the error can't convert the string to another data type, how am I supposed to bypass this if I can only…
asked 2025-01-08T13:10:34.2833333+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(275.2, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Ryan Tay
5
Reputation points
answered 2025-01-10T08:59: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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
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
commented 2025-01-06T23:36:41.6033333+00:00
Abhijit Shrikhande
377
Reputation points
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 2025-01-06T21:05:04.24+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(224.00000000000003, 13%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lang, Ann (New York)
0
Reputation points
2 answers
Azure data studio table designer error execution time out
An error occurred while generating preview report: One or more errors occurred. (Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.) at…
asked 2024-12-25T03:46:11.51+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, 38%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Ganbaatar Bold
0
Reputation points
commented 2024-12-28T20:19:56.0933333+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, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
15,011
Reputation points
1 answer
I cannot see restore option in azure studio in mac?
Hello everyone I am trying to restore a database in SQL server using Azure Data Store but I cannot see the Restore option in my Azure Data Store studio. I even tried "Enabled Preview Feature" option How can I fix it or is there other version…
asked 2024-12-21T18:51:06.77+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(89.60000000000001, 23%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Avinab Das
0
Reputation points
commented 2024-12-24T12:21:05.5433333+00:00
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
1 answer
error opening azure data studio
I downloaded the Azure Data Studio areas and when I want to enter the application it gives me an error message that the application cannot be opened, can someone help me solve the problem? My computer is a Mac M2
asked 2024-12-20T02:54:52.5766667+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(211.20000000000002, 14.000000000000002%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
abed sabbah
0
Reputation points
edited a comment 2024-12-24T00:49:31.4333333+00:00
Sai Raghunadh M
1,760
Reputation points Microsoft Vendor
1 answer
How to connect to Oracle database created to Azure from Azure portal
I have created oracle database on Azure using Azure portal. I have connection string / DataSource of that database. On Trying to Connect to Oracle Database from Azure data Studio I am getting "Connection request timed out" error. Please let me…
asked 2024-12-04T13:57:13.3333333+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(64, 57.99999999999999%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ajay Gera
0
Reputation points
commented 2024-12-16T17:49:29.7666667+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,700
Reputation points Microsoft Vendor
1 answer
Azure Data Studio not showing system views
I have recently started using Azure Data Studio as well as SSMS. If I connect to a database in SSMS and go to the object explorer under views there is a system views folder that I can browse. If I connect to the same database in Azure Data Studio using…
![](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(307.2, 55.00000000000001%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%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(28.799999999999997, 33%, 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)
2 answers
Azure cloud shell won’t launch in Azure data studio integrated terminal
Hello, I’m having issues with Azure cloud shell in the Azure data studio. When I try to launch azure cloud shell by clicking ">" button in the azure account banner on the sidebar, an error message is printed and the shell launched in the…
asked 2024-12-07T12:08:06.47+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(156.8, 43%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Seyoung Park
0
Reputation points
answered 2024-12-10T06:27:21.0533333+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
16,166
Reputation points
0 answers
Azure Data Studio - Not able to connect to Oracle DB -Getting ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA error
Hi I installed, Azure Data Studio, Downloaded the extension for Oracle . However while connecting to an Oracle database Im getting the following error ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA This is not an issue with the…
asked 2023-05-25T12:14:24.9233333+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(70.4, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anju Kirankumar
5
Reputation points
commented 2024-12-04T18:11:48.4166667+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, 48%, 11%)' 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)
Glenn Menard
0
Reputation points
1 answer
Unresolved Reference Errors in Azure Pipelines for Database Project with Views Referencing Tables from Other Databases
I have a database project in Azure Data Studio that references tables from another database within its views. I have added this project to a GitHub repository and am using Azure Pipelines for build and release pipelines. However, during the build…
asked 2024-11-14T09:02:21.88+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(115.19999999999999, 94%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Aqsa Kazi
0
Reputation points
commented 2024-11-22T11:26:38.4633333+00:00
Sina Salam
15,011
Reputation points
2 answers
One of the answers was accepted by the question author.
mysql: calling stored procedure ends before completing
I am connecting to mysql database from azure data studio, however when running an stored procedure call sp_xxx And this sp returns several "select", the procedure ends after the first call Is this an issue? Thanks
![](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(224.00000000000003, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJZ%3C/text%3E%3C/svg%3E)
1 answer
Cannot connect to Azure Data Studio SQL Server database
I have a simple azure sql server database that I can no longer connect to in Azure Data Studio. When I try to connect via SQL server login, the Create a Firewall Rule screen appears. When I select either "add my client IP" or "add my…
asked 2024-09-26T20:47:26.6433333+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, 99%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
John Kozempel
0
Reputation points
commented 2024-10-28T14:37:24.2433333+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(307.2, 45%, 39%)' 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)
Jon Mozley
35
Reputation points
0 answers
Azure Managed Instance Migration offline mode. Cannot find full back up error
I am trying to my migrate my on-prm sql server to SQL managed instance via Azure Data Studio Managed instance. I am using the offline mode to migrate the server and my back up files are saved in blob starage account. When i initate the migration i get an…
asked 2024-08-02T18:55:23.06+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(105.60000000000001, 84%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hossain, Shakir
21
Reputation points
commented 2024-10-23T22:03:30.4533333+00:00
Oury Ba-MSFT
19,991
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
SQL server databases migration to Azure SQL VM using Azure Data studio
Hello, I am migrating the SQL server databases to Azure SQL VM using Azure data studio but step 6 - validating the connectivity failed with below error. I am able to connect to SQL server using SSMS from same server. I can be able to see the…
![](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(102.4, 92%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
How to Access SQL Server Docker (Running on MAC) from Power BI (Running on Parallels)
I am trying to access a SQL Server database through Power BI (in a "Parallels" virtual environment) that is running in Docker on my MacBook. HOW SHOULD I CONFIGURE TO GAIN ACCESS ? I want to be able to access this database within Power…
asked 2024-10-16T15:55:15.9833333+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(288, 43%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Alan Figueroa
20
Reputation points
accepted 2024-10-18T18:58:31.51+00:00
Alan Figueroa
20
Reputation points
1 answer
Azure Data Studio - connection error on intranet
I am using Azure Data Studio on Macbook , I am not able to connect to SQL Server on intranet running on another machine. I can connect to SQL Server with sqlcmd and jdbc based tools. Not sure why Azure Data Studio keeps returning error 40 , I deleted…
asked 2024-10-17T04:59:18.8866667+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(176, 23%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ritz
0
Reputation points
answered 2024-10-17T07:10:08.36+00:00
ShaktiSingh-MSFT
16,166
Reputation points
2 answers
One of the answers was accepted by the question author.
Comparison of actual database schemas against each other (within one database)
Hi all, for a small project I created a database within Azure and one schema for dev and one for prod (to save run cost). I would like to compare these two schemas now with Azure Data Studio, but it looks like, that I can only compare databases with one…
asked 2024-08-17T10:10:18.3266667+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, 1%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Maximilian Ksoll
20
Reputation points
commented 2024-10-03T18:06:47.1133333+00:00
Oury Ba-MSFT
19,991
Reputation points Microsoft Employee