Docker

Building the image for by docker-compose

go to docker-compose folder: Build docker images:

docker-compose build

Running the container

Then spin up a new container using docker-compose

docker-compose up

Note: add a -d to run the container in background

Connecting to MSSQL

server: localhost UserName: sa Password: RestAirline123

Connecting to the MSSQL container

To connect to the SQL Server in the container, you can docker exec with sqlcmd. The default password is RestAirline123 which defined in docker-compose.override.yml

docker exec -it restairline_mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P RestAirline123 -Q "select 1"