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

 

 

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)