How to Install MS SQL Server on Mac and Create Databases - Step by Step

This video explains step by step how to Install MS SQL Server on Mac OS and create databases.
The step are as follows:
00:00 - Introduction
00:45 - Download and Install Docker
02:20 - Download the MS SQL Server Image to Docker
03:32 - Run the Container
05:16 - Install the MS SQL CLI
06:11 - Test the Installation by Login In
06:43 - Download and install the GUI application - Azure Data Studio
08:55 - Download the BikeStores sample database
10:15 - Run the SQL Query to Create the Database objects
11:40 - Run the SQL Query to Load Data
👉 Downlaod Docker from here - www.docker.com/products/docke...
👉 Downlaod Azure Data Studio from here
docs.microsoft.com/en-us/sql/...
👉 Get the BikeStores Sample Datatabase here
www.sqlservertutorial.net/wp-...
🔥 Command to pull MSSQL Docker Image
sudo docker pull mcr.microsoft.com/mssql/server:2019-latest
🔥 Command to run the container
docker run -d --name sql_server_demo -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=reallyStrongPwd123' -p 1433:1433 mcr.microsoft.com/mssql/server:2019-latest
🔥 Command for M1 Chip, please try this
docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=reallyStrongPwd123" -e "MSSQL_PID=Developer" -e "MSSQL_USER=SA" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge
My SQL Tutorials - www.kindsonthegenius.com/mssql
Visit www.kindsonthegenius.com
My Tech Channel / kindsonthetechpro
My websites
www.kindsonthegenius.com
www.munonye.com
www.datarmatics.com
Learn Programming by joining International Computer Programmers here:
👉 / internationalcomputerp...
Feel free to connect with me
❤️ Facebook: / kindsonm
❤️ Instagram: / kindsonthegius
❤️ LinkedIn: / kindson
❤️ Twitter: / kindsonm
❤️ Pinerest: / kindsonm
❤️ Tumblr: www.tumblr.com/blog/kindsonth...
Your support can help me improve my content:
✅ Buy me a coffee: www.buymeacoffee.com/PWsXo7h13
✅ Support me on Patreon: / kindsonthegenius
You can find lots of MS SQL tutorials on website

[@KindsonTheTechPro]

‼️‼️ Hey everyone, please use a strong password like this one "reallyStrongPwd123". I just updated the command. If you use a weak one like "pass", then you cannot connect! ‼️‼️

[@N1_KiWiK]

i have a problem with command "npm install -g sql-cli", my terminal gives me an error like doesn't find that command, what can i do with this problem

[@betulkaya2315]

@@N1_KiWiK hi! ı take same error, ı can't dowland... and ı can't setup mssql. ı need this for my database lesson and ı have been trying for 3 weeks still doesn't work. my system is current: ı using Monterey now. and ı got exams ı have to fix it asap...

[@N1_KiWiK]

@@betulkaya2315 Hi!! I can't help u, how u can see this problem i have too, i trying to install this for exam too. ( Monterey 12.2.1 )

[@N1_KiWiK]

Please Helppppp!!! ❤️

[@betulkaya2315]

@@N1_KiWiK but now I am struggling anothrt error, the next step: mssql -u sa -p really.... I take same thing: mssql: command not found

[@simplyibby8886]

By far, this has been the easiest explanation on how to set up ms sql on back. This video is very self explanatory provided you have all the needed tools pre installed on your Mac. Also, the comment section is very helpful with knowing what’s needed for pre installation. Thank you for sharing your knowledge.

[@xvrpvn4017]

This is one the rare tuto that propose a solution for MAC and M1 Chip. You rock Kindson

[@jav-0003]

I had been struggling with this for the past year and finally someone provides a simple, accurate explanation on how to do this. Thank you!!

[@KindsonTheTechPro]

You're welcome!

[@yuheimiyao2295]

did you MAKE IT?

[@lizsilva3112]

I cannot thank you enough. I found some roadblocks along the way but at the end I was able to install it, Thank you so much!!!!!

[@ramanakodamalla1553]

omgg thank you so much, I was dying with anxiety bc my class was going to start soon and the installation tutorial video my uni provided was for windows only and the MAC installation process is so much more complicated. This helped me so much, thank you so much 🥰

[@53_ritamghosh63]

Very very useful video Kindson. I tried a ton of videos before this, none worked as smotthly as this. Very excited to get started now ........

[@AbrahamLouw]

Wow, you really saved the day with this video, I have an M1 Macbook and the docker run cmd string worked perfectly, thanks!

[@christiejackson5747]

I am so glad I came across this tutorial. This was very easy to follow and understand. Thank you!

[@wangtony5920]

I am so glad that you explains it into simple words! many tutorial makes it too complex.

[@HBodyWMind]

Clear, easy-to-understand instructions video. Very helpful. Thanks, Kindson

[@Nchewiii]

AWESOME Tutorial video! The comments are great too. Thank you!

[@daviddamian1935]

Damn man. Thanks for this awesome video, so glad i came across it. Was watching some other guy's video where he's showing me to pay for the Azure before i can use it and some other stuffs which were usually frustrating. But i'm glad i followed your idea. Thanks. :)

[@arshinadange503]

Thank You so much....every step was explained slowly and nicely please bring up more videos like this....Great Job!!!! and please recommend everyone to use some strong password I was getting some errors due to weak password

[@santiagoxbravo]

You sir deserve an Honor Medal for this, Thank you very much!

[@713theresa]

WOW. Thank you SO MUCH for this walk through. I really appreciate it!

[@JamiewithData]

I have been waiting for a while to install, no luck but finally i got it .Appreciate your help for sharing.

[@akeylahwaite5265]

Great video!! for anyone with trouble at the npm sql cli part download homebrew then input these functions brew install npm npm install sql-cli and than npm install -g sql-cli

[@KindsonTheTechPro]

Thanks for the info!

[@Alemayehu56]

thank you. I been struggling to pass that point in view.

[@jkt2573]

Thank you…how long did it take to install brew? I think I’m at almost an hour now…

[@dankeshod2713]

the

[@Nerdware22]

This is the best tutorial that I have seen on this topic! job well done!

[@mahmudsurvey4330]

Hey, Great job! I am a cloud engineer and now I am using mac for my personal work, so this is a great help, I had a little bit trouble on connecting to server (localhost) thru command, however, I figured it out. Thank you!

[@nw5995]

Hi I got the same probkem, how do you connect the localhost? Very appreciate if you can help me this❤

[@user-tv1st7vm4z]

Thank you so much for this detailed explanation on the installation, was very useful!

[@liviaredua1094]

Hello ! i had a couple of problems during the installation, but in the end it worked ! thank you so much for the video !!

[@Ar1999991]

A life-saver video. You made my day, thanks.

[@mainguyen3367]

Thank you! This is very helpful, I could install it finally.

[@sf11691]

This was such a helpful explanation. Thank you so much.

[@briannaboone9007]

Thank you so much for this easy tutorial! I was ablet to get it all on my laptop.

[@andreking6008]

only this video helped me off of so many others that i tried. thank you

[@michaelangelolucido5006]

Great tutorial! This helped me a lot 💕You deserve a million or billion followers.

[@KindsonTheTechPro]

Thank you so much!😊

[@wudaliabhinavprasad]

Brilliant, Many thanks for doing this. Really Appreciate this.

[@lirenecilliers6301]

Very clear tutorial! Thank you so much!

[@thalathotitharunprabhakar3390]

Thank you for the step. by step installation. It is helpful.

[@ingodavilabanghard5940]

Very Complete and useful Guide, thank you

[@vrdelmnzano7331]

Thank you for giving me an idea to install this on my M1. Great!

[@zhuldyzburgo1487]

OMG you are so good! really helped, asked gpt about some errors, amazing! and i have 0 knowlige before, even terminal. Thank you!

[@karthikvasishtaramesh8681]

This was really helpful. Thank you!!

[@simonroyjonesuk]

Brilliant tutorial. Thanks. Really thorough.

[@KindsonTheTechPro]

You're very welcome!

[@kotkuler]

fantastic video, finally i get how to intall ms SQL on my mac. thank you!

[@Learn2ProMusicLessons]

Thanks mate! It was really helpful and seamless to understand. God bless you!

[@juntaochu4529]

Loved this video! It's amazing!!!

[@Ali-ds5iy]

man I wanna hug you!!!...a real gem of a tutorial. I use parallels desktop but its a mess to connect via a virtual machine (disable firewalls, enable TCP/IP etc) but this dockers i didn't know.. Thank you sooo soo much!!..I didnt have npm or brew so had to even install them as some of your commands were not running. But now I can have all the data bases right here on my mac!..yayyy!😀😀..thansk a billion!

[@mokshitshah3992]

did you get npm not found?

[@Ali-ds5iy]

@@mokshitshah3992 yepp

[@JacWilliamsVideo]

Great video - so clear. Thank you sir!

[@mayankrizu]

This is the BEST video out there!!

[@shaziajatoi222]

amazing way of explaining each and every step, just soooooper

[@KindsonTheTechPro]

Thanks a lot 😊

[@mmayenejiasa1243]

Took me two hours but I'm grateful i went through this and was able to install it on my Laptop

[@onikolasodiq7582]

hello , i will be glad to know thw password yu use to install the azure data studio , thanks

[@thehumbleaquarian]

Thank you so much for this video, You sir are the GOAT😇

[@patrykmajerczyk9274]

Love this video, really helpful

[@akwasidanquahakwaboah730]

best explanation so far! bro you have won a new subscriber to your channel. I love this

[@KindsonTheTechPro]

Many Thanks!

[@gowrikshathriya1638]

Thanks a lot for the M1 container watched and tried a lot of videos but finally your video helped.

[@milenialneeds3381]

Hey, I also use M1 chip.. Do u use azure? Do u kno why I keep on getting this message on docker : "WARNING: Failed to connect to SQL because: dial tcp 127.0.0.1:1431: connect: connection refused, will reattempt connection." ?? I really need help with it coz I cant create new connection on the azure app. Thanks.

[@KindsonTheTechPro]

Glad I could help 😊😊

[@missionyoungblood]

Brilliant channel Kindson!!!

[@leonardomaximo5827]

Great Great video, I appreciate the help and the dedication!!

[@taylorhager5233]

ahh I finally was able to get it to work thanks to your video! thank you so much!

[@KindsonTheTechPro]

Glad I could help!

[@nehapradhan6021]

Thank you so much.Worked for me as mine used M1 chip

[@wendyzhai8948]

Bruh I encountered like 2 million errors doing this but I was able to pull through!!! Thank you so much for making this video I didn't have npm so I had to download it through homebrew but then I also don't have homebrew lmao, so I had to download that too. Such a long ride but it was worth it!

[@KindsonTheTechPro]

Awesome 😊

[@rohitanand9030]

$ brew install node. ==> did not helped me nothing works for me....disgusted. huh! dont know how i landed up installing node.js for this fucking npm thing. still not working

[@atharvadeshmukh164]

Thanks a lot for this tutorial!

[@avinashchowdhury2565]

What a great tutorial. Thanks so much :-)

[@KindsonTheTechPro]

Glad it was helpful!

[@jiaqianshen4152]

really appreciate for you kind help!!! I still have a question about how to import csv file into database? when i using extension SQL server import, I frequently failed... thanks for your help again!!

[@okantel6523]

Hi Mr. Kindson. Can I use like that database with visual studio as simultaneous. For example when i sent some data from project that is on working visual studio , it can be save to on this database as successful ?

[@shanhickson1379]

Very helpful! Thank you so much

[@KindsonTheTechPro]

Glad it was helpful!😊

[@aashishsapkota9089]

While trying to connect the server using mssql -u sa -p reallyStrongPwd123 it says "Failed to connect to localhost:1433 - connect ECONNREFUSED 127.0.0.1:1433" can you please provide any suggestions? I am using a 13 inch m1 MacBook pro, docker is running well and have not changed password (reallyStrongPwd123). Also, I get problems while trying to connect with Azure Data Studio. thank you

[@itsReshad]

Very useful, much appreciated!

[@KindsonTheTechPro]

Glad it was helpful!

[@kanomkainokkata4188]

Thank you ,sir This video very clear Thank a lot 💖🇹🇭

[@mehdiayad7376]

Hello, i did the steps and it doesn't say "running" instead it says "exited(1)" what does that mean? and what should i do? I tried to find f somoene had the same problem and you suggested to run a command docker start $(docker ps -a -q --filter "status=exited") and did it twice, it says running then it goes back to exited (1)

[@LexisShantell]

I’m getting a “ sudo: npm: command not found when trying to install the sql CLI any idea why ?

[@lamlamnguyen7093]

thank you so muchhh I have Mac M1 chip and I just installed it successfully

[@KindsonTheTechPro]

Many thanks!

[@Ahmed_Hassan_Mohammed]

Hello, very nice work, but do these steps work for my MySQL, as I did not find ODBC like Windows, is it possible to explain how to connect to MySQL via Mac? Thank you

[@nikhilbhatt8905]

Great tutorial. Thank you!

[@KindsonTheTechPro]

Glad it was helpful!

[@MT-dc8kl]

Please how do I bypass this error "WARNING: The requested image's platform (linux/amd64) does not match the detected host platform (linux/arm64/v8) and no specific platform was requested"

[@inspyrelifewithimpact]

Hi, thanks for the video. Iam using M1 chip in my mac and the command when i am trying to do sql-cli the terminal gives command not found for npm in the terminal . help please

[@nikhilbande6234]

very very helpful ... Thank You

[@americomarcos2750]

very helpful thank you

[@nabanitadasgupta]

Thank you for the tutorial

[@harinhari7903]

Hi about the code in terminal is it we should continue the same as "2019" or must change it according to the year like for ex my year 2022

[@cryusxin]

Hello, I want to know how to use ODBC to connect to SQL Server on Mac. I have installed the official driver

[@mansi4495]

Hi @Kindson : So i am able to successfully connect and run queries. I have a Query that throws this error - Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column. If you could help with any turnaround for this?

[@ahmadmohammed1607]

Amazing Explaiation. Thanks man

[@KindsonTheTechPro]

You're welcome!

[@vaibhavshimpi5734]

Thank you for the video, really helpful! Can we have the FILESTREAM feature of Sql Server Configuration Manager enabled (Transact based) in MacOS? I am struggling to find it as it is a pre-requisite to run the application locally?

[@SN-kk2bl]

Hey I am curious I did all this and was able to connect just fine and use my Azure data studio. However I restarted my computer and I am a bit confused on how to reconnect. I know I dont have to go through all these steps again but what exactly do I need to do to reconnect. I keep getting errors in ADS. Thanks in advance

[@Haych.H]

Thank you so much man!!!

[@ronahialatroushi4067]

Thank you. you video was very helpful n

[@NikaNabakhteveli.]

Great video, thank you!

[@KindsonTheTechPro]

My pleasure!

[@thatboydrew2242]

Does this not damage the mac if we do this or would it be safer to create a Virtual machine and download MS SQL server from there? And is the way you showed it for the Mac m1 version. Just wondering

[@osdev_mart]

Thanks, if already installed and I want to work I got to run the command run the container right then connect into Azure Data Studio with the User sa and password.

[@LewiUberg]

Thanks man! I'm transitioning from pure python to c# and I am the only Mac user at work 😅

[@theuntormented6560]

Daemnn bruhh u did me some real good Mucho amor

[@NazmulAlom]

Great Video.

[@Naveen3619]

I got this error after executing "Command to run the container" docker: Error response from daemon: Conflict. The container name "/sql_server_demo" is already in use by container "381132bf1f57ed477b38f275282441e5363860c186cb1210b0036b1049". You have to remove (or rename) that container to be able to reuse that name. Should I change any characters in the command?

[@user-is9tt9ek1l]

Thank you for your excellent job.😀

[@KindsonTheTechPro]

So nice of you

[@atreyasunki4690]

@@KindsonTheTechPro hello sir I forgot my password which I need to enter on the terminal..what can I do to know it ?

[@VladyslavStrebkov]

Thank you man! You saved me

[@KindsonTheTechPro]

Glad I could help!

[@julianaelrayes1666]

amazing video!

[@kennyG00228]

My Macbook pro is OS 10.13. I installed homebrew and tried to install node for npm, it does not allow me cuz my ox is too old. I am not willing to update my OS cuz of compability / error with some of existing apps. Does anyone know any webpage / video i can follow to install npm? im new to server stuff...

[@anneryan4051]

Good tutorial! Have you been able to insert tables and data into a database using Visual Studio using Docker?

[@lalibudynamics4922]

I have mac book pro M1 Monterey can I run Visual studio and Sql Serveron Docker? I tried Paralells but got too much errors on visual studio 2022 so I tried Visual 2019 it seems to be better but it is unable to set up Sql Server 2019 do you also have videos for Paralells or any video recomendation for theese issues?

[@kevincranfield2471]

Please how do you create different projects using docker and azure? Thank you

[@deenathdamsinghe]

really helpful

[@cyb3r1]

Is there a table designer in Azure Data Studio or everything has to be done over queries?

[@alanrobles1428]

Hi! I'm from Mexico and you literally have saved my academic life, perfect explanation, you have got a new subscriber! (The only error i got was "Error: Failed to connect to localhost:1433 - connect ECONNREFUSED" but i solved it only changing the password for another one).

[@KindsonTheTechPro]

Glad to hear this 😊

[@user-nz6fb1yf6j]

How did you change the password?(I have the same problem)

[@Tisso1989]

I have the same problem how did you solve that?

[@YT-ky9ww]

@@Tisso1989 Delete container in docker on tab "container/tab" and after re-install it using correct password

[@kobiu12]

Hey everyone , When I open azure data studio. the servers list is empty. What should I do ? Thanks for answering

[@lfcblaze]

you are a legend thank you

[@kindaworks3293]

I am getting error message when trying to connect mssql: Error: Failed to connect to localhost:1433 in 15000ms Newbie here, any suggestions really appreciated!

[@jesayadannyherlim5631]

I'm sorry, permission to ask, can I use full text search on azure sql edge in macbook m1? is there a special trick to be able to use full text search in macbook m1? or is there really no hope of using it on the macbook m1? thanks!!