How To Install SQL Server on Mac M1 & M2 | Latest for 2022

How to Install SQL Server and SQL Server Management Studio on Your Mac with M1 & M2 Apple Chip. With IDE. Latest for 2022 (MacOS Monterey). Step by Step Guide.

Docker Run Command :

(Change the password inside the curly braces {} and don't include the curly braces when you run the command.)

Example :

Keywords :
Install SQL server on mac
Install SQL Server Management Studio on mac
Install SSMS on mac
Install SQL server on mac m1 m2
Install SQL Server Management Studio on mac m1 m2
Install SSMS on mac m1 m2
Install SQL server on mac azure
Install SQL server on mac 2021
SQL server

#mac #macbook #sql #sqlserver

[Alcaraz]

Hi Dominic! I'm starting my Data Analyst bootcamp and with this video you helped me in my first challenge (install SQL on my Mac). I saw a lot of videos and read many forums where the solution passed by installing a virtual machine, which is paid. Hopefully I came to here! Thanks a lot !🙏

[juanmoctezuma]

Hi Dominic - Great video and super useful - it helped me out setting sql up! Although for setting the SA_PASSWORD when connecting docker with azure..., please make a note for the future that the password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols... I ran into this issue and I'm sure (based on the comments) that plenty of folks had the same problem too - I hope this helps - cheers

[juliaguzheng]

Thank you Dominic! One little pitfall I noticed is that when running the command line (provided in video description), I had to replace double quote to single quote to get it work, not sure why, but I think is worth sharing, might help some of you who's having trouble.

[mattconway]

Worked great, but one thing to add is that you have to go into advanced settings when starting the connections for the first time and set your port to 1433 which is what the terminal code that is programmed to grab. Hopefully that helps someone as it took me about 45 minutes of troubleshooting to realize.

[Miss_Khemmie]

I have been battling with this for months. This video is a life saver. It made it so easy. Thank you so much.

[huysaysoui]

In my first attempt, it didn't work because I whether downloaded a wrong version instead of Apple Silicon one or I had written the password that wasn't complicated enough. Everything works!! Thank you

[victorselvadorai]

Thank you so much Dominic.. I am from finance background no knowledge on computers.. but wanted to learn SQL.. this video helped me to install the SQL with ease.. thank you so much.. wish you more success..

[VincenzoCappelluti]

I spent a lot of days to find a effective guide. I finally found! Thank you so much!!!

[RichardFarrell-ethi]

Thank you so much. Other guides doesn't work. I tried to install for hours until I found you!

[hrm]

Hi Dominic, great video. However on the final step I am getting following error on my mac:

TCP Provider, error 40 - could not open a connection to SQL server: Could not open a connection to SQL Server

Any help will be appreciated.

[Carmensitaaa]

For everyone with this error showing: " 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) ", you can fix it by deleting the container and creating another one by taking the exemple from the description of the video. This one worked for me..

[kathleenwong]

OMG this video helps a lot!!! I have M2 Macbook and was giving me quite a tough time at the Azure connection step. If anyone ever encounter some connection error 35 like I do, please try put "localhost, 1433" and try again. If it kept saying that connection fail to login "username" please try remove the container and run command in terminal again removing all the " quotation marks. This whole set up process took me 5 hours so much research.

[tsitsimunemo]

The simplest way to install and very straightforward. Thank you!!!

[sheelsanghvi]

I was facing some issues with getting docker images running with Mac M2. This video really helped. Thank you!!

[The_Shah_Family]

Hi Dominic, I followed all the steps as it is but when I am adding a connection, I am running into an error -
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)
Please help me. How can I connect with you?

[kathyzhu]

Thank you so much! The information is very detailed and has been incredibly helpful. I encountered an issue with the "docker engine stopped" during the process, only to realize later that I had not yet upgraded my Mac. After completing the upgrade, all the other processes ran smoothly.

[BayuLiano]

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), why ?

[dom]

Excellent video! Been struggling to get SQL loaded onto my M1 for a long long time. Until now :)

[irzou]

For those having user name error please be sure you also delete "{}" before adding your new password other way add it while connecting

[BitteRic]

Thank you for your well-detailed tutorial, but I am still having issues with connecting to the Azure Data Studio. I am getting the error "Login failed for user 'SA'." Please can you advise on what I am doing wrong?