When uploading valid images for Microsoft SQL Server "Container image configuration failed..." error is encountered

Products

• VMware Data Services Manager
• VMware Data Services Manager for VCF
• VMware Data Services Manager for VCF Private AI Services

Issue/Introduction

When using the "Upload Images" functionality to upload required Microsoft SQL Server images in .tar format an error is encountered

Container image configuration failed

Environment

DSM installs which support Microsoft SQL Server prior to DSM 9.1.1

Cause

In DSM versions prior to 9.1.1 only the Docker v1.0.0 image specification was supported. This meant that the tar files produced by newer container image export tooling, which uses the containered image store format, are not correctly recognised

 

Resolution

Prerequisites

• A Linux or macOS system with Docker installed on it
• The skopeo command line utility https://github.com/containers/skopeo installed

 

Converting newer images to a DSM compatible format

# Pull the required image to system e.g. for DSM 9.0.2

docker pull mcr.microsoft.com/mssql/server:2022-CU19-ubuntu-22.04

# Convert the file to DSM compatible earlier format

DOCKER_SOCK=$(docker context inspect $(docker context show) --format '{{.Endpoints.docker.Host}}')
skopeo copy \
--src-daemon-host "$DOCKER_SOCK" \
docker-daemon:mcr.microsoft.com/mssql/server:2022-CU19-ubuntu-22.04 \
docker-archive:sql_legacy.tar

 

The resulting sql_legacy.tar file can then be uploaded to DSM