SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,207 questions
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-22T11:00:14.83+00:00
Erland Sommarskog
114.2K
Reputation points MVP
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
commented 2024-12-21T15:49:53.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(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,450
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,470
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,076
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
![](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
14,001
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)
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
edited a comment 2024-11-06T06:25:54.0766667+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, 14.000000000000002%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVJ%3C/text%3E%3C/svg%3E)
Vickery, James (Intov8)
0
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…
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,826
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,076
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,826
Reputation points Microsoft Employee
4 answers
One of the answers was accepted by the question author.
Errors during build of SQL Server 2022 Projects with VS2019 Professional & AzureDataStudio
Stuck with this issue for longer time. I am trying to create SQL Server Projects for a DB being in SQLServer2022 using VS2019 Professional. DB is old running/being in use since 2009. How much ever I try I face the following warnings & errors, but…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,304 questions
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,207 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.
123 questions
asked 2024-09-18T06:08:31.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(70.4, 75%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Radhai Krish
221
Reputation points
accepted 2024-09-25T05:06:58.87+00:00
Radhai Krish
221
Reputation points
0 answers
Azure Data Studio - Schema Compare - Frquently fails to load database in the server
I have an issue when performing Schema Compare on a SqlProject from Azure Data Studio. When selecting the Source / Target from the right panel, frequently the Database dropdown list contains only "master". Disconnecting and Reconnecting does…
asked 2024-09-20T07:46:08.12+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(179.20000000000002, 34%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Luc Dubrois
0
Reputation points
commented 2024-09-23T17:13:40.99+00:00
Oury Ba-MSFT
19,826
Reputation points Microsoft Employee
0 answers
Azure Data Studio, postgres restore 16 error
Hi all, I am attempting to restore a backup to an Azure PostgreSQL azure database, however getting the following error. "does not contain pg_restore" I can see in the \win\ folder there is no folder for version 16, only 10. Does anyone know…
asked 2024-09-17T13:57:14.6966667+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(112.00000000000001, 50%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
Garion Swann
0
Reputation points
commented 2024-09-20T10:15:31.9266667+00:00
Mahesh Kurva
1,470
Reputation points Microsoft Vendor
0 answers
I got this error when debug my copy data on azure df 7cf2da46-b65b-4098-b8ec-d9c7858c190e
after connecting my Azure data factory to MsSqL, I tried to copy my data into azure data factory and I got this error 7cf2da46-b65b-4098-b8ec-d9c7858c190e
asked 2024-09-13T14:44:21.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(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECO%3C/text%3E%3C/svg%3E)
Charles Onyebuchi
20
Reputation points
commented 2024-09-17T15:42:37.1166667+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,920
Reputation points Microsoft Vendor
0 answers
Connect Azure Data Studio to MicroSoft Azure Cloud
When I try to connect Azure Data Studio to my MicroSoft Cloud Database I receive the following Connection error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not…
asked 2024-09-09T10:13:22.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(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' %3EAM%3C/text%3E%3C/svg%3E)
Adair Macfarlane
0
Reputation points
commented 2024-09-16T21:24:38.35+00:00
Oury Ba-MSFT
19,826
Reputation points Microsoft Employee