{"id":6347,"date":"2019-07-04T06:00:57","date_gmt":"2019-07-03T21:00:57","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=6347"},"modified":"2019-06-20T15:31:15","modified_gmt":"2019-06-20T06:31:15","slug":"ubuntu-%e3%81%ab-sql-server-%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=6347","title":{"rendered":"Ubuntu \u306b SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b"},"content":{"rendered":"\n<p>\u3000Ubuntu \u74b0\u5883\u306b SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5\u3092\u66f8\u304d\u8a18\u3057\u3066\u304a\u304f\uff0e\u516c\u5f0f\u30b5\u30a4\u30c8\u306f<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/linux\/quickstart-install-connect-ubuntu?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">\u30af\u30a4\u30c3\u30af \u30b9\u30bf\u30fc\u30c8: Ubuntu \u306b SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210<\/a>\u3067\u3042\u308b\uff0e<\/p>\n<p><!--more--><\/p>\n<h3>SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u308b\u306e\u306f Ubuntu 16.04<\/h3>\n<p>\u3000SQL Server \u3092\u5b9f\u884c\u3067\u304d\u308b Ubuntu \u306f 16.04 \u3067\u3042\u308b\uff0e\u305f\u3060\uff0c\u3053\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f 2021 \u5e74\u307e\u3067\u3057\u304b\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u306a\u3044\uff0e\u305d\u306e\u3046\u3061 Microsoft \u3067\u5bfe\u5fdc\u3057\u3066\u304f\u308c\u308b\u306e\u3092\u5f85\u3064\u4ed6\u306a\u3044\uff0e<\/p>\n<h3>\u30d1\u30d6\u30ea\u30c3\u30af\u30ea\u30dd\u30b8\u30c8\u30ea GPG \u30ad\u30fc\u3092\u30a4\u30f3\u30dd\u30fc\u30c8<\/h3>\n<p><code>$ wget -qO- https:\/\/packages.microsoft.com\/keys\/microsoft.asc | sudo apt-key add -<\/code><\/p>\n<h3>SQL Server \u306e Ubuntu \u30ea\u30dd\u30b8\u30c8\u30ea\u3092\u767b\u9332<\/h3>\n<p><code>$ sudo add-apt-repository \"$(wget -qO- https:\/\/packages.microsoft.com\/config\/ubuntu\/16.04\/mssql-server-2017.list)\"<\/code><\/p>\n<h3>SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h3>\n<p><code>$ sudo apt-get update\n<\/code><\/p>\n<p><code>$ sudo apt-get install -y mssql-server<\/code><\/p>\n<h3>\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7<\/h3>\n<p><code>$ sudo \/opt\/mssql\/bin\/mssql-conf setup<\/code><\/p>\n<h3>SA \u30d1\u30b9\u30ef\u30fc\u30c9\u306e\u8a2d\u5b9a\u3068\u30a8\u30c7\u30a3\u30b7\u30e7\u30f3\u306e\u9078\u629e<\/h3>\n<p>\u3000\u3053\u3053\u3067\u8a2d\u5b9a\u3057\u305f\u30d1\u30b9\u30ef\u30fc\u30c9\u306f Windows \u7aef\u672b\u304b\u3089\u30ea\u30e2\u30fc\u30c8\u63a5\u7d9a\u3059\u308b\u969b\u306b\u4f7f\u3046\uff0e\u8a8d\u8a3c\u306f Windows \u8a8d\u8a3c\u3067\u306f\u306a\u304f SQL Server \u8a8d\u8a3c\u3067\u3042\u308b\uff0e<\/p>\n<figure id=\"attachment_6332\" aria-describedby=\"caption-attachment-6332\" style=\"width: 477px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/60.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6332\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/60.png\" alt=\"SQL Server Management Studio\u304b\u3089\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a\" width=\"477\" height=\"293\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/60.png 477w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/60-300x184.png 300w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/a><figcaption id=\"caption-attachment-6332\" class=\"wp-caption-text\">SQL Server Management Studio\u304b\u3089\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a<\/figcaption><\/figure>\n<h3>\u30d5\u30a1\u30a4\u30a2\u30a6\u30a9\u30fc\u30eb\u306e TCP \u30dd\u30fc\u30c8\u3092\u958b\u304f<\/h3>\n<p><code>$ sudo ufw allow 1433\/tcp<\/code><\/p>\n<p><a href=\"https:\/\/www.amazon.co.jp\/gp\/product\/4798155764\/ref=as_li_ss_il?ie=UTF8&amp;psc=1&amp;linkCode=li3&amp;tag=gwho-22&amp;linkId=a7670a2906efc98302555647c0928b34&amp;language=ja_JP\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" border=\"0\" src=\"\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=4798155764&amp;Format=_SL250_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=gwho-22&amp;language=ja_JP\"><\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=gwho-22&amp;language=ja_JP&amp;l=li3&amp;o=9&amp;a=4798155764\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000Ubuntu \u74b0\u5883\u306b SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u65b9\u6cd5\u3092\u66f8\u304d\u8a18\u3057\u3066\u304a\u304f\uff0e\u516c\u5f0f\u30b5\u30a4\u30c8\u306f\u30af\u30a4\u30c3\u30af \u30b9\u30bf\u30fc\u30c8: Ubuntu \u306b SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3067\u3042\u308b\uff0e<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4270,266,4268,2740,4267,4273,4181,2762,2667,2861,4127,2741,4217,4272,4269,4244],"class_list":{"0":"post-6347","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-resistance-training","7":"tag-gpg","8":"tag-microsoft","9":"tag-sa","10":"tag-sql-server","12":"tag-tcp","13":"tag-ubuntu","14":"tag-windows","15":"tag-2667","16":"tag-2861","17":"tag-4127","18":"tag-2741","19":"tag-4217","20":"tag-4272","21":"tag-4269","22":"tag-4244"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6347"}],"version-history":[{"count":4,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6347\/revisions"}],"predecessor-version":[{"id":6351,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6347\/revisions\/6351"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}