How to Install MS SQL Server on Mac and Create Databases - Step by Step
HTML-код
- Опубликовано: 27 июл 2024
- 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
![MAF Teeski - Whole Thing (feat. VonOff1700) [Official Music Video]](http://i.ytimg.com/vi/SHWEj-ndz6g/mqdefault.jpg)
‼️‼️ 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! ‼️‼️
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
@@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...
@@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 )
Please Helppppp!!! ❤️
@@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
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.
This is one the rare tuto that propose a solution for MAC and M1 Chip. You rock Kindson
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!!!!!
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!!
You're welcome!
did you MAKE IT?
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 🥰
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 ........
I am so glad that you explains it into simple words! many tutorial makes it too complex.
Wow, you really saved the day with this video, I have an M1 Macbook and the docker run cmd string worked perfectly, thanks!
Clear, easy-to-understand instructions video. Very helpful. Thanks, Kindson
I am so glad I came across this tutorial. This was very easy to follow and understand. Thank you!
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. :)
AWESOME Tutorial video! The comments are great too. Thank you!
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
Thanks for the info!
thank you. I been struggling to pass that point in view.
Thank you…how long did it take to install brew? I think I’m at almost an hour now…
the
I have been waiting for a while to install, no luck but finally i got it .Appreciate your help for sharing.
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!
Hi I got the same probkem, how do you connect the localhost? Very appreciate if you can help me this❤
WOW. Thank you SO MUCH for this walk through. I really appreciate it!
You sir deserve an Honor Medal for this, Thank you very much!
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
Thank you so much for this detailed explanation on the installation, was very useful!
This is the best tutorial that I have seen on this topic! job well done!
Hello !
i had a couple of problems during the installation, but in the end it worked ! thank you so much for the video !!
Thank you! This is very helpful, I could install it finally.
A life-saver video. You made my day, thanks.
Thank you so much for this easy tutorial! I was ablet to get it all on my laptop.
OMG you are so good! really helped, asked gpt about some errors, amazing! and i have 0 knowlige before, even terminal. Thank you!
This was such a helpful explanation. Thank you so much.
Brilliant, Many thanks for doing this. Really Appreciate this.
Great tutorial! This helped me a lot 💕You deserve a million or billion followers.
Thank you so much!😊
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!
did you get npm not found?
@@mokshitshah3992 yepp
Very clear tutorial! Thank you so much!
Thank you for giving me an idea to install this on my M1. Great!
Very Complete and useful Guide, thank you
Great video - so clear. Thank you sir!
This was really helpful. Thank you!!
only this video helped me off of so many others that i tried. thank you
fantastic video, finally i get how to intall ms SQL on my mac. thank you!
Thank you for the step. by step installation. It is helpful.
Brilliant channel Kindson!!!
This is the BEST video out there!!
Loved this video! It's amazing!!!
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!
Awesome 😊
$ 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
Thanks mate! It was really helpful and seamless to understand. God bless you!
Love this video, really helpful
Brilliant tutorial. Thanks. Really thorough.
You're very welcome!
amazing way of explaining each and every step, just soooooper
Thanks a lot 😊
ahh I finally was able to get it to work thanks to your video! thank you so much!
Glad I could help!
Thank you so much for this video, You sir are the GOAT😇
Took me two hours but I'm grateful i went through this and was able to install it on my Laptop
hello , i will be glad to know thw password yu use to install the azure data studio , thanks
best explanation so far! bro you have won a new subscriber to your channel. I love this
Many Thanks!
Great Great video, I appreciate the help and the dedication!!
Thanks a lot for the M1 container watched and tried a lot of videos but finally your video helped.
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.
Glad I could help 😊😊
What a great tutorial. Thanks so much :-)
Glad it was helpful!
Very useful, much appreciated!
Glad it was helpful!
Thank you so much.Worked for me as mine used M1 chip
Very helpful! Thank you so much
Glad it was helpful!😊
Thanks a lot for this tutorial!
Thank you so much man!!!
Thank you ,sir This video very clear Thank a lot 💖🇹🇭
Thank you for the tutorial
Great tutorial. Thank you!
Glad it was helpful!
thank you so muchhh I have Mac M1 chip and I just installed it successfully
Many thanks!
very very helpful ...
Thank You
amazing video!
very helpful thank you
Amazing Explaiation. Thanks man
You're welcome!
Great video, thank you!
My pleasure!
Great Video.
Thank you man! You saved me
Glad I could help!
Thank you for your excellent job.😀
So nice of you
@@KindsonTheTechPro hello sir I forgot my password which I need to enter on the terminal..what can I do to know it ?
Thank you. you video was very helpful n
Daemnn bruhh u did me some real good
Mucho amor
Thanks man! I'm transitioning from pure python to c# and I am the only Mac user at work 😅
Thank you so much for your help
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).
Glad to hear this 😊
How did you change the password?(I have the same problem)
I have the same problem how did you solve that?
@@Tisso1989 Delete container in docker on tab "container/tab" and after re-install it using correct password
you are a legend thank you
Thank you! it was great!...
Glad you liked it!
Thank you very much!!!
Thank you!!!
man you are amazing
excellent tutorial
Thank you so much !!
You're welcome 😊!
Thank you so much!!!!!
so much useful
thanks a lot
You are most welcome
Thank you very much
really helpful
Thanks so much!
my guy, God bless you already
Thanks a ton 😊🙏
Thank you so much
Wow, thx broo
My pleasure 😊
Thanks a lot!
Thank you so much :-)
Many many thanks @Prajakta!!
Thank you soo much
Thanks!
Thank you!
You're the best.
Thanx a lot ❤❤❤❤❤❤❤❤❤❤❤
Thank you 🙏🙏🙏
I have managed to pull it through but it was not easy. Thanks anyway!