docker mssql 2019 설치

 
 

 
 
 
설치환경

[root@darksharavim /]# cat /etc/redhat-release 
CentOS Linux release 7.9.2009 (Core)

 
 
MSSQL 설치

[root@darksharavim /]# docker pull mcr.microsoft.com/mssql/server:2019-latest

 
 
MSSQL 컨테이너 시작

[root@darksharavim /]# docker run \
-d \
-e 'ACCEPT_EULA=Y' \
-e 'SA_PASSWORD=<YourStrong@Passw0rd>' \
-p 1433:1433 \
--name mssql \
mcr.microsoft.com/mssql/server:2019-latest

 

docker-compose

version: '3.9'
services:
  mssql:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: mssql
    ports:
      - "1433:1433"
    environment:
      ACCEPT_EULA: "Y"           # 라이선스 동의
      SA_PASSWORD: "YourStrong@Password123" # 관리자 암호
    volumes:
      - mssql_data:/var/opt/mssql
volumes:
  mssql_data:
    driver: local
    

 
MSSQL 컨테이너 확인

[root@darksharavim ~]# docker ps -a
CONTAINER ID        IMAGE                                        COMMAND                  CREATED             STATUS                      PORTS                    NAMES
9856462f1a7c        mcr.microsoft.com/mssql/server:2019-latest   "/opt/mssql/bin/pe..."   16 minutes ago      Exited (1) 16 minutes ago                            mssql

 
 
MSSQL 컨테이너 확인

[root@darksharavim ~]# docker logs mssql
SQL Server 2019 will run as non-root by default.
This container is running as user mssql.
To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.
sqlservr: This program requires a machine with at least 2000 megabytes of memory.
/opt/mssql/bin/sqlservr: This program requires a machine with at least 2000 megabytes of memory.

메모리가 부족하여 발생한 문제 VM에 메모리를 2기가밖에 할당되지 않아 8기가로 증설 후 재기동
 

[root@darksharavim ~]# docker ps -a
CONTAINER ID        IMAGE                                        COMMAND                  CREATED             STATUS              PORTS                    NAMES
9856462f1a7c        mcr.microsoft.com/mssql/server:2019-latest   "/opt/mssql/bin/pe..."   22 minutes ago      Up 1 second         0.0.0.0:1433->1433/tcp   mssql

 
MSSQL컨테이너 접속

[root@darksharavim ~]# docker exec -it mssql bash

 
MSSQL 접속

[root@darksharavim ~]# docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "<YourStrong@Passw0rd>"
1>

 
참고문서
https://docs.microsoft.com/ko-kr/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash 

Docker: SQL Server on Linux의 컨테이너 설치 - SQL Server

 
MSSQL접속 클라이언트 설치
https://docs.microsoft.com/ko-kr/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 

SSMS(SQL Server Management Studio) 다운로드 - SQL Server Management Studio (SSMS)