{"id":6313,"date":"2019-07-11T06:00:11","date_gmt":"2019-07-10T21:00:11","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=6313"},"modified":"2021-05-31T13:25:42","modified_gmt":"2021-05-31T04:25:42","slug":"sql-server-2017-%e3%81%ab%e3%83%aa%e3%83%a2%e3%83%bc%e3%83%88%e6%8e%a5%e7%b6%9a%e3%81%99%e3%82%8b%e3%81%ab%e3%81%af","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=6313","title":{"rendered":"SQL Server 2017 \u306b\u30ea\u30e2\u30fc\u30c8\u63a5\u7d9a\u3059\u308b\u306b\u306f"},"content":{"rendered":"\n<p>\u3000SQL Server \u306b\u30ed\u30fc\u30ab\u30eb\u7aef\u672b\u3067\u63a5\u7d9a\u3059\u308b\u306e\u306f\u7c21\u5358\u3067\u3042\u308b\uff0e\u3057\u304b\u3057\u521d\u5fc3\u8005\u306b\u3068\u3063\u3066\u306f LAN \u7d4c\u7531\u3067\u96a3\u306e\u7aef\u672b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f SQL Server \u306b\u63a5\u7d9a\u3059\u308b\u306e\u3055\u3048\u96e3\u3057\u3044\uff0e<\/p>\n<p>\u3000\u56db\u82e6\u516b\u82e6\u3057\u3066\u4f55\u3068\u304b\u305f\u3069\u308a\u7740\u3044\u305f\u60c5\u5831\u3092\u5fd8\u308c\u306a\u3044\u3046\u3061\u306b\u66f8\u304d\u8a18\u3057\u3066\u304a\u304f\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>SQL Server \u304c Windows \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3042\u308b\u5834\u5408<\/h2>\n<h3>SQL Server Configuration Manager \u3092\u63a2\u305b<\/h3>\n<p>\u3000\u307e\u305f\u306e\u540d\u3092 SQL Server \u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\u3068\u3044\u3046\uff0e\u3053\u308c\u3092\u63a2\u3059\u65b9\u6cd5\u306b\u306f\u3044\u304f\u3064\u304b\u3042\u308b\uff0e<\/p>\n<ol>\n<li>\u300c\u691c\u7d22\u300d\u30c0\u30a4\u30a2\u30ed\u30b0\u306b SQLServerManager \u3068\u30bf\u30a4\u30d7\u3059\u308b<\/li>\n<li>\u300c\u30b9\u30bf\u30fc\u30c8\u300d\u30e1\u30cb\u30e5\u30fc\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u306e\u7ba1\u7406\u300d\u3092\u958b\u304f<\/li>\n<\/ol>\n<figure id=\"attachment_6316\" aria-describedby=\"caption-attachment-6316\" style=\"width: 810px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/51.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6316\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/51.png\" alt=\"SQL Server\u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3, SQL Server Configuration Manager, SQLServerManager\" width=\"810\" height=\"415\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/51.png 810w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/51-300x154.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/51-768x393.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-6316\" class=\"wp-caption-text\">SQL Server\u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3, SQL Server Configuration Manager, SQLServerManager<\/figcaption><\/figure>\n<h3>TCP\/IP\u306e\u6709\u52b9\u5316<\/h3>\n<p>\u3000SQL Server \u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\u304c\u8d77\u52d5\u3059\u308b\u306e\u3067\uff0c\u300cSQL Server \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u69cb\u6210\u300d\u304b\u3089\u300cMSSQLSERVER \u306e\u30d7\u30ed\u30c8\u30b3\u30eb\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\uff0c\u53f3\u5074\u306e\u30da\u30a4\u30f3\u306b\u30d7\u30ed\u30c8\u30b3\u30eb\u540d\u3068\u72b6\u614b\u304c\u8868\u793a\u3055\u308c\u308b\uff0e<\/p>\n<p>\u3000\u6700\u5f8c\u306e TCP\/IP \u304c\u300c\u7121\u52b9\u300d\u3068\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u306e\u3067\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u6709\u52b9\u5316\u300d\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_6315\" aria-describedby=\"caption-attachment-6315\" style=\"width: 946px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6315\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/33.png\" alt=\"SQL Server\u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\/SQL Server Configuration Manager\/SQLServerManager \u306e\u753b\u9762\uff0eTCP\/IP \u304c\u7121\u52b9\u306a\u306e\u3067\u6709\u52b9\u5316\u3059\u308b\" width=\"946\" height=\"715\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/33.png 946w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/33-300x227.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/33-768x580.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-6315\" class=\"wp-caption-text\">SQL Server\u69cb\u6210\u30de\u30cd\u30fc\u30b8\u30e3\/SQL Server Configuration Manager\/SQLServerManager \u306e\u753b\u9762\uff0eTCP\/IP \u304c\u7121\u52b9\u306a\u306e\u3067\u6709\u52b9\u5316\u3059\u308b<\/figcaption><\/figure>\n<h3>SQL Server \u3092\u518d\u8d77\u52d5\u3059\u308b<\/h3>\n<p>\u3000\u8b66\u544a\u304c\u51fa\u308b\u306e\u3067\u300c\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u306e\u7ba1\u7406\u300d\u304b\u3089 SQL Server \u3092\u518d\u8d77\u52d5\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_6317\" aria-describedby=\"caption-attachment-6317\" style=\"width: 401px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/34.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6317\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/34.png\" alt=\"\u52a0\u3048\u305f\u5909\u66f4\u306f\u3059\u3079\u3066\u4fdd\u5b58\u3055\u308c\u307e\u3059\uff0e\u305f\u3060\u3057\uff0c\u30b5\u30fc\u30d3\u30b9\u3092\u505c\u6b62\u3057\u3066\u518d\u958b\u3059\u308b\u307e\u3067\uff0c\u305d\u306e\u5909\u66f4\u306f\u6709\u52b9\u306b\u306a\u308a\u307e\u305b\u3093\" width=\"401\" height=\"152\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/34.png 401w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/34-300x114.png 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/a><figcaption id=\"caption-attachment-6317\" class=\"wp-caption-text\">\u52a0\u3048\u305f\u5909\u66f4\u306f\u3059\u3079\u3066\u4fdd\u5b58\u3055\u308c\u307e\u3059\uff0e\u305f\u3060\u3057\uff0c\u30b5\u30fc\u30d3\u30b9\u3092\u505c\u6b62\u3057\u3066\u518d\u958b\u3059\u308b\u307e\u3067\uff0c\u305d\u306e\u5909\u66f4\u306f\u6709\u52b9\u306b\u306a\u308a\u307e\u305b\u3093<\/figcaption><\/figure>\n<figure id=\"attachment_6318\" aria-describedby=\"caption-attachment-6318\" style=\"width: 987px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6318\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/42.png\" alt=\"\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u306e\u7ba1\u7406\u304b\u3089SQL Server\u3092\u518d\u8d77\u52d5\u3059\u308b\" width=\"987\" height=\"708\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/42.png 987w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/42-300x215.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/42-768x551.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-6318\" class=\"wp-caption-text\">\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u306e\u7ba1\u7406\u304b\u3089SQL Server\u3092\u518d\u8d77\u52d5\u3059\u308b<\/figcaption><\/figure>\n<h3>SQL Server Browser \u3092\u63a2\u305b<\/h3>\n<p>\u3000\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u306e\u7ba1\u7406\u304b\u3089 SQL Server Browser \u3092\u63a2\u3057\uff0c\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u958b\u304f\uff0e<\/p>\n<figure id=\"attachment_6319\" aria-describedby=\"caption-attachment-6319\" style=\"width: 986px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/46.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6319\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/46.png\" alt=\"SQL Server Browser\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u958b\u304f\" width=\"986\" height=\"708\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/46.png 986w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/46-300x215.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/46-768x551.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><figcaption id=\"caption-attachment-6319\" class=\"wp-caption-text\">SQL Server Browser\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u958b\u304f<\/figcaption><\/figure>\n<h3>SQL Server Browser \u3092\u6709\u52b9\u5316\u3059\u308b<\/h3>\n<p>\u3000\u30d7\u30ed\u30d1\u30c6\u30a3\u5168\u822c\u3067\u300c\u30b9\u30bf\u30fc\u30c8\u30a2\u30c3\u30d7\u306e\u7a2e\u985e\u300d\u304c\u300c\u7121\u52b9\u300d\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\uff0c\u300c\u81ea\u52d5\u300d\u306b\u5909\u66f4\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_6320\" aria-describedby=\"caption-attachment-6320\" style=\"width: 472px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/47.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6320\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/47.png\" alt=\"SQL Server Browser\u306f\u521d\u671f\u72b6\u614b\u3067\u306f\u7121\u52b9\u306b\u306a\u3063\u3066\u3044\u308b\" width=\"472\" height=\"533\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/47.png 472w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/47-266x300.png 266w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/a><figcaption id=\"caption-attachment-6320\" class=\"wp-caption-text\">SQL Server Browser\u306f\u521d\u671f\u72b6\u614b\u3067\u306f\u7121\u52b9\u306b\u306a\u3063\u3066\u3044\u308b<\/figcaption><\/figure>\n<p>\u3000\u300c\u30b5\u30fc\u30d3\u30b9\u306e\u72b6\u614b\u300d\u306f\u300c\u505c\u6b62\u300d\u306e\u307e\u307e\u3060\u304c\uff0c\u300c\u958b\u59cb\u300d\u30dc\u30bf\u30f3\u304c\u62bc\u305b\u308b\u3088\u3046\u306b\u306a\u308b\u306e\u3067\uff0c\u300c\u958b\u59cb\u300d\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_6321\" aria-describedby=\"caption-attachment-6321\" style=\"width: 472px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/49.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6321\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/49.png\" alt=\"SQL Server Browser\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u958b\u59cb\u3059\u308b\" width=\"472\" height=\"533\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/49.png 472w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/49-266x300.png 266w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/a><figcaption id=\"caption-attachment-6321\" class=\"wp-caption-text\">SQL Server Browser\u306e\u30b5\u30fc\u30d3\u30b9\u3092\u958b\u59cb\u3059\u308b<\/figcaption><\/figure>\n<h2>SQL Server \u304c Ubuntu \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3042\u308b\u5834\u5408<\/h2>\n<p>\u3000Ubuntu \u7aef\u672b\u3092\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b5\u30fc\u30d0\u30fc\u306b\u3057\u3066 Windows \u7aef\u672b\u304b\u3089\u30ea\u30e2\u30fc\u30c8\u63a5\u7d9a\u3059\u308b\u5834\u5408\u3092\u60f3\u5b9a\u3057\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000<a href=\"https:\/\/masayukiozawa.github.io\/sol-skillupdate\/\" target=\"_blank\" rel=\"noopener noreferrer\">Windows \u30a8\u30f3\u30b8\u30cb\u30a2\u5411\u3051 SQL Server on Linux \u306e\u305f\u3081\u306e\u30b9\u30ad\u30eb\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8<\/a>\u306b\u8a73\u7d30\u304c\u63b2\u8f09\u3055\u308c\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000\u516c\u5f0f\u30b5\u30a4\u30c8\u306f<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/sql\/linux\/sql-server-linux-manage-ssms?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">Windows \u4e0a\u306e SQL Server Management Studio \u3092\u4f7f\u7528\u3057\u3066\u3001Linux \u4e0a\u306e SQL Server \u3092\u7ba1\u7406\u3059\u308b\u306b\u306f<\/a>\uff0e\u65e5\u672c\u8a9e\u8a33\u304c\u304a\u304b\u3057\u3044\u304c\uff0c\u884c\u9593\u304b\u3089\u610f\u5473\u3092\u6c72\u307f\u53d6\u3063\u3066\u307b\u3057\u3044\uff0e<\/p>\n<h3>Ubuntu Server 16.04.6 LTS \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h3>\n<p>\u3000<a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-admin\/post.php?post=6293\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu Server 16.04.6 LTS \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/a>\u3092\u53c2\u7167\u3055\u308c\u305f\u3057\uff0e<\/p>\n<h3>Ubuntu \u306b SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/h3>\n<p>\u3000\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\u4ed6\u306b\u3082\u691c\u7d22\u3059\u308b\u3068\u8272\u3005\u51fa\u3066\u304f\u308b\uff0e<\/p>\n<p>\u3000<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=6347\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu \u306b SQL Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/a>\u306b\u3082\u8a18\u4e8b\u3092\u66f8\u3044\u305f\uff0e<\/p>\n<h3>Ubuntu \u3067\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u306e\u69cb\u6210\u3092\u884c\u3046<\/h3>\n<p>\u3000Ubuntu \u7aef\u672b\u306e IP \u30a2\u30c9\u30ec\u30b9\u3092\u78ba\u8a8d\u3059\u308b\uff0e<\/p>\n<p><del><code>$ ipconfig<\/code><\/del><\/p>\n<pre class=\"lang:vbnet decode:true\">$ ip address show<\/pre>\n<p>\u30002021 \u5e745 \u6708 31 \u65e5\u8a02\u6b63\uff0e\u30b3\u30de\u30f3\u30c9\u540d\u3092\u9593\u9055\u3048\u3066\u3044\u305f\u306e\u3067\u8a02\u6b63\u3059\u308b\uff0e<\/p>\n<h3>Ubuntu \u3067 TCP\/IP \u30dd\u30fc\u30c8\u306e 1433 \u756a\u3092\u958b\u3051\u308b<\/h3>\n<pre>$ sudo ufw allow 1433\/tcp<\/pre>\n<p>\u3000\u7ba1\u7406\u8005\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u805e\u304b\u308c\u308b\u306e\u3067\u5165\u529b\u3059\u308b\uff0e\u3053\u3053\u306f Ubuntu \u306e\u30d5\u30a1\u30a4\u30e4\u30fc\u30a6\u30a9\u30fc\u30eb\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3057\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000SQL Server \u3067\u306f TCP \u30dd\u30fc\u30c8\u306e 1433 \u756a\u3092\u7528\u3044\u308b\u305f\u3081\u3067\u3042\u308b\uff0e<\/p>\n<h3>Windows \u7aef\u672b\u3067 SQL Server Management Studio \u3092\u8d77\u52d5\u3059\u308b<\/h3>\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>\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a\u3067\u30b5\u30fc\u30d0\u30fc\u540d\u306bIP\u30a2\u30c9\u30ec\u30b9\u3092\u5165\u529b\u3059\u308b<\/h3>\n<p>\u3000\u300c\u30b5\u30fc\u30d0\u30fc\u540d\u300d\u306b\u306f Ubuntu \u7aef\u672b\u306e IP \u30a2\u30c9\u30ec\u30b9\u3092\u76f4\u63a5\u5165\u529b\u3067\u304d\u308b\uff0e\u3053\u306e IP \u30a2\u30c9\u30ec\u30b9\u306f DHCP \u8cc7\u6e90\u914d\u5e03\u306e\u305f\u3073\u306b\u5207\u308a\u66ff\u308f\u308b\uff0e\u56fa\u5b9a IP \u30a2\u30c9\u30ec\u30b9\u3092\u6307\u5b9a\u3067\u304d\u308c\u3070\u3088\u3044\u306e\u3060\u304c\uff0c\u3053\u308c\u306f\u4eca\u5f8c\u306e\u8ab2\u984c\u3060\uff0e<\/p>\n<h3>\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a\u3067\u8a8d\u8a3c\u306f SQL Server \u8a8d\u8a3c\u306e\u4e00\u629e\u3067\u3042\u308b<\/h3>\n<p>\u3000\u8a8d\u8a3c\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306f Windows \u8a8d\u8a3c\u3060\u304c\uff0cSQL Server \u8a8d\u8a3c\u306b\u5909\u66f4\u3059\u308b\uff0e<\/p>\n<h3>\u30ed\u30b0\u30a4\u30f3\u306f SA, \u30d1\u30b9\u30ef\u30fc\u30c9\u306f Ubuntu \u5074\u306e SQL Server \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u969b\u306e\u3082\u306e\u3092\u5165\u529b<\/h3>\n<p>\u3000\u30ed\u30b0\u30a4\u30f3\u540d\u306f SA \u3068\u30bf\u30a4\u30d7\u3057\uff0c\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3059\u308b\uff0e<\/p>\n<h3>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u8868\u793a\u3055\u308c\u308c\u3070\u63a5\u7d9a\u3067\u304d\u3066\u3044\u308b<\/h3>\n<p>\u3000\u3088\u304f\u5206\u304b\u3089\u306a\u3044\u304c\uff0c\u63a5\u7d9a\u3067\u304d\u305f\uff0e\u4eca\u5f8c\u306f\u3053\u3053\u306b\u5b9f\u969b\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u3066\u3044\u304f\u3053\u3068\u306b\u306a\u308b\uff0e<\/p>\n<figure id=\"attachment_6334\" aria-describedby=\"caption-attachment-6334\" style=\"width: 257px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/61.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6334\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/61.png\" alt=\"\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u306b Ubuntu \u306e SQL Server \u304c\u8868\u793a\u3055\u308c\u305f\" width=\"257\" height=\"257\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/61.png 257w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/61-150x150.png 150w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/06\/61-100x100.png 100w\" sizes=\"auto, (max-width: 257px) 100vw, 257px\" \/><\/a><figcaption id=\"caption-attachment-6334\" class=\"wp-caption-text\">\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u30fc\u306b Ubuntu \u306e SQL Server \u304c\u8868\u793a\u3055\u308c\u305f<\/figcaption><\/figure>\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=5a18b65b3fdfd540428dcaecd4206822&amp;language=ja_JP\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" 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\" border=\"0\"><\/a><img loading=\"lazy\" decoding=\"async\" style=\"border: none !important; margin: 0px !important;\" 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\" alt=\"\" width=\"1\" height=\"1\" border=\"0\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000SQL Server \u306b\u30ed\u30fc\u30ab\u30eb\u7aef\u672b\u3067\u63a5\u7d9a\u3059\u308b\u306e\u306f\u7c21\u5358\u3067\u3042\u308b\uff0e\u3057\u304b\u3057\u521d\u5fc3\u8005\u306b\u3068\u3063\u3066\u306f LAN \u7d4c\u7531\u3067\u96a3\u306e\u7aef\u672b\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f SQL Server \u306b\u63a5\u7d9a\u3059\u308b\u306e\u3055\u3048\u96e3\u3057\u3044\uff0e \u3000\u56db\u82e6\u516b\u82e6\u3057\u3066\u4f55\u3068\u304b\u305f\u3069\u308a\u7740\u3044\u305f\u60c5\u5831\u3092\u5fd8\u308c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=6313\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;SQL Server 2017 \u306b\u30ea\u30e2\u30fc\u30c8\u63a5\u7d9a\u3059\u308b\u306b\u306f&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[4264,4265,11177,4262,4253,4268,2740,4254,4246,2750,4252,4247,4267,4248,4250,4181,1807,2762,4249,4259,4256,4178,4255,4263,4244,4245,4260,447,4129,4266,4251,4257,4258],"class_list":{"0":"post-6313","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-technology","7":"tag-4264","8":"tag-dhcp","9":"tag-ip-address-show","10":"tag-ip","11":"tag-mssqlserver-","12":"tag-sa","13":"tag-sql-server","14":"tag-sql-server-browser","15":"tag-sql-server-configuration-manager","16":"tag-sql-server-management-studio","20":"tag-sqlservermanager","21":"tag-tcp-ip","22":"tag-ubuntu","23":"tag-windows","25":"tag-4249","26":"tag-4259","27":"tag-4256","28":"tag-4178","29":"tag-4255","30":"tag-4263","31":"tag-4244","32":"tag-4245","33":"tag-4260","34":"tag-447","35":"tag-4129","37":"tag-4251","38":"tag-4257","39":"tag-4258"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6313","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=6313"}],"version-history":[{"count":29,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6313\/revisions"}],"predecessor-version":[{"id":14458,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/6313\/revisions\/14458"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}