/docker-mssql

MIT LicenseMIT

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

    Mounting a volume does not work on Docker for Mac. In case of macOS environment, please comment out the volumes part.

  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.