{"id":11192,"date":"2020-08-12T08:47:07","date_gmt":"2020-08-12T01:47:07","guid":{"rendered":"http:\/\/help.sme2020.misa.vn\/?post_type=ht_kb&#038;p=11192"},"modified":"2025-10-23T14:30:12","modified_gmt":"2025-10-23T07:30:12","slug":"khi-ket-noi-may-chu-may-tram-neu-tcp-ip-cua-sql-server-may-chu-bi-tat-thi-phai-lam-the-nao","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/khi-ket-noi-may-chu-may-tram-neu-tcp-ip-cua-sql-server-may-chu-bi-tat-thi-phai-lam-the-nao\/","title":{"rendered":"Khi k\u1ebft n\u1ed1i m\u00e1y ch\u1ee7 m\u00e1y tr\u1ea1m, n\u1ebfu TCP\/IP c\u1ee7a SQL Server m\u00e1y ch\u1ee7 b\u1ecb t\u1eaft th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?"},"content":{"rendered":"<p><strong>Xem phim h\u01b0\u1edbng d\u1eabn<\/strong><\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/msvIMdg9iA4\" width=\"860\" height=\"482\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\"><strong>M\u1ee5c \u0111\u00edch:<\/strong> B\u00e0i vi\u1ebft n\u00e0y h\u01b0\u1edbng d\u1eabn c\u00e1ch kh\u1eafc ph\u1ee5c s\u1ef1 c\u1ed1 m\u00e1y tr\u1ea1m kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c v\u1edbi m\u00e1y ch\u1ee7 do giao th\u1ee9c TCP\/IP tr\u00ean SQL Server b\u1ecb v\u00f4 hi\u1ec7u h\u00f3a, \u0111\u1ea3m b\u1ea3o h\u1ec7 th\u1ed1ng k\u1ebf to\u00e1n ho\u1ea1t \u0111\u1ed9ng th\u00f4ng su\u1ed1t.<\/p>\n<p style=\"text-align: justify;\"><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong> H\u01b0\u1edbng d\u1eabn ki\u1ec3m tra, k\u00edch ho\u1ea1t l\u1ea1i giao th\u1ee9c TCP\/IP cho SQL Server v\u00e0 kh\u1edfi \u0111\u1ed9ng l\u1ea1i d\u1ecbch v\u1ee5 \u0111\u1ec3 kh\u00f4i ph\u1ee5c k\u1ebft n\u1ed1i gi\u1eefa m\u00e1y tr\u1ea1m v\u00e0 m\u00e1y ch\u1ee7.<\/p>\n<p style=\"text-align: justify;\"><strong>Ph\u1ea1m vi \u0111\u00e1p \u1ee9ng:<\/strong>\u00a0\u00c1p d\u1ee5ng cho doanh nghi\u1ec7p, b\u1ed9 ph\u1eadn IT, c\u00e1 nh\u00e2n ho\u1eb7c anh\/ch\u1ecb k\u1ebf to\u00e1n g\u1eb7p l\u1ed7i k\u1ebft n\u1ed1i m\u00e1y tr\u1ea1m v\u1edbi m\u00e1y ch\u1ee7 s\u1eed d\u1ee5ng SQL Server.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>Tr\u00ean m\u00e1y ch\u1ee7, b\u1ea1n kh\u1eafc ph\u1ee5c theo 6 b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> V\u00e0o<b>\u00a0All Programs\\Microsoft SQL Server 2014\\Configuration Tools\\SQL Server Configuration Manager<\/b><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11194\" src=\"\/2022\/wp-content\/uploads\/2020\/08\/upload_2020-6-16_8-16-40.png&quot;\" alt=\"\" width=\"406\" height=\"556\" srcset=\"\/2023\/wp-content\/uploads\/2020\/08\/upload_2020-6-16_8-16-40.png 406w, \/2023\/wp-content\/uploads\/2020\/08\/upload_2020-6-16_8-16-40-37x50.png 37w, \/2023\/wp-content\/uploads\/2020\/08\/upload_2020-6-16_8-16-40-44x60.png 44w, \/2023\/wp-content\/uploads\/2020\/08\/upload_2020-6-16_8-16-40-73x100.png 73w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ch\u1ecdn m\u1ee5c <b>SQL Server Network Configuration (32bit)<\/b>\u00a0tr\u00ean m\u00e0n h\u00ecnh h\u1ed9p tho\u1ea1i\u00a0<b>SQL Server Configuration Manager.<br \/>\n<\/b><br \/>\n<strong>B\u01b0\u1edbc 3:<\/strong> Ch\u1ecdn m\u1ee5c <b>Protocols for MISASME2020<br \/>\n<\/b><br \/>\n<strong>B\u01b0\u1edbc 4:<\/strong> Ch\u1ecdn m\u1ee5c <b>TCP\/IP<\/b>\u00a0\u0111ang \u1edf tr\u1ea1ng th\u00e1i\u00a0<b>Disable<br \/>\n<\/b><br \/>\n<strong>B\u01b0\u1edbc 5:<\/strong> Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn <b>Enable<\/b>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14801\" src=\"\/2022\/wp-content\/uploads\/2020\/08\/15.png&quot;\" alt=\"\" width=\"702\" height=\"490\" srcset=\"\/2023\/wp-content\/uploads\/2020\/08\/15.png 702w, \/2023\/wp-content\/uploads\/2020\/08\/15-700x489.png 700w, \/2023\/wp-content\/uploads\/2020\/08\/15-50x35.png 50w, \/2023\/wp-content\/uploads\/2020\/08\/15-60x42.png 60w, \/2023\/wp-content\/uploads\/2020\/08\/15-100x70.png 100w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> Kh\u1edfi \u0111\u1ed9ng l\u1ea1i <b>SQL Server Service: <\/b>Tr\u00ean c\u1eeda s\u1ed5<b> SQL Server Configuration Manager\/ <\/b>Ch\u1ecdn<b> SQL Server Services<\/b>\/Ch\u1ecdn m\u00e1y ch\u1ee7 SQL \u0111ang s\u1eed d\u1ee5ng, nh\u1ea5n chu\u1ed9t ph\u1ea3i ch\u1ecdn\u00a0<b>Restart\u00a0<\/b>v\u00e0 \u0111\u1ee3i ch\u1ea1y xong.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14802\" src=\"\/2022\/wp-content\/uploads\/2020\/08\/16-1.png&quot;\" alt=\"\" width=\"702\" height=\"189\" srcset=\"\/2023\/wp-content\/uploads\/2020\/08\/16-1.png 702w, \/2023\/wp-content\/uploads\/2020\/08\/16-1-700x188.png 700w, \/2023\/wp-content\/uploads\/2020\/08\/16-1-50x13.png 50w, \/2023\/wp-content\/uploads\/2020\/08\/16-1-60x16.png 60w, \/2023\/wp-content\/uploads\/2020\/08\/16-1-100x27.png 100w\" sizes=\"auto, (max-width: 702px) 100vw, 702px\" \/><\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Xem phim h\u01b0\u1edbng d\u1eabn<\/p>\n","protected":false},"author":133,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2618,2619,2568],"ht-kb-tag":[3957,3889,4003],"class_list":["post-11192","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap-khi-bat-dau-su-dung","ht_kb_category-dang-nhap","ht_kb_category-cau-hoi-thuong-gap","ht_kb_tag-loi-ket-noi","ht_kb_tag-sql-server","ht_kb_tag-tcp-ip"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/11192","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=11192"}],"version-history":[{"count":3,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/11192\/revisions"}],"predecessor-version":[{"id":43779,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/11192\/revisions\/43779"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=11192"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=11192"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=11192"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}