Installing SQL Server on Azure
- Download DOCKER DESKTOP
Download Docker desktop from https://www.docker.com/products/docker-desktop/
2. DOCKERHUB.COM
Register/login at Dockerhub.com. We will sql server download image from here.
3. SEARCH IMAGE
Search Azure SQL Edge Image from docker hub and install on local machine
open the terminal and type
docker pull mcr.microsoft.com/azure-sql-edge
It will pull docker image on your machine
then type this command on termainal
docker run -e “ACCEPT_EULA=1” -e “MSSQL_SA_PASSWORD=Pass@word123” -e “MSSQL_PID=Developer” -e “MSSQL_USER=SA” -p 1433:1433 -d –name=mssql mcr.microsoft.com/azure-sql-edge
“ACCEPT_EULA=1” accept user agreement
MSSQL_SA_PASSWORD set strong password for sql server
MSSQL_PID=Developer sql server developer edition will be installed.
MSSQL_USER=SA. User name is sa for sql server
-p 1433:1433 port 1433 will be assigned
D detach mode means terminal will be free to use.
–name name of container
mcr.microsoft.com/azure-sql-edge docker hub repository name
4. AZURE DATA STUDIO
Download Azure Data Studio for MAC Apple silicon
connect with the server using the credentials specified while running the container.
Here is the video explanation