{"id":9009,"date":"2022-06-01T16:32:15","date_gmt":"2022-06-01T14:32:15","guid":{"rendered":"https:\/\/via-internet.de\/blog\/?p=9009"},"modified":"2022-06-02T08:24:24","modified_gmt":"2022-06-02T06:24:24","slug":"daily-running-microsoft-sql-server-in-docker","status":"publish","type":"post","link":"https:\/\/via-internet.de\/blog\/2022\/06\/01\/daily-running-microsoft-sql-server-in-docker\/","title":{"rendered":"Daily: Running Microsoft SQL-Server in Docker"},"content":{"rendered":"\n

Introduction<\/h2>\n\n\n\n

Using Docker is an effortless way to launch and run an application\/server software without annoying installation hassles: Just run the image and you’re done.<\/em><\/p>\n\n\n\n

Even if it’s quite an uncomplicated way of looking at it, in many cases it works just like that.<\/p>\n\n\n\n

So, let’s start with using Microsoft SQL Server as a database backend. We will use a docker image from Microsoft. Look here to find <\/a>out more.<\/p>\n\n\n\n

docker\trun                                       \\\n\t\t\t--name mssql-server       \\\n\t\t\t--memory 4294967296       \\\t\n\t\t\t-e \"ACCEPT_EULA=Y\"        \\\n\t\t\t-e \"SA_PASSWORD=secret\"   \\\n\t\t\t-p 1433:1433              \\\n\t\t\tmcr.microsoft.com\/mssql\/server:2019-latestles<\/pre>\n\n\n\n
FAQ<\/h2>\n\n\n\n
Error: program requires a machine with at least 2000 megabytes of memory<\/h3>\n\n\n\n
Start the docker container as described on the Docker Hub Page: How to use this Image <\/a><\/p>\n\n\n\n
\u276f docker run -e \"ACCEPT_EULA=Y\" -e \"SA_PASSWORD=secret\" -p 1433:1433 mcr.microsoft.com\/mssql\/server:2022-latest<\/pre>\n\n\n\n
Depending on how your docker environment is configured, this could bring up an error:<\/p>\n\n\n\n
SQL Server 2019 will run as non-root by default.\nThis container is running as user mssql.\nTo learn more visit https:\/\/go.microsoft.com\/fwlink\/?linkid=2099216.\nsqlservr: This program requires a machine with at least 2000 megabytes of memory.\n\/opt\/mssql\/bin\/sqlservr: This program requires a machine with at least 2000 megabytes of memory.<\/pre>\n\n\n\n
As the error message states, the MS SQL server needs at least 2g of RAM. So, you must assign your Docker VMs more memory. This is configured in the Docker Dashboard.<\/p>\n\n\n\n
Hint: Docker has two ways of running containers:<\/p>\n\n\n\n
  • using Windows Container<\/li>
  • using WSL (Windows Subsystem for Linux)<\/li><\/ul>\n\n\n\n
    You can change the way with the context menu of the docker symbol in the task bar:<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    With Linux Containers (using WSL as backend), you must configure the containers via a file .wslconfig<\/code>.<\/p>\n\n\n\n
    This file is in the folder defined by the environment variable \n\n\n\n
    \"\"<\/figure>\n\n\n\n
    To open the file, run the command:<\/p>\n\n\n\n
    From Command Prompt<\/td>notepad \n\n\n\n
    Edit the content and change the memory setting<\/p>\n\n\n\n
    [wsl2]\nmemory=3GB<\/pre>\n\n\n\n
    Restart WSL with the new settings.<\/p>\n\n\n\n
    \u276f wsl --shutdown<\/pre>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    Start Container again, now everything should work<\/p>\n\n\n\n
    \u276f docker run -e \"ACCEPT_EULA=Y\" -e \"SA_PASSWORD=secret\" -p 1433:1433 mcr.microsoft.com\/mssql\/server:2022-latest<\/pre>\n","protected":false},"excerpt":{"rendered":"
    Introduction Using Docker is an effortless way to launch and run an application\/server software without annoying installation hassles: Just run the image and you’re done. Even if it’s quite an uncomplicated way of looking at it, in many cases it works just like that. So, let’s start with using Microsoft SQL Server as a database backend. We will use a docker image from Microsoft. Look here to find out more. FAQ Error: program requires a machine with at least 2000 megabytes of memory Start the docker container as described on the Docker Hub Page: How to use this Image Depending on […]<\/p>\n","protected":false},"author":1,"featured_media":9016,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[135,102],"tags":[133,134],"class_list":["post-9009","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-daily","category-power-shell","tag-daily","tag-powershell"],"jetpack_featured_media_url":"https:\/\/via-internet.de\/blog\/wp-content\/uploads\/2022\/06\/Header-Daily-Running-Microsoft-SQL-Server-in-Docker.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9009","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/comments?post=9009"}],"version-history":[{"count":7,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9009\/revisions"}],"predecessor-version":[{"id":9032,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/posts\/9009\/revisions\/9032"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media\/9016"}],"wp:attachment":[{"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/media?parent=9009"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/categories?post=9009"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/via-internet.de\/blog\/wp-json\/wp\/v2\/tags?post=9009"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}