I'm trying to create a docker image that contains MS SQL server, analysis services, and restore a db (bak) and a cube (abf). The Sql server part is the easy stuff, and I imagine that the restore will be too quite simple... the unsuccessful part is the installation of SSAS.

I've already tried without success:

  • Splitting images (1 for MSSQL and 1 for SSAS)
  • installing from the inside of a container with SQL Server installed

Any chance that anyone as done something similar or is "impossible" to achieve such a [working] image?

This is a clean sample of what I'm doing:

FROM mcr.microsoft.com/windows/servercore:1903

ENV exe "https://go.microsoft.com/fwlink/?linkid=840945"    
ENV box "https://go.microsoft.com/fwlink/?linkid=840944"

ENV sa_password="_" \
    attach_dbs="[]" \
    ACCEPT_EULA="_" \
    sa_password_path="C:\ProgramData\Docker\secrets\sa-password" \

SHELL ["powershell", "-Command", "$ErrorActionPreference = 'Stop'; $ProgressPreference = 'SilentlyContinue';"]


RUN Invoke-WebRequest -Uri $env:box -OutFile SQL.box ; \
        Invoke-WebRequest -Uri $env:exe -OutFile SQL.exe ; \
        Start-Process -Wait -FilePath .\SQL.exe -ArgumentList /qs, /x:setup ; \
        Remove-Item -Recurse -Force SQL.exe, SQL.box, setup

1 Answer 1


Windocks offers Windows SQL Server containes, and plans to release support for SSAS and SSIS early in 2020 (ie., Jan).

  • 1
    Do you have a source for this?
    – Neil P
    Feb 4, 2020 at 15:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.