docker-mssql

Install Microsoft SQL Server on Docker by Docker Compose.
Official Microsoft repository for SQL Server in Docker resources is here.

How to use

1. Clone this repository to a directory of your choice.

2. Move to the docker-mssql directory.

3. Execute the following command to start the container.

   docker compose up -d

4. Run the following command to confirm that the container has started.

   docker compose ps

Login to SQL Server

You can use SSMS (SQL Server Managemet Studio) or ADS (Azure Data Studio) to log in to the Docker container.
You can also use docker command to log-in to the container and run sqlcmd.

docker exec -it <your-container-id> "bash"
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "<YourNewStrong@Passw0rd>"

You can check the container ID with the docker ps command.

For more information on connecting to SQL Server on Docker using sqlcmd, see here.