Update for M1 Macs (Apple Silicon): as of July 2021 the following command works (note the change of image): docker run -d \ -p 1433:1433 \ -e "ACCEPT_EULA=Y" \ -e "SA_PASSWORD=P@ssword1" \ --platform linux/arm64 \ --name docker-sql \ mcr.microsoft.com/azure-sql-edge Tested on an M1 MacBook Air base model. Will post an updated video if we can find a mainstream image that works.
Connection strings should just work as usual, where the server is running (whether in a Windows SQL server or in a Docker image) should be transparent to the consuming application. The bigger question is whether VBA in Excel will work on the Mac…?
Hi I have a couple of questions. 1. Once we created the container, do we need to create it again as for me, it just disappers from the docker dashbaord. 2. Im getting the following error when creating the connection: A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
Hi Haris, thanks for watching. 1) You shouldn't need to no. Once the container exists you can just start it up again using "docker start containername". If you run "docker ps -a" on the command line you should see a list of all running and non-running containers 2) Did you set the accept eula environment variable?
@@RDT could you give me your email or something I could contact on? I really need this fixed as I have assignments coming up. Please I would be really appreciative.
Thank you so much! This video has helped me along more than the other dozen I have watched. However, I am getting an error when I attempt to connect. It says "Connection Error: Login failed for user 'sa'." Are you able to help?
Hi Robert, I am using latest Macbook pro M1 chip version 11.5.2 and It doesn't work for me and I also used the another link u mentioned in below amrita's comment and it's mentioned like this :
Thanks Amrita, glad you liked it! No we've not got an M1 in the office (yet..), but we have heard some of the Docker support isn't quite there yet. Which version of Docker Desktop are you running? Looks like theres a new version here: docs.docker.com/docker-for-mac/apple-silicon/ we'd be interested to hear how you get on? Also, found this which may be helpful: medium.com/geekculture/docker-express-running-a-local-sql-server-on-your-m1-mac-8bbc22c49dc9 (but not tried it)
@@RDT Thank you for your quick response 😊! I am running the newest version i.e. Docker Desktop 3.3.1(the one that you provided the link to). Since not all Intel versions are yet supported by Docker for M1 Mac, SQL Server might not be working. I will try the alternative you provided the link to and let you know if it works. Thanks again for your help and please let me know when you try it with M1.
Error message says it's not the correct image for my platform: WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested 534ef0a13d0a9060502530775030e98850d1192555305869d0fd33c1e264c669 - I'm running MAC with APPLE M1 chip
Hi have you tried the following (note the change of image): docker run -d \ -p 1433:1433 \ -e "ACCEPT_EULA=Y" \ -e "SA_PASSWORD=P@ssword1" \ --platform linux/arm64 \ --name docker-sql \ mcr.microsoft.com/azure-sql-edge Tested on an M1 MacBook Air base model.
@@RDT hi, I have the same issue here where the docker-sql runs for few seconds and stopped. and inside message says: the EULA must be accepted before SQL, where can I accept the EULA? Thanks
Update for M1 Macs (Apple Silicon): as of July 2021 the following command works (note the change of image):
docker run -d \
-p 1433:1433 \
-e "ACCEPT_EULA=Y" \
-e "SA_PASSWORD=P@ssword1" \
--platform linux/arm64 \
--name docker-sql \
mcr.microsoft.com/azure-sql-edge
Tested on an M1 MacBook Air base model. Will post an updated video if we can find a mainstream image that works.
Just wanted to confirm - I'm an Apple M1 User and managed to run and connect to the instance problem free :) You have earned my subscription sir
Thanks for the sub! Glad to hear it helped you
Genio!! muchas gracias por este gran dato
IM SO THANKFUL FOR YOU!!! I'M TRYING TO DO THIS FOR ONE WEEK AND I WAS SO UPSET IM SO HAPPY TO SEE YOUR VIDEO!!!!! THANK YOU VERY MUCH YOU'RE THE BEST
Superb. I'll be giving this a try later
Great! Let us know how you get on 😊
Thankyou, really helped me get started
Glad it was helpful for you 🙏
This actually works.
😀
Great video - thank you. I currently access my Windows based SQL Server through VBA within MS Excel - can I access a docker version on a Mac this way?
Connection strings should just work as usual, where the server is running (whether in a Windows SQL server or in a Docker image) should be transparent to the consuming application. The bigger question is whether VBA in Excel will work on the Mac…?
Hi I have a couple of questions.
1. Once we created the container, do we need to create it again as for me, it just disappers from the docker dashbaord.
2. Im getting the following error when creating the connection: A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
Hi Haris, thanks for watching.
1) You shouldn't need to no. Once the container exists you can just start it up again using "docker start containername". If you run "docker ps -a" on the command line you should see a list of all running and non-running containers
2) Did you set the accept eula environment variable?
@@RDT could you give me your email or something I could contact on? I really need this fixed as I have assignments coming up. Please I would be really appreciative.
Thank you so much! This video has helped me along more than the other dozen I have watched. However, I am getting an error when I attempt to connect. It says "Connection Error: Login failed for user 'sa'." Are you able to help?
That may be as straightforward as you having the wrong password for SA, how did you set up the password?
Hi Robert,
I am using latest Macbook pro M1 chip version 11.5.2 and It doesn't work for me and I also used the another link u mentioned in below amrita's comment and it's mentioned like this :
Hi, what is the error you are receiving?
Helpful video! Have you tried installing SQL Server on Mac with M1 chip? The container starts and exits on my MacBook with M1.
Thanks Amrita, glad you liked it! No we've not got an M1 in the office (yet..), but we have heard some of the Docker support isn't quite there yet. Which version of Docker Desktop are you running? Looks like theres a new version here: docs.docker.com/docker-for-mac/apple-silicon/ we'd be interested to hear how you get on?
Also, found this which may be helpful: medium.com/geekculture/docker-express-running-a-local-sql-server-on-your-m1-mac-8bbc22c49dc9 (but not tried it)
@@RDT Thank you for your quick response 😊! I am running the newest version i.e. Docker Desktop 3.3.1(the one that you provided the link to). Since not all Intel versions are yet supported by Docker for M1 Mac, SQL Server might not be working. I will try the alternative you provided the link to and let you know if it works.
Thanks again for your help and please let me know when you try it with M1.
@@RDT didn't work (
@@RDT thank you a lot i don't have words to convey my gratitude. It worked. Thank you
Great! So glad it helped you
what are the libraries to use in dotnet for mac if i want to work with sql server 2019 container on mac m1 ?
Hi Moshiko - a SQL connection or ORM, such as EF Core (Entity Framework) will do the trick as it’s just a connection string
How to access sql server in docker container from outside network? I mean not "local host"
Error message says it's not the correct image for my platform: WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested
534ef0a13d0a9060502530775030e98850d1192555305869d0fd33c1e264c669 - I'm running MAC with APPLE M1 chip
Hi have you tried the following (note the change of image):
docker run -d \
-p 1433:1433 \
-e "ACCEPT_EULA=Y" \
-e "SA_PASSWORD=P@ssword1" \
--platform linux/arm64 \
--name docker-sql \
mcr.microsoft.com/azure-sql-edge
Tested on an M1 MacBook Air base model.
in my case, it only worked when I droped :2019-latest
Thats good to know Hee1ko, thanks. What platform are you on?
@@RDT I’m using macOS big sur v 11.4
Thanks! M1 or Intel?
It’s Intel! Macbook pro 2017
Help, it's not working
Hi Victor, please can you explain the errors you are recieving
@@RDT hi, I have the same issue here where the docker-sql runs for few seconds and stopped. and inside message says: the EULA must be accepted before SQL, where can I accept the EULA? Thanks
Hi Chunbin, you can set an environment variable in the container to accept the EULA with the parameter -e “ACCEPT_EULA=Y”