[mssql] dockerCompose

[Lexaul]

參考資料：https://github.com/microsoft/mssql-docker/issues/615
https://harry-lin.blogspot.com/2019/02/ ... linux.html

#docker-compose.yml

代碼: 選擇全部

version: '3.8'

services:
  mssql2019:
    image: mcr.microsoft.com/mssql/server:2019-latest
    restart: 'no'
    container_name: mssql2019
    ports:
      - 1433:1433
    volumes:
      - ./mssql:/var/opt/mssql
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=Sql.72838914
      - MSSQL_PID=Developer

常見錯誤

SQL-Server 2019 docker container fails to start with -v option

Setup proper directory owner (mssql)

Check id for mssql user on docker image

代碼: 選擇全部

sudo docker run -it mcr.microsoft.com/mssql/server id mssql

gives: uid=10001(mssql) gid=0(root) groups=0(root)

Change folder's owner

代碼: 選擇全部

sudo chown 10001 VOLUME_DIRECTORY

Source in spanish: https://www.eiximenis.dev/posts/2020-06 ... a-en-root/