{"id":20517,"date":"2021-05-14T06:16:35","date_gmt":"2021-05-14T13:16:35","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azuregov\/?p=20517"},"modified":"2021-05-14T12:37:55","modified_gmt":"2021-05-14T19:37:55","slug":"sql-server-2019-on-rhel8-container-now-available-on-iron-bank-dods-centralized-artifacts-repository","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azuregov\/sql-server-2019-on-rhel8-container-now-available-on-iron-bank-dods-centralized-artifacts-repository\/","title":{"rendered":"SQL Server 2019 on RHEL8 container now available on Iron Bank-DoD\u2019s Centralized Artifacts Repository"},"content":{"rendered":"<p><span data-contrast=\"auto\">Today we announce the general availability of the <span class=\"TextRun SCXW249047396 BCX8\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW249047396 BCX8\">SQL Server 2019 on RHEL8 container <\/span><\/span>image available for consumption from the Department of Defense&#8217;s Centralized Artifacts Repository (DCAR), also known as\u00a0<\/span><a href=\"https:\/\/ironbank.dso.mil\/\"><span data-contrast=\"none\">Platform One\u2019s\u00a0Iron Bank<\/span><\/a><span data-contrast=\"auto\">.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">With this availability, SQL Server container images can now be used in highly-controlled environments, such as federal government, DoD, and Defense Industrial Base organizations, where the prerequisite to leverage any container image is that it must be hardened and accredited. <span class=\"TextRun BCX8 SCXW54288225\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX8 SCXW54288225\">Check out the container image on Iron Bank\u00a0<\/span><\/span><a class=\"Hyperlink BCX8 SCXW54288225\" href=\"https:\/\/ironbank.dso.mil\/repomap\/microsoft\/microsoft\" target=\"_blank\" rel=\"noreferrer noopener\"><span class=\"TextRun Underlined BCX8 SCXW54288225\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\"><span class=\"NormalTextRun BCX8 SCXW54288225\" data-ccp-charstyle=\"Hyperlink\">here<\/span><\/span><\/a><span class=\"TextRun BCX8 SCXW54288225\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun BCX8 SCXW54288225\">.<\/span><\/span><\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Iron Bank automates, secures, and accelerates the approval process of commercial and open source containers to be used within the DoD with DoD-wide reciprocity. Through the Iron Bank submission process, the SQL container image has undergone numerous hardening cycles against multiple DoD security benchmarks including those provided by the OpenSCAP,\u00a0Twistlock\u00a0and\u00a0Anchore\u00a0vulnerability and CVE scanners,\u00a0which are the key requirements for an\u00a0image to be enlisted on DoD&#8217;s Iron Bank.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">SQL Server is a modern data platform that meets the needs of today&#8217;s challenging world of massive data, a diverse set of data sources, and the need for near real-time application and query performance.<\/span><span data-contrast=\"auto\">\u00a0The core SQL Server engine remains the same irrespective of the platform\/OS\/environment\/container image that you choose to run SQL Server on. Additionally, the <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/troubleshoot\/sql\/general\/support-policy-sql-server#sql-server-running-in-linux-containers\"><span data-contrast=\"none\">support policy guidelines<\/span><\/a><span data-contrast=\"auto\">, supported feature set, and release cadence will remain the same. The core difference of the hardened SQL container versus the traditional SQL container is the base OS RHEL 8.3 image used for the former image is a hardened <\/span><a href=\"https:\/\/ironbank.dso.mil\/repomap\/redhat\/ubi\"><span data-contrast=\"none\">RHEL 8 UBI image<\/span><\/a><span data-contrast=\"auto\">\u00a0from\u00a0Iron\u00a0Bank,\u00a0instead of the traditional UBI image.\u00a0To learn more,\u00a0see\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-overview?view=sql-server-ver15\"><span data-contrast=\"auto\">SQL Server on Linux<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:257}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Follow these steps to get started using the SQL Server 2019 hardened container image:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">1. Log in to <\/span><a href=\"https:\/\/registry1.dso.mil\/harbor\/\"><span data-contrast=\"none\">registry1.dso.mil<\/span><\/a><span data-contrast=\"auto\">\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul style=\"list-style-type: circle;\">\n<li><span data-contrast=\"auto\">If you do not have an account, please\u00a0register\u00a0<\/span><a href=\"https:\/\/login.dso.mil\/register\"><span data-contrast=\"none\">here<\/span><\/a><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">2. Use docker\/podman to download the image leveraging the following commands: <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul style=\"list-style-type: circle;\">\n<li><span data-contrast=\"auto\">podman login<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li style=\"list-style-type: none;\">\n<ol style=\"list-style-type: lower-roman;\">\n<li><span data-contrast=\"auto\">Username: &lt;your Registry1 username&gt;<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:1620,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Password: &lt;the CLI secret provided in the User Profile on\u00a0<\/span><a href=\"https:\/\/registry1.dso.mil\/harbor\/projects\"><span data-contrast=\"none\">Harbor<\/span><\/a><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:1620,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">&gt;<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<ul style=\"list-style-type: circle;\">\n<li><span data-contrast=\"auto\">podman pull registry1.dso.mil\/ironbank\/microsoft\/microsoft\/microsoft-sql-server-2019-rhel8<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">3. Lastly, use <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-docker-container-deployment?view=sql-server-ver15&amp;pivots=cs1-bash\"><span data-contrast=\"none\">these commands<\/span><\/a><span data-contrast=\"auto\">\u00a0to deploy the SQL container<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">If you have any\u00a0questions\u00a0on your hardened SQL deployment,\u00a0please reach out to\u00a0us\u00a0using one of the channels\u00a0listed\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/troubleshoot\/sql\/general\/support-policy-sql-server#obtain-support-from-microsoft\"><span data-contrast=\"none\">here<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">And,\u00a0be sure to\u00a0stay tuned for more Microsoft container releases to Iron Bank\u00a0coming soon!<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server container images can\u00a0now\u00a0be used in\u00a0highly-controlled\u00a0environments, such as\u00a0federal\u00a0government,\u00a0DoD,\u00a0and Defense Industrial Base\u00a0organizations,\u00a0where the prerequisite to\u00a0leverage\u00a0any container image\u00a0is\u00a0that\u00a0it\u00a0must be\u00a0hardened and accredited.\u00a0To get started, you\u00a0can\u00a0download\u00a0the container image from Iron Bank.\u00a0<\/p>\n","protected":false},"author":57253,"featured_media":20520,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[262,3442,523,3441,526],"class_list":["post-20517","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azuregov","tag-dod","tag-iron-bank","tag-sql","tag-sql-container","tag-sql-server"],"acf":[],"blog_post_summary":"<p>SQL Server container images can\u00a0now\u00a0be used in\u00a0highly-controlled\u00a0environments, such as\u00a0federal\u00a0government,\u00a0DoD,\u00a0and Defense Industrial Base\u00a0organizations,\u00a0where the prerequisite to\u00a0leverage\u00a0any container image\u00a0is\u00a0that\u00a0it\u00a0must be\u00a0hardened and accredited.\u00a0To get started, you\u00a0can\u00a0download\u00a0the container image from Iron Bank.\u00a0<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/20517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/users\/57253"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/comments?post=20517"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/posts\/20517\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media\/20520"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/media?parent=20517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/categories?post=20517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azuregov\/wp-json\/wp\/v2\/tags?post=20517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}