{"id":958,"date":"2017-10-25T11:33:47","date_gmt":"2017-10-25T11:33:47","guid":{"rendered":"http:\/\/www.dbafox.com\/?p=958"},"modified":"2019-05-03T06:14:21","modified_gmt":"2019-05-03T05:14:21","slug":"sql-serverlinux-install-sql-server-2017-on-linux","status":"publish","type":"post","link":"https:\/\/dbafox.com\/?p=958","title":{"rendered":"SQL Server\/Linux &#8211; Install SQL Server 2017 on Linux"},"content":{"rendered":"<p>\nMicrosoft document: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/quickstart-install-connect-red-hat\" rel=\"noopener\" target=\"_blank\">Install SQL Server on Linux<\/a><\/p>\n<pre class=\"toolbar-overlay:false lang:sh decode:true \" >[root@oralintest ~]# curl -o \/etc\/yum.repos.d\/mssql-server.repo https:\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server.repo\r\n\r\n[root@oralintest ~]# yum install mssql-server\r\n...\r\nInstalled:\r\nmssql-server.x86_64 0:14.0.900.75-1\r\n\r\nComplete!\r\n[root@oralintest ~]# \/opt\/mssql\/bin\/mssql-conf setup\r\nThe license terms for this product can be found in\r\n\/usr\/share\/doc\/mssql-server or downloaded from:\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=852741&clcid=0x409\r\n\r\nThe privacy statement can be viewed at:\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=853010&clcid=0x409\r\n\r\nDo you accept the license terms? [Yes\/No]:Yes\r\n\r\nChoose an edition of SQL Server:\r\n  1) Evaluation (free, no production use rights, 180-day limit)\r\n  2) Developer (free, no production use rights)\r\n  3) Express (free)\r\n  4) Web (PAID)\r\n  5) Standard (PAID)\r\n  6) Enterprise (PAID)\r\n  7) I bought a license through a retail sales channel and have a product key to enter.\r\n\r\nDetails about editions can be found at\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=852748&clcid=0x409\r\n\r\nUse of PAID editions of this software requires separate licensing through a\r\nMicrosoft Volume Licensing program.\r\nBy choosing a PAID edition, you are verifying that you have the appropriate\r\nnumber of licenses in place to install and run this software.\r\n\r\nEnter your edition(1-7): 1\r\nEnter the SQL Server system administrator password:\r\nConfirm the SQL Server system administrator password:\r\nConfiguring SQL Server...\r\n\r\nThis is an evaluation version.  There are [90] days left in the evaluation period.\r\nThe licensing PID was successfully processed. The new edition is [Enterprise Evaluation Edition].\r\nCreated symlink from \/etc\/systemd\/system\/multi-user.target.wants\/mssql-server.service to \/usr\/lib\/systemd\/system\/mssql-server.service.\r\nSetup has completed successfully. SQL Server is now starting.\r\n[root@oralintest ~]#\r\n\r\n[root@oralintest ~]# curl -o \/etc\/yum.repos.d\/msprod.repo https:\/\/packages.microsoft.com\/config\/rhel\/7\/prod.repo\r\n\r\n[root@oralintest ~]# yum install -y mssql-tools unixODBC-devel\r\n...\r\nInstalling : msodbcsql-13.1.9.1-1.x86_64                                                                                                                                 2\/4\r\n...\r\nInstalled:\r\n  mssql-tools.x86_64 0:14.0.6.0-1                                                     unixODBC-devel.x86_64 0:2.3.1-11.el7\r\n\r\n[root@oralintest ~]# export PATH=\"$PATH:\/opt\/mssql-tools\/bin\"\r\n[root@oralintest ~]# firewall-cmd --zone=public --add-port=1433\/tcp --permanent\r\nsuccess\r\n[root@oralintest ~]# firewall-cmd --reload\r\nsuccess\r\n[root@oralintest ~]# sqlcmd -S localhost -U SA\r\nPassword:\r\n1> use master;\r\n2> go\r\nChanged database context to 'master'.\r\n1> select @@version\r\n2> go\r\n                                                                                                                                                                               \r\n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\r\nMicrosoft SQL Server 2017 (RC2) - 14.0.900.75 (X64)\r\n        Jul 27 2017 08:53:49\r\n        Copyright (C) 2017 Microsoft Corporation\r\n        Enterprise Evaluation Edition (64-bit) on Linux (Oracle Linux Server 7.4)                                                                                              \r\n\r\n(1 rows affected)\r\n\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft document: Install SQL Server on Linux [root@oralintest ~]# curl -o \/etc\/yum.repos.d\/mssql-server.repo https:\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server.repo [root@oralintest ~]# yum install mssql-server &#8230; Installed: mssql-server.x86_64 0:14.0.900.75-1 Complete! [root@oralintest ~]# \/opt\/mssql\/bin\/mssql-conf setup The license terms for this product can be found in \/usr\/share\/doc\/mssql-server or downloaded &hellip; <a href=\"https:\/\/dbafox.com\/?p=958\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pgc_sgb_lightbox_settings":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,24],"tags":[],"class_list":["post-958","post","type-post","status-publish","format-standard","hentry","category-linux","category-ms-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server\/Linux - Install SQL Server 2017 on Linux - dbafox<\/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:\/\/dbafox.com\/?p=958\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server\/Linux - Install SQL Server 2017 on Linux - dbafox\" \/>\n<meta property=\"og:description\" content=\"Microsoft document: Install SQL Server on Linux [root@oralintest ~]# curl -o \/etc\/yum.repos.d\/mssql-server.repo https:\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server.repo [root@oralintest ~]# yum install mssql-server ... Installed: mssql-server.x86_64 0:14.0.900.75-1 Complete! [root@oralintest ~]# \/opt\/mssql\/bin\/mssql-conf setup The license terms for this product can be found in \/usr\/share\/doc\/mssql-server or downloaded &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbafox.com\/?p=958\" \/>\n<meta property=\"og:site_name\" content=\"dbafox\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-25T11:33:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-05-03T05:14:21+00:00\" \/>\n<meta name=\"author\" content=\"Ray Fox\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ray Fox\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbafox.com\/?p=958\",\"url\":\"https:\/\/dbafox.com\/?p=958\",\"name\":\"SQL Server\/Linux - Install SQL Server 2017 on Linux - dbafox\",\"isPartOf\":{\"@id\":\"https:\/\/dbafox.com\/#website\"},\"datePublished\":\"2017-10-25T11:33:47+00:00\",\"dateModified\":\"2019-05-03T05:14:21+00:00\",\"author\":{\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\"},\"breadcrumb\":{\"@id\":\"https:\/\/dbafox.com\/?p=958#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbafox.com\/?p=958\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbafox.com\/?p=958#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbafox.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server\/Linux &#8211; Install SQL Server 2017 on Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbafox.com\/#website\",\"url\":\"https:\/\/dbafox.com\/\",\"name\":\"dbafox\",\"description\":\"DBA Technical Information\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbafox.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb\",\"name\":\"Ray Fox\",\"sameAs\":[\"http:\/\/www.dbafox.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server\/Linux - Install SQL Server 2017 on Linux - dbafox","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:\/\/dbafox.com\/?p=958","og_locale":"en_GB","og_type":"article","og_title":"SQL Server\/Linux - Install SQL Server 2017 on Linux - dbafox","og_description":"Microsoft document: Install SQL Server on Linux [root@oralintest ~]# curl -o \/etc\/yum.repos.d\/mssql-server.repo https:\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server.repo [root@oralintest ~]# yum install mssql-server ... Installed: mssql-server.x86_64 0:14.0.900.75-1 Complete! [root@oralintest ~]# \/opt\/mssql\/bin\/mssql-conf setup The license terms for this product can be found in \/usr\/share\/doc\/mssql-server or downloaded &hellip; Continue reading &rarr;","og_url":"https:\/\/dbafox.com\/?p=958","og_site_name":"dbafox","article_published_time":"2017-10-25T11:33:47+00:00","article_modified_time":"2019-05-03T05:14:21+00:00","author":"Ray Fox","twitter_misc":{"Written by":"Ray Fox","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dbafox.com\/?p=958","url":"https:\/\/dbafox.com\/?p=958","name":"SQL Server\/Linux - Install SQL Server 2017 on Linux - dbafox","isPartOf":{"@id":"https:\/\/dbafox.com\/#website"},"datePublished":"2017-10-25T11:33:47+00:00","dateModified":"2019-05-03T05:14:21+00:00","author":{"@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb"},"breadcrumb":{"@id":"https:\/\/dbafox.com\/?p=958#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbafox.com\/?p=958"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbafox.com\/?p=958#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbafox.com\/"},{"@type":"ListItem","position":2,"name":"SQL Server\/Linux &#8211; Install SQL Server 2017 on Linux"}]},{"@type":"WebSite","@id":"https:\/\/dbafox.com\/#website","url":"https:\/\/dbafox.com\/","name":"dbafox","description":"DBA Technical Information","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbafox.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/dbafox.com\/#\/schema\/person\/287adc474c1aebd398752ac4dcfe27eb","name":"Ray Fox","sameAs":["http:\/\/www.dbafox.com"]}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ecMb-fs","_links":{"self":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=958"}],"version-history":[{"count":9,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/958\/revisions"}],"predecessor-version":[{"id":1429,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/posts\/958\/revisions\/1429"}],"wp:attachment":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}