Several docker images that support hosting Windows based applications in a reliable and production ready way.
Because of MSSQL Server EULA, the images containing the MSSQL binaries cannot be uploaded.
These all are unofficial, unsupported and in no way connected to Microsoft.
This repository contains multiple images that cannot be pushed to public repositories due to EULA of some of the software used in the build process. You will have to build and push them to a private repository in order to get started (or you can just test them locally)
Some of these images have dependencies between them.
There is a script to build and push all of the images to a private repository in the root, just run the buildall.ps1 script.
Make sure to replace the URL to your private repository in the script, and that you are authenticated to push images:
# Rename envsettings.ps1.template to envsettings.ps1 and complete build params
# https://github.com/microsoft/mssql-docker/issues/540
$Env:MSSQLINSTALL_ISO_URL = "https://xx.blob.core.windows.net/software/mssql.iso";
$Env:MSSQLINSTALL_CU_URL = "https://xx.blob.core.windows.net/software/cu.exe";
$Env:MSSQLINSTALL_CUFIX_URL = "https://xx.blob.core.windows.net/software/cufix.7z";
$ENV:REGISTRY_PATH = "myregistry.azurecr.io/core/"
$ENV:IMAGE_VERSION = "1.0.32";
$ENV:TESTS_SAS_URL = "https://xx.blob.core.windows.net/mytests";
# Build the images
.\buildall.ps1
# Build and push to the registry
.\buildall.ps1 -Push
# Build and run tests
.\buildall.ps1 -TestCore Windows Server 2022
Contains the container lifecycle management setup, plus basic tooling such as 7zip and micro.
See details here.
IIS Internet Information Services Base Image
Image with the basics for IIS hosting (including CGI and .NET 45/7/8), with support for SSL termination using CCS - Central Certificate Store.
See details here.
SQL Server 2022 With Full Text Search
Base image with SQL Server and Full Text Search feature.
See details here.
SQL Server 2022 With Full Text Search - For Kubernetes
Base image with SQL Server and Full Text Search feature, with configurable behaviour aimed at AKS/K8S deployments.
See details here.
Scripting in this image proposes several database lifecycle and backup automation, for seamless integration and production ready deployments on AKS or K8S.
SQL Server 2022 Analysis Services
SQL Server 2022 Analysis Services exposed through HTTP.
See details here.
SQL Server 2022 Integration Services
SQL Server Integration Services
To debug the powershell code in the different images, you use the helper method import functions:
. .\importfunctions.ps1
Just remember to call this method again every time you change the implementation of any of the helper functions.
The included azure pipeline integration needs the following variables:
| Name | Description |
|---|---|
| MSSQLINSTALL_CU_URL | Url to the cumulative update installer |
| MSSQLINSTALL_CUFIX_URL | Url to the cumulative update fix package (microsoft/mssql-docker#540) |
| MSSQLINSTALL_ISO_URL | Url to the MS SQL Server ISO image |
| REGISTRY_USER | Container registry username |
| REGISTRY_PWD | Container registry password |
| REGISTRY_PATH | Container registry URL with prefix, i.e. "myimages.azurecr.io/core" |
| TESTS_SAS_URL | An azure Blob Storage SAS URL, use during testing to verify backup and restore automation to Azure Blob |
The images are tagged in the registry using the branch/tag name of the current build.
You can have some control of how the build works using commit messages with the following keywords
| Keyword (must insert between square brackets []) | Purpose |
|---|---|
| notest | Skips the testing step |
| push | Pushes the images to the container registry. Not needed for tags, which are automatically pushed. |