SQL Server 2017 locally with Docker - ORuban/openiddict-mobile GitHub Wiki

This page is mainly a quick overview on Run the SQL Server 2017 container image with Docker page. So the following steps are needed:

• Increase Docker memory to 4 GB

  • -> Select docker preferences (osx) / settings (windows)
  • -> Go to Advanced tab
  • -> Move the memory indicator to 4096 MB or more
  • -> Apply and restart docker

• Pull the container image from Docker Hub

docker pull microsoft/mssql-server-linux

• Run docker using the following command

docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourStrong!Passw0rd>' -e 'MSSQL_PID=Developer' --cap-add SYS_PTRACE -p 1401:1433 -d microsoft/mssql-server-linux

• Check that container status is UP

docker ps -a

---

Assuming that docker and OpenIdDic auth server are running on the same machine, the connection string that we will use is the following:

"ConnectionString": "Server=127.0.0.1,1401;Database=<database_name>;User Id=SA;Password=<YourStrong!Passw0rd>;"