Andrew Pruski takes us through one of the biggest changes with SQL Server 2019 in containers:
I’ve seen a few people online asking how to use docker named volumes with the new SQL Server 2019 RTM images. Microsoft changed the way SQL runs within a container for the RTM versions, SQL no longer runs as the root user.
This is a good thing but does throw up some issues when mounting volumes to create databases on.
Let’s run through what the issue is and how to overcome it.
Click through to see what you need to add to your DOCKERFILE to get things working.