Stack Overflow
Stack Overflow

Questions tagged [azure-sql-edge]

Azure SQL Edge is an relational database for IoT and IoT Edge Deployments based on the SQL Server database engine. Use this tag specifically for when asking questions when using Azure SQL Edge. Do not use this tag when asking about Azure Synapse, Azure SQL Database, or SQL Server.

Azure SQL Edge is a version of SQL Server designed with IoT in mind. It is able to be run on both ARM64 and x64 environments (unlike SQL Server, which only supports x64).

It is built on the latest versions of the SQL Server Database Engine, but is a much more scaled-back version. Many features are not supported on Azure SQL Edge such as CLR dependant functions/data types (such as FORMAT and hierachyid), Active Directory Integration, Linked Servers, and SQL Server Agent.

What is SQL Edge?

27 questions
11
votes
3 answers

The specified option 'clr enabled' is not supported by Azure SQL Edge

I'm a .NET developer and new to mac (m1 pro). I use docker and pull the azure-sql-edge image. When I try to create a table with a geometry column or insert a value in the geometry type column that was generated by code first solution, I encounter…
Abbas Behjatnia
  • 131
  • 1
  • 5
7
votes
3 answers

Initialize SQL Server database in docker container without sqlcmd

I am working on a MacBook Pro with M1 CPU so I can't use the "normal" mssql docker image. I am using azure-sql-edge that doesn't have sqlcmd to initialize the database (create schema, database, login). I have created a sql script that I would like…
chenny
  • 769
  • 2
  • 17
  • 44
4
votes
1 answer

Connecting to Sql Edge Server running in Docker from .net core 6.0

I have been trying to build an application in .net core 6.0, but I am facing issue while connecting it to the sql edge server running in docker.I have been running it on mac. Here is the connection string i am using in…
Amit Kumar Panda
  • 41
  • 1
3
votes
2 answers

How do I resolve a "docker: invalid reference format" error when installing Azure SQL Edge on an M1 Mac?

I've been trying to install Azure SQL Edge using Docker on my M1 MacBook using this guide and I'm not able to run the following command: docker run -d — name MySQLServer -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=your_password123’ -p 1433:1433…
Paul_Harrison
  • 31
  • 1
  • 2
2
votes
0 answers

User defined function crashes Azure SQL Edge docker container on M1 Macbook with error: Unable to dispatch SIGSEGV

I'm running a few legacy databases in an Azure SQL Edge docker container instance on an M1 Macbook and it consistently crashes when running a user defined function. This function makes a cross database SELECT statement to retrieve some data for…
Al Ma
  • 21
  • 2
2
votes
3 answers

Sql server not running inside docker in m1 processor

I am trying to make sql server run inside the docker in the mac m1 processor. Every time I am getting exit code 1 Processor : Arm(mac m1) docker image tried with : mcr.microsoft.com/azure-sql-edge:1.0.6 and…
Prashant Gupta
  • 166
  • 12
2
votes
0 answers

How to get Docker image to run on Mac M1

I'm trying to launch SQL Server for a technical test on my Macbook. Docker seemed to be best solution. Tried using instructions from https://database.guide/how-to-install-sql-server-on-an-m1-mac-arm64/ Installed Docker okay. Then tried to use: sudo…
elksie5000
  • 7,084
  • 12
  • 57
  • 87
2
votes
2 answers

ASP.NET EF Core Database update on Mac using docker image Azure Sql Edge

I am new to mac and got Azure Sql Edge running using docker image. This is the command I ran to run the image. docker run -d --name SQLServerImg -e ACCEPT_EULA=Y -e SA_PASSWORD=StrongPassword@123 -p 1433:1433 mcr.microsoft.com/azure-sql-edge This…
divinecode
  • 21
  • 1
1
vote
0 answers

What is /var/opt/mssql-extensibility in azure-sql-edge Docker image

I am running the azure-sql-edge docker image like this: docker run --cap-add SYS_PTRACE -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=" -p 1433:1433 --name azuresqledge -v sqlvolume:/var/opt/mssql -d…
stefan.at.kotlin
  • 15,347
  • 38
  • 147
  • 270
1
vote
1 answer

Connect to SQL Server in a Docker container from Parallels guest using SSMS

I am working with a MacBook M1 that runs a SQL Server database using microsoft-azure-sql-edge image. On the same laptop is running a Win 11 VM using Parallels where SQL Server Management Studio is installed. The issue is that I can't connect to the…
chenny
  • 769
  • 2
  • 17
  • 44
1
vote
1 answer

CREATE USER... fails on Azure SQL Edge running in Docker (MacBook Air M1)

I have an Azure SQL Edge running in Docker, but I'm not able to create new database users. CREATE USER gives following error: "You can only create a user with a password in a contained database." If I try to change containment using ALTER DATABASE…
janikoodaa
  • 13
  • 1
  • 5
1
vote
0 answers

Can not connect to the azure-sql-edge. Why?

I have the following docker-compose.yml: version: "3.9" services: # Database instance mssql: image: mcr.microsoft.com/azure-sql-edge:latest volumes: - events_mssql:/var/opt/mssql ports: - 1433:1433 …
qqqqqqq
  • 1,831
  • 1
  • 18
  • 48
1
vote
1 answer

Trying to change permissions in azure-sql-edge Dockerfile

I'm currently setting up a docker image based on "mcr.microsoft.com/azure-sql-edge:latest" Below is part of my docker file FROM mcr.microsoft.com/azure-sql-edge:latest COPY startup.sh /startup.sh RUN chmod u+x /startup.sh ... CMD ["/bin/bash",…
hogni89
  • 1,920
  • 6
  • 22
  • 39
0
votes
0 answers

How to build JSON with selected fields from JSON columns in SQL Server keeping fields type

I have JSON like this: { "_key": { "id": "3b8d1ed7-c3ec-32ec-a083-2ddc17152e94", "rootId": "15c85327-9628-3685-b84a-375b546ba92a", }, "employeeInfo": { "idNumber": "3", "gender": "Male", "age": 20, .... }, …
Valeriy K.
  • 2,616
  • 1
  • 30
  • 53
0
votes
2 answers

How to build new JSON with JSON_VALUE in SQL Server? Can't set value type

I have JSON like this: { "_key": { "id": "3b8d1ed7-c3ec-32ec-a083-2ddc17152e94", "rootId": "15c85327-9628-3685-b84a-375b546ba92a", }, "employeeInfo": { "idNumber": "3", "gender": "Male", "age": 20, .... }, …
Valeriy K.
  • 2,616
  • 1
  • 30
  • 53
1
2