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…
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…
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…
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
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…
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…
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…
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…
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…
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
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
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…
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…
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…
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…
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…
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.
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…
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?
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…