131 questions with Azure Data Studio tags

Sort by: Updated
0 answers

Unable to filter Result grid in ADS

I have an issue with using 'filter' in Result Grid for big number of records. E.g. when I select e.g. 50K records ... everything works fine. When I select 100K records ..and click on down arrow (filter) it shows me the records ... I could select one…

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.
131 questions
asked 2025-01-24T15:12:48.63+00:00
Voldman, Eliya 20 Reputation points
commented 2025-01-31T15:40:34.9533333+00:00
Voldman, Eliya 20 Reputation points
2 answers

I am unable to see my azure sql migration extension in the azure data studio.

I am unable to see my azure SQL migration extension in my azure data studio. I have installed the Azure SQL Migration extension but unable to see in the data studio even I tried restarting the data studio. I am following this Microsoft document where i…

Azure Database Migration service
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.
131 questions
asked 2023-10-20T12:50:30.3533333+00:00
Surbhi Sharma 0 Reputation points
answered 2025-01-31T11:00:43.0166667+00:00
Maurizio Chessa 0 Reputation points
1 answer

Unable to add account in Azure Data Studio

I am trying to add my work account in Azure Data Studio so that I can connect to a database in Azure. But after I login, I get this error and the account is not getting added. I am not sure what this error is, and it doesn't seem like an auth issue. Has…

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.
131 questions
asked 2025-01-23T13:22:12.8133333+00:00
Aravamudhan Vijayaraghavan 0 Reputation points
commented 2025-01-30T16:27:51.2233333+00:00
Aravamudhan Vijayaraghavan 0 Reputation points
0 answers

CHECK Constraint Errors with Single vs Double Quotes in Azure Data Studio

I'm following the 'Design a Performant Data Model in Azure SQL Database with Azure Data Studio' module and have an issue with adding table constraints (Unit 7). In the Expression field in Azure Data Studio I'm putting as instructed: [card_type] =…

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.
131 questions
Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop new skills.
2,000 questions
asked 2025-01-15T18:02:45.8+00:00
Kurczyńska Jolanta (STUD) 5 Reputation points
edited the question 2025-01-28T21:39:16.0666667+00:00
Erland Sommarskog 116.1K Reputation points MVP
1 answer

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…

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.
131 questions
asked 2025-01-12T23:01:33.8333333+00:00
HassanET1 0 Reputation points
commented 2025-01-16T17:06:20.4866667+00:00
NIKHILA NETHIKUNTA 4,425 Reputation points Microsoft Vendor
1 answer

How to troubleshoot creating service principal?

I'm trying to use the Ingest feature in Data Factory and I'm on the "Source data store" step so I'm trying to establish the connection with the DB. The first code block is the error details after testing the connection for the error code:…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,183 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.
131 questions
asked 2025-01-14T06:11:02.5133333+00:00
Ryan Tay 5 Reputation points
answered 2025-01-15T15:51:33.0333333+00:00
Ganesh Gurram 3,595 Reputation points Microsoft Vendor
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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,400 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.
131 questions
asked 2025-01-10T16:33:39.5933333+00:00
Sean 0 Reputation points
commented 2025-01-15T10:23:48.93+00:00
Sai Raghunadh M 2,155 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…

Azure SQL Database
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.
131 questions
asked 2025-01-08T13:10:34.2833333+00:00
Ryan Tay 5 Reputation points
commented 2025-01-13T08:39:08.4333333+00:00
Vijayalaxmi Kattimani 1,065 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…

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.
131 questions
asked 2024-01-26T21:39:18.1833333+00:00
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…

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.
131 questions
asked 2023-09-25T15:37:27+00:00
red stone 1 Reputation point
commented 2025-01-06T21:05:04.24+00:00
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…

Azure SQL Database
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.
131 questions
asked 2024-12-25T03:46:11.51+00:00
Ganbaatar Bold 0 Reputation points
commented 2024-12-28T20:19:56.0933333+00:00
Sina Salam 16,766 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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,400 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.
131 questions
asked 2024-12-21T18:51:06.77+00:00
Avinab Das 0 Reputation points
commented 2024-12-24T12:21:05.5433333+00:00
Vijayalaxmi Kattimani 1,065 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

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.
131 questions
asked 2024-12-20T02:54:52.5766667+00:00
abed sabbah 0 Reputation points
edited a comment 2024-12-24T00:49:31.4333333+00:00
Sai Raghunadh M 2,155 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…

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.
131 questions
asked 2024-12-04T13:57:13.3333333+00:00
Ajay Gera 0 Reputation points
commented 2024-12-16T17:49:29.7666667+00:00
Mahesh Kurva 2,430 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…

Azure SQL Database
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.
131 questions
asked 2023-06-03T05:05:13.9033333+00:00
Joe 0 Reputation points
commented 2024-12-13T14:59:59.1833333+00:00
sguidos 10 Reputation points
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…

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.
131 questions
asked 2024-12-07T12:08:06.47+00:00
Seyoung Park 0 Reputation points
answered 2024-12-10T06:27:21.0533333+00:00
ShaktiSingh-MSFT 16,236 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…

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.
131 questions
asked 2023-05-25T12:14:24.9233333+00:00
Anju Kirankumar 5 Reputation points
commented 2024-12-04T18:11:48.4166667+00:00
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…

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.
131 questions
asked 2024-11-14T09:02:21.88+00:00
Aqsa Kazi 0 Reputation points
commented 2024-11-22T11:26:38.4633333+00:00
Sina Salam 16,766 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

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.
131 questions
asked 2024-10-17T15:17:49.5233333+00:00
Jon Z 140 Reputation points
accepted 2024-11-12T16:51:03.7166667+00:00
Jon Z 140 Reputation points
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…

Azure SQL Database
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.
131 questions
asked 2024-09-26T20:47:26.6433333+00:00
John Kozempel 0 Reputation points
commented 2024-10-28T14:37:24.2433333+00:00
Jon Mozley 35 Reputation points