How to Install MS SQL Server on Mac and Create Databases - Step by Step
ฝัง
- เผยแพร่เมื่อ 3 มิ.ย. 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
‼️‼️ 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 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?
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 ........
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 🥰
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!!!!!
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. :)
I am so glad I came across this tutorial. This was very easy to follow and understand. Thank you!
Clear, easy-to-understand instructions video. Very helpful. Thanks, Kindson
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
Wow, you really saved the day with this video, I have an M1 Macbook and the docker run cmd string worked perfectly, thanks!
WOW. Thank you SO MUCH for this walk through. I really appreciate it!
I am so glad that you explains it into simple words! many tutorial makes it too complex.
I have been waiting for a while to install, no luck but finally i got it .Appreciate your help for sharing.
AWESOME Tutorial video! The comments are great too. Thank you!
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❤
Thank you so much for this detailed explanation on the installation, was very useful!
You sir deserve an Honor Medal for this, Thank you very much!
Hello !
i had a couple of problems during the installation, but in the end it worked ! thank you so much for the video !!
This is the best tutorial that I have seen on this topic! job well done!
Thanks mate! It was really helpful and seamless to understand. God bless you!
Great tutorial! This helped me a lot 💕You deserve a million or billion followers.
Thank you so 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
OMG you are so good! really helped, asked gpt about some errors, amazing! and i have 0 knowlige before, even terminal. Thank you!
Thank you so much for this easy tutorial! I was ablet to get it all on my laptop.
Thank you! This is very helpful, I could install it finally.
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.
Took me two hours but I'm grateful i went through this and was able to install it on my Laptop
This was such a helpful explanation. Thank you so much.
best explanation so far! bro you have won a new subscriber to your channel. I love this
Many Thanks!
only this video helped me off of so many others that i tried. thank you
Thank you for giving me an idea to install this on my M1. Great!
Brilliant, Many thanks for doing this. Really Appreciate this.
A life-saver video. You made my day, thanks.
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
Great video - so clear. Thank you sir!
Very clear tutorial! Thank you so much!
This was really helpful. Thank you!!
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 😊😊
amazing way of explaining each and every step, just soooooper
Thanks a lot 😊
Very Complete and useful Guide, thank you
Brilliant tutorial. Thanks. Really thorough.
You're very welcome!
Loved this video! It's amazing!!!
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😇
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 ?
Very helpful! Thank you so much
Glad it was helpful!😊
Great Great video, I appreciate the help and the dedication!!
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
Love this video, really helpful
Thank you so much.Worked for me as mine used M1 chip
What a great tutorial. Thanks so much :-)
Glad it was helpful!
Thanks a lot for this tutorial!
Very useful, much appreciated!
Glad it was helpful!
This is the BEST video out there!!
Brilliant channel Kindson!!!
Thank you so much for your help
thank you so muchhh I have Mac M1 chip and I just installed it successfully
Many thanks!
Thanks man! I'm transitioning from pure python to c# and I am the only Mac user at work 😅
Great tutorial. Thank you!
Glad it was helpful!
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
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)
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!!
Thank you ,sir This video very clear Thank a lot 💖🇹🇭
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
very very helpful ...
Thank You
Thank you for the tutorial
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 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?
Daemnn bruhh u did me some real good
Mucho amor
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?
Great video, thank you!
My pleasure!
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
Thank you. you video was very helpful n
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
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
Amazing Explaiation. Thanks man
You're welcome!
Good tutorial! Have you been able to insert tables and data into a database using Visual Studio using Docker?
Thank you so much man!!!
Thank you man! You saved me
Glad I could help!
Thank you! it was great!...
Glad you liked it!
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
Is there a table designer in Azure Data Studio or everything has to be done over queries?
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!!
Thanks so much!
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
Thank you very much!!!
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"
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?
Thank you very much
Thanks for this, but when I got to Azure and tried creating a new connection my server and username where empty. how can I get those information.
After completing the whole installation process, do you need to have internet access to run queries?
Thank you so much !!
You're welcome 😊!
so much useful
thanks a lot
You are most welcome
Hello, I am having trouble at video 11:30, when I right click production.prudocts it says and select top 100, it says scripting failed. How do I troubleshoot?
I have managed to pull it through but it was not easy. Thanks anyway!
amazing video!
Thanks for this video! Just had one problem, when I typed sudo npm install -g sql-cli, I got a command not found error. Any ideas on how to fix this?
Same with me