Docker MSSQL

add-test-server-with-user.sh

#!/bin/bash
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -Q "CREATE DATABASE TestDatabase"
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -Q "CREATE LOGIN testuser WITH PASSWORD = '***'"
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -d TestDatabase -Q "CREATE USER testuser FOR LOGIN testuser"
docker exec sql-server /opt/mssql-tools/bin/sqlcmd -U sa -P *** -d TestDatabase -Q "ALTER ROLE db_owner ADD MEMBER testuser"

create-volumes.sh

#!/bin/bash
docker volume create sql-server-system
docker volume create sql-server-user

start-sql-server.sh

#!/bin/bash
docker run \
  --volume sql-server-system:/var/opt/mssql \
  --volume sql-server-user:/var/opt/sqlserver \
  -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=***" \
  -e "MSSQL_RPC_PORT=135" -e "MSSQL_DTC_TCP_PORT=51000" \
  -p 1433:1433 -p 135:135 -p 51000:51000 \
  --name sql-server \
  --detach --rm mcr.microsoft.com/mssql/server:2022-latest