Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,051 questions
2 answers
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
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,685 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.
112 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
191
Reputation points
edited a comment 2024-09-18T12:58:54.8166667+00:00
Radhai Krish
191
Reputation points
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
edited a comment 2024-09-18T07:33:34.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(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
5
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
1,760
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
18,696
Reputation points Microsoft Employee
2 answers
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
0
Reputation points
commented 2024-09-14T10:50:03.3866667+00:00
Maximilian Ksoll
0
Reputation points
4 answers
Azure Data Studio - Azure SQL Migration extension thinks the Managed Instance is still in 'Creating' state.
In step 3 of the Azure SQL Migration where the user chooses the managed instance: Error: The managed instance 'managedinstance' is unavailable for migration because it is currently in the 'Creating' state. To continue, select an available managed…
asked 2023-02-28T11:28:45.1133333+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, 31%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Vlasopoulos V
10
Reputation points
answered 2024-09-11T20:29:01.65+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, 68%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
ROHTASHV GEHLLOT
5
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
edited the question 2024-09-03T03:19:36.95+00:00
Sumarigo-MSFT
45,786
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-08-09T03:06:20.2+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(243.2, 98%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQS%3C/text%3E%3C/svg%3E)
Qreatiq Support
5
Reputation points
2 answers
Restore AdventureWorks2022.bak Database in Azure Data Studio on mac m1
I had tried restoring the AdventureWorks2022 and 2019 .bak files in Azure data studio on mac m1 chip(sonomo 14.5). The restore button is not able to popup to click. SO it is unable to restore the AdventureWorks. bak files
asked 2024-06-17T09:28:31.7566667+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, 39%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tayi, Venkata Surya
0
Reputation points
commented 2024-07-27T20:50:35.34+00:00
Erland Sommarskog
110.4K
Reputation points MVP
1 answer
If Manage Engine Required Azure data Studio
As per my request If Azure Data Studio 1.48.1 is Required for Manage Engine End Point Central or else we can remove it
asked 2024-07-01T10:34:27.93+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(233.6, 25%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Akhil E
0
Reputation points
commented 2024-07-05T23:21:55.0666667+00:00
Oury Ba-MSFT
18,696
Reputation points Microsoft Employee
1 answer
Azure Data Studio with PostgreSQL connection type cannot connect to server
Hello, I'm currently trying to connect to a server via a PostgreSQL connection on Azure Data Studio. I installed the app from the official webpage and then added the PostgreSQL extension via the app extensions interface. I have copied a configuration…
asked 2024-06-28T14:33:01.2333333+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(118.4, 82%, 21%)' 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)
Ludovic Arnould
0
Reputation points
commented 2024-07-01T15:20:26.7466667+00:00
GeethaThatipatri-MSFT
29,377
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
40
Reputation points
commented 2024-06-04T09:20:30.9133333+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
15,131
Reputation points
2 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
answered 2024-06-03T08:29:26.8066667+00:00
ShaktiSingh-MSFT
15,131
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
96
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
32,311
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
110.4K
Reputation points MVP
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
15,131
Reputation points
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
29,377
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
110.4K
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
641
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
29,377
Reputation points Microsoft Employee