Portainer Templates

SQL Server Express

Database

Microsoft SQL Server Express for Windows containers

Type Container Platform windows Image microsoft/mssql-server-windows-express:latest Ports

1433/tcp

Volumes

C:/temp/

Env Vars

ACCEPT_EULA=Ysa_password=''

Installation

Via Portainer

  1. Ensure both Docker and Portainer are installed, and up-to-date
  2. Log into your Portainer web UI
  3. Under Settings → App Templates, paste the below URL
  4. Head to Home → App Templates, and the list of apps will show up
  5. Select the app you wish to deploy, fill in any config options, and hit Deploy

Template Import URL

https://raw.githubusercontent.com/Lissy93/portainer-templates/main/templates.json
Show Me demo

Via Docker Run

docker run -d \ 
  -p 1433/tcp \
  -e ACCEPT_EULA=${ACCEPT_EULA} \
  -e sa_password=${sa_password} \
  -v undefined:C:/temp/ \
  microsoft/mssql-server-windows-express:latest

Via Docker Compose

Save this file as docker-compose.yml and run docker-compose up -d
Use this only as a guide. 

version: '3.8'
services:
  sql-server-express:
    image: microsoft/mssql-server-windows-express:latest
    ports:
      - 1433:tcp
    environment:
      ACCEPT_EULA: ''
      sa_password: ''
    volumes:
      - ':C:/temp/'

Alternative Methods

For more installation options, see the Documentation in the GitHub repo