{"id":29967,"date":"2020-03-19T09:00:34","date_gmt":"2020-03-19T16:00:34","guid":{"rendered":""},"modified":"2024-01-22T22:51:24","modified_gmt":"2024-01-23T06:51:24","slug":"how-to-provision-a-linux-sql-server-virtual-machine-in-azure","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/","title":{"rendered":"How to provision a Linux SQL Server Virtual Machine in Azure"},"content":{"rendered":"

You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered. With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.<\/p>\n

For our purposes, I\u2019m going to walk through how to use the Azure portal to create a Linux virtual machine with SQL Server 2017 or 2019 installed. If you\u2019re following along, you\u2019ll need an Azure subscription. If you don\u2019t already have one, sign up for an Azure free account<\/u><\/a>. Alternatively, if you know which options you’re going to select, you can create a Linux virtual machine with the Azure command-line interface<\/a>. Or, if you want to learn more about the benefits of SQL Server in Azure, download Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators<\/a>.<\/em><\/p>\n

First, we\u2019ll create a Linux virtual machine with SQL Server installed:<\/p>\n

    \n
  1. Sign in to the Azure portal.<\/li>\n
  2. Select Create a resource, and then Compute.<\/li>\n
  3. Next to the Featured heading, select See all.<\/li>\n
  4. In the search box, type SQL Server 2019, and select Enter.<\/li>\n
  5. You can limit the search results by operating system. To do so, select Operating system > Red Hat.<\/li>\n
  6. Select a SQL Server 2019 image from the search results.<\/li>\n
  7. Select Create.<\/li>\n<\/ol>\n

    The next step is to set up your Linux virtual machine:<\/p>\n

      \n
    1. In the Basics tab, select your Subscription and Resource Group.<\/li>\n
    2. In virtual machine name, enter a name for your new Linux virtual machine.<\/li>\n
    3. Type or select the following, based on your requirements such as region, availability options, and change size.<\/li>\n
    4. For authentication type, select SSH public key. (SSH is more secure than a password.)<\/li>\n
    5. For username, enter the administrator\u2019s name.<\/li>\n
    6. For SSH public key, enter your Rivest\u2013Shamir\u2013Adleman (RSA) public key.<\/li>\n
    7. For public inbound ports, choose allow selected ports and choose the SSH (22) port in the select public inbound ports.<\/li>\n
    8. You can change or keep the default settings for disks, networking, management, guest configuration, and tags.<\/li>\n
    9. Select Review and Create, and then select Create.<\/li>\n<\/ol>\n

      Next, connect to the Linux virtual machine. If you use a BASH shell, connect to the Azure virtual machine using the SSH command. In the following command, replace the virtual machine username and IP address to connect to your Linux virtual machine, and you can find the IP address of your virtual machine in the Azure portal:<\/p>\n

      ssh azureadmin@40.55.55.555<\/p>\n

      If you don\u2019t have a BASH shell, install an SSH client like PuTTY.<\/p>\n

      The new virtual machine installs SQL Server with a random system administrator (SA) password, so you’ll need to reset the password before connecting to SQL Server with the system administrator login:<\/p>\n

        \n
      1. After connecting to the Linux virtual machine, open a new command terminal.<\/li>\n
      2. Change the system administrator password with the following commands:<\/li>\n<\/ol>\n

        sudo systemctl stop mssql-server<\/p>\n

        sudo \/opt\/mssql\/bin\/mssql-conf set-sa-password<\/p>\n

        When prompted, enter a new system administrator password and password confirmation.<\/p>\n

          \n
        1. Finally, restart the SQL Server service:<\/li>\n<\/ol>\n

          sudo systemctl start mssql-server<\/p>\n

          You\u2019ve just provisioned a SQL Server 2017 virtual machine in Azure! You can connect to it locally with sqlcmd to run Transact-SQL queries or you can configure the Azure virtual machine for remote SQL Server connections<\/a>. The best part is, you now have a full version of SQL Server in the cloud. There\u2019s no need to manage on-premises hardware or secure the budget to procure and manage that hardware. Plus, the images are pay-as-you-go, so you only pay for what you use.<\/p>\n

          To learn more about moving your databases to the cloud, download Future-Proof Your Data Infrastructure with Azure: A Business Case for Database Administrators <\/a>or check out the SQL Server on RHEL Azure VMs Operations Guide<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

          You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered. With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2406,2536,2418],"content-type":[2424],"topic":[],"coauthors":[2487],"class_list":["post-29967","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2017","product-sql-server-2019","product-sql-server-on-linux","content-type-best-practices"],"yoast_head":"\nHow to provision a Linux SQL Server Virtual Machine in Azure - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to provision a Linux SQL Server Virtual Machine in Azure - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered. With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-19T16:00:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"How to provision a Linux SQL Server Virtual Machine in Azure\",\"datePublished\":\"2020-03-19T16:00:34+00:00\",\"dateModified\":\"2024-01-23T06:51:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/\"},\"wordCount\":636,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/\",\"name\":\"How to provision a Linux SQL Server Virtual Machine in Azure - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2020-03-19T16:00:34+00:00\",\"dateModified\":\"2024-01-23T06:51:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to provision a Linux SQL Server Virtual Machine in Azure\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to provision a Linux SQL Server Virtual Machine in Azure - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/","og_locale":"en_US","og_type":"article","og_title":"How to provision a Linux SQL Server Virtual Machine in Azure - Microsoft SQL Server Blog","og_description":"You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered. With SQL Server 2017, and now SQL Server 2019, SQL Server is available on Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2020-03-19T16:00:34+00:00","article_modified_time":"2024-01-23T06:51:24+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"How to provision a Linux SQL Server Virtual Machine in Azure","datePublished":"2020-03-19T16:00:34+00:00","dateModified":"2024-01-23T06:51:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/"},"wordCount":636,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/","name":"How to provision a Linux SQL Server Virtual Machine in Azure - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2020-03-19T16:00:34+00:00","dateModified":"2024-01-23T06:51:24+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2020\/03\/19\/how-to-provision-a-linux-sql-server-virtual-machine-in-azure\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"How to provision a Linux SQL Server Virtual Machine in Azure"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/29967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=29967"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/29967\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=29967"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=29967"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=29967"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=29967"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=29967"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=29967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}