Azure SQL Database
An Azure relational database service.
5,754 questions
0 answers
Mac M1 running MS SQL on Docker, unable to connect from Azure Data Studio
Hi, I'm facing some problems on my M1 Macbook when I try to connect to a MS SQL instance on Docker from Azure Data Studio. This is the verbose log I got from Azure Data Studio: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection…
asked 2022-12-05T02:21:30.967+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(57.599999999999994, 24%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Douglas Antoniazi
6
Reputation points
commented 2024-10-28T16:06:15.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(16, 42%, 11%)' 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)
Salahuddin Shaikh
5
Reputation points
9 answers
SQL Server install error Wait on the Database Engine Recovery Handle Failed
SQL Server 2019 install error Wait on the Database Engine Recovery Handle Failed this error is coming and i have tried everything on the internet to solve this but it still isnt installing can anyone tell me how to remove this error
asked 2021-07-28T10:27:04.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(134.4, 4%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Priyanshu Singh
31
Reputation points
commented 2024-07-29T10:24:39.9733333+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(268.8, 39%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mluleki Memela
0
Reputation points
2 answers
How to use SQLCMD in ARM64 architecture?
I am using NVIDIA Jetson Orin nano board (which is based on ARM64 architecture) to as an IoT Edge device to deploy Azure Edge modules from Azure marketplace. I have deployed the temperature sensor and SQL Edge module modules inside the board, and they…
asked 2024-06-20T10:56:41.71+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(128, 99%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Pritam Chanda
45
Reputation points
commented 2024-06-25T09:57:30.35+00:00
Pritam Chanda
45
Reputation points
1 answer
One of the answers was accepted by the question author.
Establishing module-to-module communication in Azure IoT Edge
How can I achieve module-to-module communication between two modules in Azure IoT Edge, specifically the Simulated temperature sensor and Azure IoT SQL Edge modules available in the Azure Marketplace? I am following this guide. Is this the correct…
asked 2024-06-24T09:18:33.3866667+00:00
Pritam Chanda
45
Reputation points
accepted 2024-06-25T08:58:23.4666667+00:00
Pritam Chanda
45
Reputation points
2 answers
Olá, tudo bem? Não estou conseguindo instalar o SQLSERVER 2019 no meu computador, já desinstalei mas o erro continua. Se alguém puder me ajudar fico muito feliz. Obrigada!
Ação necessária: Use as seguintes informações para corrigir o erro, desinstale o recurso e execute o processo de instalação novamente. Motivo da falha do recurso: Erro durante o processo de instalação do recurso. Detalhes do erro: § Erro ao instalar…
asked 2024-06-07T15:15:13.34+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, 28.999999999999996%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bianca Lima
0
Reputation points
commented 2024-06-17T05:52:26.52+00:00
LucyChenMSFT-4874
5,060
Reputation points
1 answer
One of the answers was accepted by the question author.
Can't use Azure Sql Edge backup due to it being version 964.
Is there any way to restore an Azure SQL Edge database anywhere other than on Azure SQL Edge? I have the latest CUs on SQL Server Express and LocalDB, but it still wouldn't take an Azure SQL Edge backup. Here is the…
asked 2024-01-22T13:02:28.3466667+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(169.60000000000002, 8%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVI%3C/text%3E%3C/svg%3E)
Victor Irzak
20
Reputation points
accepted 2024-01-22T21:28:19.1366667+00:00
Victor Irzak
20
Reputation points
2 answers
How to fix power function issue while changing db compatibility level change
We are using sql server 2019 server with db 110 compatability. Currently we are changing the DB compatability level from 110 to 150.After changing the compatability level to 150 , we have noticed the breakage there in the power of function and its…
asked 2023-09-11T07:43:28.2133333+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(102.4, 44%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENP%3C/text%3E%3C/svg%3E)
narmatha pitchaimani
0
Reputation points
edited the question 2023-10-16T15:57:34.4133333+00:00
GeethaThatipatri-MSFT
29,477
Reputation points Microsoft Employee
1 answer
Connecting to Azure SQL Edge (local docker instance) from another network machine
Hi I have a local instance of Azure SQL edge running (using docker on MacBook). I am trying to connect to the server, with using pyodbc (in google colab), but i keep getting this error: I already followed this document:…
asked 2023-09-27T00:00:40.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(169.60000000000002, 35%, 26%)' 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)
Sunraj sharma
65
Reputation points
answered 2023-09-27T08:51:39.3366667+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,421
Reputation points
1 answer
One of the answers was accepted by the question author.
Trying to install and run Azure SQL Edge on Docker on Mac (intel). Runs for a few seconds and then stops.
Overview I am trying to install and run SQL server from Docker. It runs for a few seconds and then exits with a code of 255. I am trying to install Azure SQL edge on Macbook running on intel. Commands I ran to install the image sudo docker pull…
asked 2023-09-23T18:02:21.3366667+00:00
Sunraj sharma
65
Reputation points
commented 2023-09-25T23:18:16.2133333+00:00
Sunraj sharma
65
Reputation points
1 answer
How can I install sql sync agent in a Ubuntu environment?
I am trying to set up azure sql edge device . I also have an Azure SQL database set up in the cloud. I want to synchronize data from sql edge to sql database in the cloud. For that, I was trying to create a sync group and install sql sync agent in Azure…
asked 2023-09-20T11:19:49.71+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(12.8, 71%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Anura Adhikari
0
Reputation points
edited an answer 2023-09-21T12:49:33.4666667+00:00
Alberto Morillo
34,056
Reputation points MVP
3 answers
alternative to store procedure
Hi Expert, do we have any alternative to store procedure while running merge statement where we can use exec or run like exec sp_name can we use view instead of any table to something else Regards
asked 2023-09-14T13:26:11.2666667+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(140.8, 75%, 23%)' 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)
Shambhu Rai
1,411
Reputation points
edited a comment 2023-09-15T10:25:28.9566667+00:00
Shambhu Rai
1,411
Reputation points
1 answer
One of the answers was accepted by the question author.
temp table parameters
Hi Expert, unable to understand the below query can someone explain me what is happening in below query CREATE PROCEDURE [dbo].[THINKNEW] @CurrentVersion BIGINT, @LastVersion BIGINT AS BEGIN IF…
asked 2023-09-08T18:02:32.0833333+00:00
Shambhu Rai
1,411
Reputation points
accepted 2023-09-08T23:08:09.0166667+00:00
Shambhu Rai
1,411
Reputation points
4 answers
One of the answers was accepted by the question author.
; in MSSQL
"When I give only a semicolon (;) in a query, I am getting the message 'Commands completed successfully.' Are there any other symbols that can give the same result?"
asked 2023-06-12T05:27:30.4933333+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(147.20000000000002, 36%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Raguram Manokaran
90
Reputation points
accepted 2023-07-27T05:36:50.6933333+00:00
Raguram Manokaran
90
Reputation points
1 answer
Docker / Azure Data Studio - What am I doing wrong?
Mac OS Monterey, 12.5.1 I installed Docker on 10/19 from your website. downloaded the Azure SQL Edge image using the terminal command docker pull mcr.microsoft.com/azure-sql-edge. I then downloaded Azure Data Studio. Then ran the terminal…
asked 2022-10-24T02:29:13.127+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, 6%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESJ%3C/text%3E%3C/svg%3E)
S John
11
Reputation points
commented 2023-07-17T17:23:20.7633333+00:00
Oury Ba-MSFT
19,581
Reputation points Microsoft Employee
1 answer
Unable to backup new sql server instance databases on azure portal
Hi Team, We have sql server installed on a windows machine, we have already three instances there and we have scheduled the backup on azure portal and was running fine. After adding a new instance on sql server we are unable to schedule its backup on…
asked 2023-06-27T06:17:22.6033333+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(32, 14.000000000000002%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Nitin Goyal
5
Reputation points
answered 2023-06-27T07:53:28.8466667+00:00
Chathura Munasinghe
170
Reputation points
1 answer
One of the answers was accepted by the question author.
Securing access to the Azure SQL Server Database via SSMS using Privatelink ?
My company already using the Azure Express route circuit to allow secure and quicker data access across the WAN. I am trying to secure access to my SQL database in Azure from my user laptop across the globe. Turn off the Public Endpoint for all SQL…
asked 2023-06-14T05:32:57.09+00:00
EnterpriseArchitect
5,406
Reputation points
accepted 2023-06-14T12:45:58.6366667+00:00
EnterpriseArchitect
5,406
Reputation points
1 answer
Issue in running AzureSQLEdge module on IoT Edge Device
Hi Team, As part of my research, I have deployed AzureSQLEdge module from Marketplace.It was running earlier.But now seems to be faile due to the below exception 2023-05-11 09:56:45.81 spid9s Starting up database 'msdb'. 2023-05-11 09:56:45.82…
asked 2023-05-11T10:50:05.8333333+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(166.4, 59%, 26%)' 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)
Athira Gopinath(UST,IN)
96
Reputation points
answered 2023-05-16T01:54:31.62+00:00
LeelaRajeshSayana-MSFT
15,886
Reputation points Microsoft Employee
1 answer
Azure SQL Edge - Docker - Macbook M1 - Error occurred during the pre-login handshake
After update Macbook M1 to Monterey 12.5.1 the following error started happening: Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login…
asked 2022-08-24T02:37:45.13+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(73.60000000000001, 41%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
MATTHEUS PIROVANI
11
Reputation points
edited the question 2023-01-25T19:19:39.0633333+00:00
Oury Ba-MSFT
19,581
Reputation points Microsoft Employee
1 answer
Query related to sync between Azure SQL Edge database and Azure SQL database
Hi Team, Objective of this work is to implement a hybrid Cloud-Edge application model where we need to sync the Azure SQL Edge database and Azure SQL database. For that purpose, we followed this "https://learn.microsoft…
asked 2022-12-06T07:54:28.9+00:00
Athira Gopinath(UST,IN)
96
Reputation points
commented 2022-12-19T05:04:05.787+00:00
Athira Gopinath(UST,IN)
96
Reputation points
2 answers
One of the answers was accepted by the question author.
I tried to restore a database by Azure SQL Edge docker on Mac M1, I got "Database size would exceed license limitation" error.
Is there full version of Azure SQL edge docker for ARM? How can I restore the database on ARM (mac) system? I got the following error when I tried to restore a sql server database by Azure SQL edge container on MAC os M1 max. If it could be restored,…
asked 2022-12-09T18:04:22.293+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(137.6, 52%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
woodymoo
266
Reputation points
commented 2022-12-14T23:42:09.03+00:00
GeethaThatipatri-MSFT
29,477
Reputation points Microsoft Employee