Andrew Pruski shows how to store a credential using Powershell and pass it into a Docker container:
I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears is that SQL Server in containers does not support Windows authentication (unless you’re using Windocks).
So when I’m working I find it quite annoying to have to specify a SA username & password when I want to connect.
OK, I can use Get-Credential, assign to a variable, and then reference that in a connection string but I want something a bit more permanent especially as I always use the same password for all my containers
Read on for Andrew’s method, and check out Rob Sewell’s method in the comments.