mssql-docker/windows/mssql-server-windows-developer/ Docker image not existing anymore on Docker Hub

[jkockx]

Hi

Recently I tried to use a Windows container for Microsoft SQL server inside my CI pipeline to deploy a dacpac based project to the container and run unit tests using tSQLt.

For this, I tried to pull the docker image described on mssql-docker/windows/mssql-server-windows-developer/). However this resulted in following error message. pull access denied for microsoft/mssql-server-windows-developer, repository does not exist or may require 'docker login': denied: requested access to the resource is denied I use a docker file with FROM microsoft/mssql-server-windows-developer

Is it possible that the image is not available anymore on Docker Hub? And if so, why has this been removed? And how can I still use a Windows based SQL image when I want to avoid using unofficial (non-msft) images?

Kind regards

[tracker1]

I'm not an MS employee, but will state, that I wouldn't rely on Windows container images at all... they were never very well supported, and version compatibility was painful at best.

You should be able to use a mssql-tools[1] container if you like. Note, you may have issues if your file cases don't match your filesystem casing on a case-sensitive file system (all caps, iirc).

1. https://hub.docker.com/_/microsoft-mssql-tools

[pabechevb]

You can create your own container following the steps described in this guide: https://www.mssqltips.com/sqlservertip/7093/install-sql-server-install-oracle-powershell-windows-containers/

[dzsquared]

https://techcommunity.microsoft.com/t5/sql-server-blog/update-beta-program-for-sql-server-on-windows-container-is/ba-p/2516639

[urielrodriguezusma]

This image could be useful for local tests image: mcr.microsoft.com/azure-sql-edge environment: SA_PASSWORD: "mypassword" ACCEPT_EULA: "Y"
ports: - 5434:1433 networks: - yournetwork volumes: - mssql-volume:/var/opt/mssql