2021-05-14
1223
#docker
Kyle Galbraith
3794
May 14, 2021 â‹… 4 min read

How to run SQL Server in a Docker container

Kyle Galbraith Software engineer and entrepreneur. Love traveling and experiencing life. kylegalbraith.com/learn-aws.

Recent posts:

docker exit code 1

How to troubleshoot exit code 1 in Docker

exit code 1 is one of the most common and frustrating errors for developers working in Docker. Explore what it means and how to fix it.

Ukeje Goodness
Apr 1, 2025 â‹… 4 min read
next js link component

How to use the Next.js Link component to optimize navigation

With features like automatic prefetching and seamless integration with dynamic routing, Link helps you create a fast and responsive web application.

Chimezie Innocent
Mar 31, 2025 â‹… 5 min read
tanstack table react table

A complete guide to TanStack Table (formerly React Table)

Discover how to use TanStack Table, formerly known as React Table, to build a table UI for a variety of use cases.

Paramanantham Harrison
Mar 28, 2025 â‹… 14 min read
javascript object prototypes

JavaScript prototypes: How objects inherit properties and methods

Explore what prototypes are, how the prototype chain works, and how to use the prototype chain to create inheritance between objects.

Ibadehin Mojeed
Mar 28, 2025 â‹… 7 min read
View all posts

8 Replies to "How to run SQL Server in a Docker container"

  1. SA_PASSWORD: “change_this_password” as shown on the docker-compose.yml file did not work for me and container logs had the following message:

    2019-07-17 14:19:20.63 spid31s ERROR: Unable to set system administrator password: Password validation failed. The password does not meet SQL Server password policy requirements because it is not complex enough. The password must be at least 8 characters long and contain characters from three of the following four sets: Uppercase letters, Lowercase letters, Base 10 digits, and Symbols..
    2019-07-17 14:19:20.63 spid31s An error occurred during server setup. See previous errors for more information.

  2. It seems that you need to change your password with something complex that fulfills the given criteria. “AEdCC.b9” should work I guess.

  3. Can you tell me which npm package you are using and what version? I tried `npm i -g mssql` but that will not take the arguments you describe, it says no such file -u.

  4. where does the Data and log files stored? If it is inside the container by default, how can we map to the host MacOs volume?

    How do we backup the database to outside of the container?

Leave a Reply