Microsoft SQL Server On Docker (Best Way!)

SQL Server On Docker: In this article will show you, how to install Microsoft SQL Server on docker (Image). This is very easy and simple to do it, also I have shown will complete videos guide which you will find in the article at the bottom of the page. 

Getting Started Checklist

SQL Server On Docker

Step 1: Hope you have went to this below link and have downloaded Docker on your machine (Windows/Mac/Linux) 

Microsoft SQL Server On Docker

Step 2: Open and install the Docker setup file and you can see in the below image 

Microsoft SQL Server On Docker

Step 3: Open the Docker application and go to terminal at the bottom of the Docker application 

Microsoft SQL Server On Docker

Step 4: Run this below command in this terminal to get the Microsoft SQL Server On Docker. For more about 4th and 5th step please click on this link: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&tabs=cli&pivots=cs1-bash

docker pull mcr.microsoft.com/mssql/server:2022-latest 
Microsoft SQL Server On Docker

Step 5: Now we have to put his image into container to make use of this and run the MS SQL Server to query the database. 

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Password123!" -p 1433:1433 --name sql1 --hostname sql1 -d mcr.microsoft.com/mssql/server:2022-latest 
docker

Step 6: Now our Microsoft SQL Server On Docker is up and running. You can use any of visual tool to query the database like SSMS, Azure Data Studio and Visual Studio Code (MSSQL Extension). 

In my case I am going to use Azure Data Studio to connect to SQL Server which is hosted on Docker Container. 

Step 7: Download and install azure data studio from this link: https://learn.microsoft.com/en-us/azure-data-studio/download-azure-data-studio?tabs=win-install%2Cwin-user-install%2Credhat-install%2Cwindows-uninstall%2Credhat-uninstall 

Step 8: Open studio and click on connection on the top first option. Create new connection and give the value as mentioned below 

Microsoft SQL Server On Docker

Step 9: Now we are good to use our Microsoft SQL Server On Docker to query or create new database. 

Microsoft SQL Server On Docker

Watch!

TSG’s

  1. Postman: AAS Model Refresh Using REST API
  2. RDCMan Scaling Is Blurry: Fix In 3 Steps (kingfishertechtips.in)
  3. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  4. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  5. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  6. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  7. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  8. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  9. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  10. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  11. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  12. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  13. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  14. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  15. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  16. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  17. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 112

Leave a Reply

Your email address will not be published. Required fields are marked *