{"id":104,"date":"2019-11-01T14:19:52","date_gmt":"2019-11-01T06:19:52","guid":{"rendered":"http:\/\/47.104.236.141\/?p=104"},"modified":"2020-07-02T16:09:26","modified_gmt":"2020-07-02T08:09:26","slug":"centos7-6-%e5%ae%89%e8%a3%85-ms-sqlserver-2017","status":"publish","type":"post","link":"http:\/\/www.linux-dba.com\/index.php\/2019\/11\/104\/","title":{"rendered":"CentOS7.6 \u5b89\u88c5 ms-sqlserver-2017"},"content":{"rendered":"<p><strong>\u53c2\u8003\u7f51\u5740<\/strong><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/zh-cn\/sql\/linux\/sql-server-linux-setup?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.microsoft.com\/zh-cn\/sql\/linux\/sql-server-linux-setup?view=sql-server-2017<\/a><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/zh-cn\/sql\/linux\/quickstart-install-connect-red-hat?view=sql-server-2017\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.microsoft.com\/zh-cn\/sql\/linux\/quickstart-install-connect-red-hat?view=sql-server-2017<\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u5b89\u88c5<\/strong><strong> SQL Server\u8be6\u7ec6\u6b65\u9aa4<\/strong><\/p>\n<p>\u4e00\u3001\u4e0b\u8f7d Microsoft SQL Server 2017 Red Hat \u5b58\u50a8\u5e93\u914d\u7f6e\u6587\u4ef6<\/p>\n<ol>\n<li>cd \/etc\/yum.repos.d<\/li>\n<li>wget <a href=\"https:\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server-2017.repo\">https:\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server-2017.repo<\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>\u4e8c\u3001\u5b89\u88c5 mssql-server<\/p>\n<ol>\n<li>yum install -y mssql-server<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>\u4e09\u3001\u914d\u7f6emssql-server\uff0c\u6b64\u90e8\u53ef\u9009\u62e9\u5b89\u88c5\u7684sqlserver\u7c7b\u578b\uff0c\u53ca\u8bbe\u7f6e\u5bc6\u7801<\/p>\n<ol>\n<li>\/opt\/mssql\/bin\/mssql-conf setup<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>\u56db\u3001\u68c0\u67e5\u8fd0\u884c\u72b6\u6001\uff0c\u8bbe\u7f6e\u5f00\u673a\u542f\u52a8<\/p>\n<ol>\n<li>systemctl status mssql-server.service #\u68c0\u67e5\u72b6\u6001<\/li>\n<li>systemctl start mssql-server.service # \u5f00\u542f\u670d\u52a1<\/li>\n<li>systemctl enable mssql-server.service # \u8bbe\u7f6e\u5f00\u673a\u542f\u52a8<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>\u4e94\u3001\u8bbe\u7f6e\u9632\u706b\u5899<\/p>\n<ol>\n<li>firewall-cmd &#8211;zone=public &#8211;add-port=1433\/tcp &#8211;permanent<\/li>\n<li>firewall-cmd \u2013reload<\/li>\n<\/ol>\n<p>\u516d\u3001\u81f3\u6b64\u53ef\u4ee5windows \u4e0b\u4f7f\u7528smss\u8fde\u63a5\u81f3\u6b64mssql-server\u670d\u52a1\u5668<\/p>\n<p>&nbsp;<\/p>\n<p>\u9a8c\u8bc1\u73af\u5883\uff1aCentOS7.7 + Aliyun\uff0c\u9a8c\u8bc1\u672a\u5b8c\u6210\uff0c\u539f\u56e0\uff1a\u5b89\u88c5\u8981\u6c42\u81f3\u5c112G\u5185\u5b58\uff0c\u5185\u5b58\u4e0d\u591f<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: right;\">\u65f6\u95f4\uff1a2019-11-01 14:17:00<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53c2\u8003\u7f51\u5740 https:\/\/docs.microsoft.com\/zh-cn\/sql\/linux\/sql-ser [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[36,35],"tags":[3,13],"_links":{"self":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts\/104"}],"collection":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":1,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":289,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/posts\/104\/revisions\/289"}],"wp:attachment":[{"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.linux-dba.com\/index.php\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}