SQl Server in Docker

Introduction

This documentation shows you how you can configure a SQL Server 2019 Docker container.

Steps:

Start Ubuntu or any Linux

Ensure that Docker is installed on your Linux.

Start Docker by following command

sudo systemctl start docker

or

sudo service docker start

Verify docker status

sudo service docker status

Pull SQL Server 2019 Image:

Open a terminal or command prompt and run the following command to pull the SQL Server 2019 Docker image from the official Microsoft Container Registry

docker pull mcr.microsoft.com/mssql/server:2019-latest

Run the following command to start a new SQL Server container:

docker run -v mssql-volume -e 'ACCEPT_EULA=Y' -e "SA_PASSWORD=Pass123!" -p 1433:1433 --name sqlserver -d mcr.microsoft.com/mssql/server:2019-latest

Check if the container is running by using the following command:

docker ps

To connect to sql server do following

- Open ssms
- enter server name as 127.0.0.1
- username as sa
- password as Pass123!

Finally you can access sql server in docker.