{"id":1771,"date":"2022-12-10T13:43:59","date_gmt":"2022-12-10T12:43:59","guid":{"rendered":"https:\/\/www.klokocka.info\/?p=1771"},"modified":"2022-12-17T02:08:43","modified_gmt":"2022-12-17T01:08:43","slug":"install-ms-sql-server-2022-to-ubuntu-22-04-server-using-docker","status":"publish","type":"post","link":"https:\/\/www.klokocka.info\/?p=1771","title":{"rendered":"Install MS SQL Server 2022 to Ubuntu 22.04 server using Docker"},"content":{"rendered":"\n

Source Link1<\/a><\/strong>, Link2<\/a><\/strong> (MS documentation)<\/p>\n\n\n\n

And here<\/a><\/strong> is the link for standard (non-docker) instalation procedure of MSSQL 2022. This doesn’t work for now (12\/2022) because it is for ubuntu 20.04.<\/p>\n\n\n\n

Install Docker<\/p>\n\n\n\n

sudo apt update\nsudo apt-get install \\\n    ca-certificates \\\n    curl \\\n    gnupg \\\n    lsb-release<\/pre>\n\n\n\n
Add docker repository<\/p>\n\n\n\n
sudo mkdir -p \/etc\/apt\/keyrings\ncurl -fsSL https:\/\/download.docker.com\/linux\/ubuntu\/gpg | sudo gpg --dearmor -o \/etc\/apt\/keyrings\/docker.gpg\n\necho \\\n  \"deb [arch=$(dpkg --print-architecture) signed-by=\/etc\/apt\/keyrings\/docker.gpg] https:\/\/download.docker.com\/linux\/ubuntu \\\n  $(lsb_release -cs) stable\" | sudo tee \/etc\/apt\/sources.list.d\/docker.list > \/dev\/null<\/pre>\n\n\n\n
Update Ubuntu<\/p>\n\n\n\n
sudo apt update<\/pre>\n\n\n\n
Install Docker<\/p>\n\n\n\n
sudo apt-get install docker-ce docker-ce-cli containerd.io docker-compose-plugin<\/pre>\n\n\n\n
Run Docker & check if running<\/p>\n\n\n\n
sudo service docker start\nsudo service docker status<\/pre>\n\n\n\n
Install MSSQL2022 on Docker<\/p>\n\n\n\n
sudo docker pull mcr.microsoft.com\/mssql\/server:2022-latest<\/pre>\n\n\n\n
Create Docker container (Change STRONG password !!!)<\/p>\n\n\n\n
sudo docker run -e \"ACCEPT_EULA=Y\" -e \"MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>\" \\\n   -p 1433:1433 --name sql1 --hostname sql1 \\\n   -d \\\n   mcr.microsoft.com\/mssql\/server:2022-latest<\/pre>\n\n\n\n
Check if Docker container runs<\/p>\n\n\n\n
sudo docker ps -a<\/pre>\n\n\n\n
Start \/ Stop Docker container (start, restart, stop)<\/p>\n\n\n\n
sudo docker start sql1\nsudo docker stop sql1\n\/\/remove docker container\nsudo docker rm sql1<\/pre>\n\n\n\n
Setting docker container to start at system startup (Link<\/a><\/strong>, Link2<\/a><\/strong>)<\/p>\n\n\n\n
sudo docker run -d --restart unless-stopped sql1\nsudo docker update --restart unless-stopped sql1\n<\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Source Link1, Link2 (MS documentation) And here is the link for standard (non-docker) instalation procedure of MSSQL 2022. This doesn’t work for now (12\/2022) because it is for ubuntu 20.04. Install Docker Add docker repository Update Ubuntu Install Docker Run … Continued<\/a><\/p>\n","protected":false},"author":1,"featured_media":1763,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"kt_blocks_editor_width":"","pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[8],"tags":[],"class_list":["post-1771","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-nezarazene"],"_links":{"self":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/1771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1771"}],"version-history":[{"count":8,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/1771\/revisions"}],"predecessor-version":[{"id":1786,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/1771\/revisions\/1786"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/media\/1763"}],"wp:attachment":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}