{"id":2342,"date":"2025-01-07T11:03:04","date_gmt":"2025-01-07T11:03:04","guid":{"rendered":"https:\/\/www.klokocka.info\/?p=2342"},"modified":"2025-01-14T13:36:07","modified_gmt":"2025-01-14T13:36:07","slug":"mssql-docker-on-ubuntu-24-04","status":"publish","type":"post","link":"https:\/\/www.klokocka.info\/?p=2342","title":{"rendered":"MSSQL Docker on Ubuntu 24.04."},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Install ndocker engine<\/h2>\n\n\n\n<p><a href=\"https:\/\/docs.docker.com\/engine\/install\/ubuntu\/#install-using-the-repository\">https:\/\/docs.docker.com\/engine\/install\/ubuntu\/#install-using-the-repository<\/a><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># Add Docker's official GPG key:\nsudo apt-get update\nsudo apt-get install ca-certificates curl\nsudo install -m 0755 -d \/etc\/apt\/keyrings\nsudo curl -fsSL https:\/\/download.docker.com\/linux\/ubuntu\/gpg -o \/etc\/apt\/keyrings\/docker.asc\nsudo chmod a+r \/etc\/apt\/keyrings\/docker.asc\n\n# Add the repository to Apt sources:\necho \\\n  \"deb [arch=$(dpkg --print-architecture) signed-by=\/etc\/apt\/keyrings\/docker.asc] https:\/\/download.docker.com\/linux\/ubuntu \\\n  $(. \/etc\/os-release &amp;&amp; echo \"$VERSION_CODENAME\") stable\" | \\\n  sudo tee \/etc\/apt\/sources.list.d\/docker.list > \/dev\/null\nsudo apt-get update\n\n# To install latest version of docker\nsudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin\n\n# Test doscker engine\nsudo docker run hello-world<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Install SQL Server<\/h2>\n\n\n\n<p><a href=\"https:\/\/orcacore.com\/ms-sql-server-docker-ubuntu22\/\">https:\/\/orcacore.com\/ms-sql-server-docker-ubuntu22\/<\/a><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># Pull the docker\nsudo docker pull mcr.microsoft.com\/mssql\/server:2022-latest\n\n#Create Container\nsudo docker run -e \"ACCEPT_EULA=Y\" \\\n-e \"MSSQL_SA_PASSWORD=Kleopatra@#4886\" \\\n-p 1433:1433 --name sql1 --hostname sql1 \\\n-d mcr.microsoft.com\/mssql\/server:2022-latest\n\n# -v \/home\/webserver\/mssql:\/var\/opt\/mssql microsoft\/mssql-server-linux \\\n\n# Test \nsudo docker ps -a<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Connect<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">#Start an interactive shell inside your SQL server container by using the command below:\nsudo docker exec -it sql1 \"bash\"\n\n#Then, use the following command tool sqlcmd to connect to your shell:\n# -No = encryption optional\n\/opt\/mssql-tools18\/bin\/sqlcmd -S localhost -U SA -P \"p_a_s_s_w_o_r_d\" -No\n\n# And then in sqlcmd\n1> SELECT Name from sys.databases;\n2> GO\nquit\n\n#exit docker bash\nexit<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server agent<\/h2>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># Enable SQL Server agent\n# 1) Start an interactive shell \nsudo docker exec -it --user root sql1 \"bash\"\n# 2) Enable agent inside shell\n\/opt\/mssql\/bin\/mssql-conf set sqlagent.enabled true\n# 3) Exit docker bash\nexit\n# 4) Restart SQL docker\nsudo docker restart sql1<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Azure Data Studio<\/h2>\n\n\n\n<p><a href=\"https:\/\/learn.microsoft.com\/en-us\/azure-data-studio\/download-azure-data-studio?tabs=linux-install%2Cwin-user-install%2Cubuntu-install%2Cwindows-uninstall%2Credhat-uninstall#linux-installation\">https:\/\/learn.microsoft.com\/en-us\/azure-data-studio\/download-azure-data-studio?tabs=linux-install%2Cwin-user-install%2Cubuntu-install%2Cwindows-uninstall%2Credhat-uninstall#linux-installation<\/a><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\"># Download it with browser:\n#https:\/\/azuredatastudio-update.azurewebsites.net\/latest\/linux-deb-x64\/stable\n\ncd ~\nsudo dpkg -i .\/Downloads\/azuredatastudio-linux-&lt;!!! VERSION STRING !!!>.deb\n\nazuredatastudio\n\n#Then install extension Admin Pack for SQL Server (to see Agent in Manage)\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Install ndocker engine https:\/\/docs.docker.com\/engine\/install\/ubuntu\/#install-using-the-repository Install SQL Server https:\/\/orcacore.com\/ms-sql-server-docker-ubuntu22\/ Connect SQL Server agent Azure Data Studio https:\/\/learn.microsoft.com\/en-us\/azure-data-studio\/download-azure-data-studio?tabs=linux-install%2Cwin-user-install%2Cubuntu-install%2Cwindows-uninstall%2Credhat-uninstall#linux-installation<\/p>\n","protected":false},"author":1,"featured_media":2343,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"kt_blocks_editor_width":"","pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-2342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/2342","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=2342"}],"version-history":[{"count":8,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/2342\/revisions"}],"predecessor-version":[{"id":2396,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/posts\/2342\/revisions\/2396"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=\/wp\/v2\/media\/2343"}],"wp:attachment":[{"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.klokocka.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}