Install SQL Server in Mac M1 | Apple Macbook | Install SQL Server in Docker Mac
HTML-код
- Опубликовано: 25 июл 2024
- Hello Guys, in this video you will learn how to install SQL Server in Mac M1. This is going to be very useful video who trying to install Microsoft SQL Server in MacBook M1 based device. Install of SQL Server is really very easy in Mac OS with M1 base processor devices. It works really smooth with M1 Chip. Here we are using Azure Data Studio for accessing the database, it is having similar kind of user interface like SSMS.
Command to install and run SQL Server in docker:
docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=MyPassword123#" -e "MSSQL_PID=Developer" -e "MSSQL_USER=SA" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge
This video tutorial also relates to the following video:
- install sql server in docker Mac
- installing sql server in mac using docker
- sql server in Mac m1
- sql server in MacBook
- microsoft sql server in Mac
- mac sql server
- mac sql gui
- sql server installation Mac
- sql server management studio install Mac
SQL Server commands:
Create Table: -
CREATE TABLE Employee (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Age int,
PRIMARY KEY (ID)
);
Insert data: -
Insert into Employee (LastName, FirstName, Age)
values ('Kumar', 'Rajhans', 23);
Select data: -
Select * from Employee;
Download Azure Data Studio:
learn.microsoft.com/en-us/sql...
Go to this link to take the test to identify yourself.
oktests.com/
Like us on Facebook: / oktests
Laptop Used for Creating the Video:
amzn.to/3yqeI8g
Best Laptops for Programming in the Market:
amzn.to/3dVUHP8
amzn.to/3dYMxp7
amzn.to/3i4e7mb
amzn.to/2TM8Ozm
amzn.to/3yCoTGU
Mic used for creating the video:
amzn.to/3whY9Ke
Best Mic for Recording:
amzn.to/3yCF2fe
amzn.to/3hnh6a3
amzn.to/3qVe1Rz
amzn.to/3hrpN34
Best Mic for RUclipsr:
amzn.to/3hPq12R
amzn.to/3AJYjgD
amzn.to/2UAETtZ (Type - C Microphone)
Go to the below link to subscribe to our channel:
/ @localhostok
Book for learning ASP.NET Core and Design Patterns:
amzn.to/2SHgN0i
amzn.to/3w26T72 Наука
Please subscribe my channel: ruclips.net/channel/UCkvHV0-_J9qiW2W_EICHd-w
Thank you. Spent days trying to install mssql watching/reading other tutorials/guides without success and finally this one worked
Great video. This one got me over the hump. A million thanks!
Thank you very much for your help. I could install very easily following your steps .. Very good video 🙂🙂🙂🙂🙂🙂🙂🙂
THANK YOU very much for your help, this video is very easy to understand and it works
Glad to hear that
Thank you mate! It works
how did u bring upbeat Mayer and sql mcr in container?
Finally something that works. Thank you sooo much.
You're welcome!
Do you know how can I do it for mac 10.13? because the docker available in the website you said is only for 10.15 or newer. Thank you!
When you will go to download page for docker, you need to download Docker with Intel chip. You can go to this link to docker for Intel chip. docs.docker.com/desktop/mac/install/
Great video! Blessings 🙏
Working perfectly for Mac M1
Thank You so much.
Excellent video, thanks for all!!!
Our pleasure!
Thank you very much!!
You're welcome!
Azure SQL Edge has very limited supported features
Thank you very much ❤❤❤
Thank you
Thanks!! 😊
just what I needed! ok :)
Glad I could help!
Can we use the same for ipad Air 5th gen. I need to install MS sql in Ipad
in iPad, there is iOS operating system, it for Mac OS. I am not sure you can try.
nice. btw, how to run localhost system ?
Great video but I am getting this error when I try to connect with Azure....
(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)...I'm not sure what to do because I followed your steps
I think you need to check servername or instance name and port number, also you need to check the credentials
why did we need docker if it all works in azure data studio?
Azure data studio is client to access the SQL server database while database is installed inside docker.
The Sql Server is running while Azure Data Studio is open? or do I need to stop Sql Server to stop cpsmuming resources?
You need not to close SQL server
Hi I have been trying to download SQL on my Mac OS and your has really helped me out but likewise I have tried with various means and still can't get through it. Everything was going really fine when I downloaded Azure there as an error which came on the screen stating "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)" I would really request you to kindly help me out as I need to download all my setups asap. Thank You.
I think you are using the wrong credentials.
same is with me. it shows :
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - 38852451
I have the same problem. 😭 Nobody has been able to answer how do we get that d
Fixed, how to go back to correct it.
@@localhostok okay I don't have that as my problem and still get that same error, how do we go back and fix that issue? Are there any steps to follow and where do we start? Thanks
And if want to know why this suggested video didn’t work out for me then you can email me and I ll help you further.
Thanks
HELP, please. I;m stuck at 9:35. Attempted to create a connection on Azure Data Studio. Entered localhost as Server name, entered my User Name and Password, clicked on Connect, and got message, "Login failed for user," and then correctly showed my login name.
Maybe you can try reinstalling the SQL server again
When I connect with Azure Deta Studio
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal exception was caught)
Login failed for user 'sa'.
do you know how to solve this
change on correct password - MyPassword123#
you can view the password in the terminal
couldnt find the Azure Data Studio page , can you link it up
I have added Azure data studio download link in video description.
How did you get that user name and password that you can put in azure data studio please explain ??
You can find the username and password we are passing in command. You can find that command in the video description. MSSQL_SA_PASSWORD for password and MSSQL_USER for user for ex SA is username in the command.
Please make a crud app with angular with this Db
Sure, I will try to do that 👍
i have database file in .bak format
how do i import .bak file on azure data studio?
I haven't exactly done it, but you can follow this link
learn.microsoft.com/en-us/sql/azure-data-studio/tutorial-backup-restore-sql-server
I got this error when trying to insert a record "Common Language Runtime(CLR) is not enabled on this instance". can you help to resolve? T_T
You can see this Microsoft URL, and try executing the given SQL Query.
learn.microsoft.com/en-us/sql/relational-databases/clr-integration/clr-integration-enabling?view=sql-server-ver16
@@localhostok Thank you for reply. I've tried some solutions including that one, but none of them work, I just wonder why you can just pull and run the image and execute the insert statement T_T, and I got this error.
Good video, but when I attempt to make a connection in Azure it responds with "Login failed for user 'SA'.", despite entering the correct password and username. Has anyone experienced this?
Did you ever figure it out? I'm messing with it now.
Yes, you can't copy -> paste the password, you have to write it.
Great video... but you gotta check those emails Bub!
This really helped thanks
Glad to hear it!
I LOVE YOU, YOU SAFE MY LIFE
Please share the table command as well 12:25
Added the table commands in the video description. Thanks for letting me know.
docker container doesn't run on my Mac
could you help me ?
Maybe you can try restarting your Mac and check. Can you also write the error message what you are getting?
how to install azure sql edge?
You can check command to install SQL in description
hi it dont work, docker cant run my image how fix it? it shows !
arm64
Whats the error you are getting
@@localhostok image dont run in docker
@Laughing Technologies The DDL Insert Command provided is wrong, the primary key attribute ID is not having any value nor it has been set to AUTO-INCREMENT, so you need to have some value there, I hope this was just a mistake and just posting here so that others who are beginners don't get confused.
hi i got error at the time of connection can you help me. installation are done password is wrong this msg is showing.
Please check the password what you have entered in SQL installation command.
How to learn SQL after that ? Please, I need to learn SQL and I only have a Mac book
You can learn from any free SQL tutorial websites out there in market, and try executing the SQL queries in you local machine. It will help you quickly learn SQL free of cost.
am unable to find SA local host
Can you describe more about error? Looks like you have something else as user name at place of sa
change on correct password - MyPassword123#
you can view the password in the terminal
didn't understand at 7:50
Is all this free?
Yes, it's completely free
Command to install SQL server in docker changed here is the new one:
what's It
the one in the description worked for me tho
Where is it?
@@ea8352 do you not see it in the description?
don't understand from 8:15
This is free?
Yes
Thank-you @ingTechnologiesOkTestscom,
I saw more then 10 videos it was not helpfull enough but after your video it solved my problem to install SQL Server in my new MacBook Pro.
once again THANK YOU 😊
Hey how did you get that user name and password from terminal ? So that you can use that in azure studio please explain
@@shristimalla3817 ( docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=MyPassword123#" -e "MSSQL_PID=Developer" -e "MSSQL_USER=SA" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge )
just copy & paste it in terminal to install MS SQL. In this above link u can observer ' MSSQL_USER=SA ' as user name, were u can change it to any thing and Password as ' MyPassword123# ' this can also be changed to ur choice.
Incomplete information
Skipped SQL commands
Commands are mentioned in the description, you can get it from there. That should work
Please don't use ! in password when you download SQL Server
rey mental u skipped or the viseo i think where is the middle one
I kept getting an error but here is the video that helped me trouble shoot and filled in the gaps: ruclips.net/video/J4MgJxNZyBU/видео.html
Hope this helps!
Are you sure, you know how to use SQL on M1, its seem you are talking shit after 8:10, I would request if you don't know so why you guys upload the videos
Thankyou for your suggestion, i will try to create detailed video. But if you didn't understand anything then you can let me know your questions
no use
Unecessary kitna confusion create kiya hai bhai....
You explain incredibly badly, you switch at 5.38 minutes. You don't show what you uploaded and what commands you gave.
You can check the command in video description. You need not to use that command mentioned at 5:38.
Yes incomplete info
boş yapma lan
are you making he video in a public bathroom?
not in the bathroom 😀, there might be some surrounding sounds in this video, but I guess those sounds are very less and it is not creating problem in understand the concept.
Thank you
You're welcome