To start SQL Server on background via Docker just type:
docker compose up -d
Main parametrs can be modified via .env
file.
Default configuration:
IMAGE: mcr.microsoft.com/mssql/server:2022-latest
CONTAINER NAME: sqlserver
USER: sa
PASSWORD: A123456*
PORT: 1433 (default for SQL Server)
Data are persisted locally:
./volumes/mssql/data
Connection via SQL Server Management Studio:
Server type: Database Engine
Server name: localhost
Authentication: SQL Server Authentication
Login: sa
Password: A123456*
Docker network:
sqlserver