32 questions
0
votes
1
answer
439
views
docker-compose / podman compose SQL Server on Apple Silicon /Mac M! Segmentation Fault [closed]
SQL Server used to run smoothly and then after a disk full issue I had to rebuild the podman vm. Then the problem started: I would get a segmentation fault even running with platform: "linux/...
- 466
0
votes
1
answer
346
views
Unable to create external data source using Azure SQL Database Emulator
I am trying to use the Azure SQL Database Emulator described here: https://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-sql-database-emulator?view=azuresql
I am trying to ...
- 181
3
votes
1
answer
971
views
Import data-tier application (bacpac) into azure SQL edge docker instance
I am trying to import data from a .bacpac sql data file into a azure sql edge container. I have tried 2 ways to achieve it, but unfortunately no luck.
Using sqlpackage cmd tool to import bacpac file ...
- 735
1
vote
1
answer
564
views
Azure SQL Edge container on Raspberry Pi5 is not working
I am trying to run Azure SQL Edge Docker container on my RPi5 running RaspbianOS Debian GNU/Linux 12 (bookworm) aarch64. BTW - On my RPi3B it was running fine.
I ran the command
sudo docker run --cap-...
- 21
0
votes
1
answer
136
views
Azure SQL Edge streaming reading from JSON
I'm trying to place JSON in a table where each key would be a value in a column, and I receive these two types of errors:
09/27/2023 16:41:00,
"/SUBSCRIPTIONS/SUBSCRIPTIONID/RESOURCEGROUPS/...
- 61
0
votes
2
answers
715
views
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",
},
&...
- 2,914
0
votes
1
answer
244
views
I am able to connect to Azure SQL Edge with pymssql but not with azuredatastudio what could be the reason?
So I have this code that is able to print All database names from my Azure SQL Edge docker instance.
On port 1433 there one docker container is running
I am entering the same credentials on Azure ...
- 762
2
votes
0
answers
272
views
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=<my secure password>" -p 1433:1433 --name ...
- 18.5k
4
votes
1
answer
2k
views
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 ...
1
vote
1
answer
528
views
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.&...
- 13
1
vote
2
answers
3k
views
Azure SQL Edge container failed to start on M1, when mapping volume to relative path
On an M1 Macbook, I followed online examples and successfully start Azure SQL Edge container with basic configuration.
Then I want to map a volume (mySpecialFolder) by "Path to the host, relative ...
- 3,033
2
votes
0
answers
1k
views
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/...
- 7,882
3
votes
2
answers
11k
views
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 ‘...
3
votes
2
answers
1k
views
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 ...
- 35
14
votes
4
answers
20k
views
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, ...
- 991
13
votes
3
answers
8k
views
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 ...
- 151