Setting up SQL Server on macOS using Docker
Вставка
- Опубліковано 19 вер 2024
- This video is the recording of the steps I have followed for setting up SQL Server on macOS using Docker Desktop community edition.
🌟 Detailed Article: www.mytecbits....
🌟 Download docker desktop from: www.docker.com...
🌟 Download SQL Server Docker Image from: hub.docker.com...
🌟 Code to pull the SQL Server container image:
docker pull mcr.microsoft.com/mssql/server:2019-latest
🌟 Code to run the SQL Server container image:
docker run --name mssql_docker -e 'ACCEPT_EULA=Y' \
-e 'SA_PASSWORD=[[Your-Password]]' -p 1433:1433 \
-d mcr.microsoft.com/mssql/server:2019-latest
🌟 To check and confirm that the SQL Server container is running:
docker ps
🌟 Download Azure Data Studio from: github.com/Mic...
🌟 My Website: www.mytecbits.com
#macOS #docker #sqlserver
hello, mr . I don't work for me, I have macbook m1 , sql server don't run in docker ??? why
I am not sure how its running for you, but MSSQL does not work for mac M1 chips as there is no support from microsoft yet
hi pls help,
when i insert the code:
docker run --name mssql_docker -e 'ACCEPT_EULA=Y' \ -e 'SA_PASSWORD=[[Your-Password]]' -p 1433:1433 \ -d mcr.microsoft.com/mssql/server:2019-latest
it comes out as 'docker: invalid reference format'. how do I fix this? thank u
hi, have u fix it ?
Thank you very very very mush mate
Happy to help
Hi, thanks for the tutorial i made all the steps but for any reason it gives me an error message "Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=75175; handshake=0;"
do you know what could be happening?
thanks
Hi,
Sorry for the delay in replying your query.
To avoid connection errors. please check for the below points:
1. Make sure the sql container in docker is running by going to the docker desktop (ua-cam.com/video/fGmaK88j4xg/v-deo.html). If it is not running then start it.
2. In azure data studio, the server should be localhost.
3. Make sure you are using the same sa password you have specified in the run command.
@@mytecbits thanks ir was the localhost, I have to put my ip and no the word localhost
Not working and I'm tech savvy
Great video! Thanks!
You're welcome!
After copy the status what is the next step
I got the connection failed error when i entered "sa" as a user name. Sir Please advise.
Hi,
Sorry for the delay in replying your query.
To avoid connection errors. please check for the below points:
1. Make sure the sql container in docker is running by going to the docker desktop (ua-cam.com/video/fGmaK88j4xg/v-deo.html). If it is not running then start it.
2. In azure data studio, the server should be localhost.
3. Make sure you are using the same sa password you have specified in the run command.
Helpful :-)