docker-compose.yaml 파일로 MSSQL Server 띄우기

IDE : Visual Studio Code

 

1. docker 버전 확인

PS C:\Users\admin\source\repos\SixMinAPI> docker --version
Docker version 20.10.14, build a224086

 

2. docker running container 확인

PS C:\Users\admin\source\repos\SixMinAPI> docker ps
CONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES

 

vs code에서 docker plugin 설치하여 확인 가능하다. 

 

3. .NET Project root에 docker-compose.yaml 파일 추가 

version: '3.8'
services:
  sqlserver:
    image: "mcr.microsoft.com/mssql/server:2019-latest"
    environment:
      ACCEPT_EULA : "Y"
      SA_PASSWORD: ""
      MSSQL_PID: "Express"
    ports:
      - "1433:1433"

4. docker-compose up -d 명령어로 docker container를 생성하고, 실행한다. 

PS C:\Users\admin\source\repos\SixMinAPI> docker-compose up -d
Creating network "sixminapi_default" with the default driver
Pulling sqlserver (mcr.microsoft.com/mssql/server:2019-latest)...
2019-latest: Pulling from mssql/server
5e51d371b4de: Pull complete
98f9a4e5d42f: Pull complete
239fcd477f4b: Pull complete
Status: Downloaded newer image for mcr.microsoft.com/mssql/server:2019-latest

5. SSMS를 실행하여 접속한다. 

계정 : sa / docker-compose.yaml 파일에 지정한 암호