Run Microsoft SQL Server on Mac OS using Docker Container | Azure Data Studio

#sqlserver #docker #azure
In this video you will learn how to install and run Microsoft SQL Server on MacOS using Docker desktop and connect using Microsoft Azure Data Studio.
Github
github.com/edocbuhtig
Donate & Support
If you find the video of any help in your work, please take some time and donate some food to homeless people around your home or workplace.

[@VincenzoCappelluti]

not working for me :( after filling connection fields and pressing "Connect", it remains in "thinking mode", no error or popup appear. I don't know what it is doing. I'm on M1 Ventura.

[@Full_Stack_Dev_Bharat]

You are not alone with this problem see stackoverflow.com/questions/68975743/docker-image-runs-on-intel-mac-but-not-m1-mac if you still don't get a solution please keep me posted shall be happy to help you

[@sachinverma8892]

hi buddy i just want to know whether this problem is resolved or not as i am also facing this same situation.

[@Full_Stack_Dev_Bharat]

medium.com/geekculture/docker-express-running-a-local-sql-server-on-your-m1-mac-8bbc22c49dc9

[@Full_Stack_Dev_Bharat]

medium.com/geekculture/docker-express-running-a-local-sql-server-on-your-m1-mac-8bbc22c49dc9

[@VincenzoCappelluti]

@@Full_Stack_Dev_Bharat Hi Sunil, I solved installing DBeaver. It works very fine. Thank you 😊

[@akadiwa9811]

hi am getting this error but i follwed the instructions and it worked (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and t hat SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)

[@Full_Stack_Dev_Bharat]

Nice it's working

[@jakesmit353]

I keep getting this error, any help suggested? I am using Macbook M1 "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server: Could not open a connection to SQL Server)"

[@Full_Stack_Dev_Bharat]

looks like internet network related issue not a bug, please try again

[@Full_Stack_Dev_Bharat]

Did it work for you?

[@georgezambrano5166]

is the password for accepting the eula the same password as your account login for docker?

[@Full_Stack_Dev_Bharat]

Docker credential will not work for SQL Server End-User License Agreement (EULA). Please watch the video carefully you must use - MSSQL_SA_PASSWORD='

[@mjdalmutari4128]

why when i put user name it does not work?

[@Full_Stack_Dev_Bharat]

Username is SA?

[@giftthavichay441]

when i use user name it Login failed for user 'sa'

[@Full_Stack_Dev_Bharat]

Please try to connect directly to MSSQL server using SQL Server Management Studio (SSMS) check if that works independently for you then debug what you are missing.

[@yoelnapitupulu1181]

when i try to run like this : CREATE DATABASE PresDB ON PRIMARY (NAME = PresidentDBPrimary, FILENAME = '/Users/booting09/Documents/BASDAT/PresDB.mdf', SIZE = 10MB, MAXSIZE = 20MB, Filegrowth = 20%) and i press run, the file that i want did'n show up in the path that i use in the FILENAME

[@Full_Stack_Dev_Bharat]

What are you trying to achieve? Sorry. Context? i'm confused, please explain to help you further, thanks.

[@yoelnapitupulu1181]

@@Full_Stack_Dev_Bharat i want this to be saved in “FILENAME =“path”” but when i run the code the file don’t exist in the path that i write in filename

[@user-mz6nn9et6o]

does it work on macbook pro?

[@Full_Stack_Dev_Bharat]

Yes it does work

[@ekpoedidiong7891]

Please what password did you use?

[@Full_Stack_Dev_Bharat]

In the case if you are using the default SA login you don't use any password. I'm not sure about your case, please elaborate more. If you set a password use that one.

[@moradorignac7937]

i spent 3 hours trying to look for the exact version to copy in docker website and no matter what i type it shows me 10.000 results. Do you have a link?

[@Full_Stack_Dev_Bharat]

Hope this helps, please let me know which version and OS you are installing it? i am confused how to help you ? please see this for now : docs.docker.com/desktop/install/mac-install/

[@moradorignac7937]

@@Full_Stack_Dev_Bharat Thank you! i already installed the docker and the azure but is not working, i dont know what iam missing while i install it. What i can find is the page of the minute 1.14. Mi computer is this one: intel core i5

[@moradorignac7937]

And is a model 13,01

[@Full_Stack_Dev_Bharat]

this video is using intel not M1/M2(please see:docs.docker.com/desktop/install/mac-install/ )

[@Full_Stack_Dev_Bharat]

Link : docs.docker.com/desktop/install/mac-install/

[@yogeshrao9563]

is it works on m1

[@Full_Stack_Dev_Bharat]

You need two different tweaks for Mac running on M1 chipset a) use this docker IDE > docs.docker.com/docker-for-mac/apple-m1/ and b) docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=Mypass@word" -e "MSSQL_PID=Developer" -e "MSSQL_USER=SA" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge

[@venukawijethunga427]

@@Full_Stack_Dev_Bharat Worked on mac m1

[@Full_Stack_Dev_Bharat]

Glad it worked, thank you!