{"id":42246,"date":"2026-06-26T15:31:40","date_gmt":"2026-06-26T08:31:40","guid":{"rendered":"https:\/\/interdata.vn\/blog\/?p=42246"},"modified":"2026-06-26T15:34:28","modified_gmt":"2026-06-26T08:34:28","slug":"cach-xu-ly-loi-sql-cannot-connect-to-server","status":"publish","type":"post","link":"https:\/\/interdata.vn\/blog\/cach-xu-ly-loi-sql-cannot-connect-to-server\/","title":{"rendered":"S\u1eeda Nhanh L\u1ed7i SQL Cannot Connect To Server C\u1ef1c Chu\u1ea9n"},"content":{"rendered":"\n\n<style>\n.interdata-plan-carousel,.interdata-plan-carousel *{box-sizing:border-box}\n.interdata-plan-carousel{--blue:#005bea;--blue-dark:#004dcc;--text:#071832;--muted:#516173;--border:#d8e6fb;--bg:#f3f8ff;--shadow:0 5px 14px rgba(0,62,145,.08);container-type:inline-size;background:var(--bg);padding:14px 40px 18px;position:relative;overflow:hidden}\n.interdata-carousel-heading{color:#f00;font-family:Roboto,sans-serif;font-size:18px;line-height:1.35;font-weight:800;text-align:center;margin:0 0 14px}\n.interdata-plan-viewport{overflow:hidden;width:100%}\n.interdata-plan-track{display:flex;gap:12px;overflow-x:auto;scroll-snap-type:x mandatory;scroll-behavior:smooth;-webkit-overflow-scrolling:touch;scrollbar-width:none;padding:0 0 4px}\n.interdata-plan-track::-webkit-scrollbar{display:none}\n.interdata-plan-card{flex:0 0 calc((100% - 36px)\/4);min-width:0;background:#fff;border:1px solid var(--border);border-radius:8px;padding:15px 10px 13px;min-height:370px;display:flex;flex-direction:column;scroll-snap-align:start;box-shadow:var(--shadow)}\n.interdata-plan-title{color:var(--blue-dark);font-size:16px;line-height:1.22;font-weight:800;text-align:center;margin:0 0 7px;text-transform:uppercase;white-space:nowrap;overflow:hidden;text-overflow:ellipsis}\n.interdata-plan-price{color:var(--blue-dark);font-size:24px;line-height:1;font-weight:900;text-align:center;margin-bottom:12px;white-space:nowrap;letter-spacing:0}\n.interdata-plan-price span{font-size:10px;font-weight:800;margin-left:2px}\n.interdata-plan-badge{align-self:center;display:inline-flex;align-items:center;justify-content:center;background:#ff3934;color:#fff;border-radius:5px;padding:7px 8px;font-size:9px;line-height:1;font-weight:800;margin-bottom:15px;white-space:nowrap;max-width:100%}\n.interdata-plan-features{list-style:none!important;padding:0!important;margin:0!important}\n.interdata-plan-features li{display:flex;gap:7px;align-items:flex-start;color:var(--text);font-size:12px;line-height:1.35;font-weight:700;text-align:left;margin:0 0 10px!important;padding:0!important}\n.interdata-plan-icon{width:14px;min-width:14px;height:14px;color:#0069ff;margin-top:2px}\n.interdata-plan-icon svg{display:block;width:100%;height:100%;fill:none;stroke:currentColor;stroke-width:2;stroke-linecap:round;stroke-linejoin:round}\n.interdata-plan-spacer{flex:1;min-height:16px}\n.interdata-plan-button{display:flex;align-items:center;justify-content:center;min-height:42px;width:100%;background:var(--blue);color:#fff!important;border-radius:5px;font-size:13px;font-weight:800;text-decoration:none!important;box-shadow:0 7px 14px rgba(0,91,234,.24);transition:transform .2s ease,background .2s ease}\n.interdata-plan-button:hover{background:var(--blue-dark);color:#fff!important;transform:translateY(-1px)}\n.interdata-carousel-arrow{position:absolute;top:50%;z-index:5;width:44px;height:54px;border:2px solid #fff!important;border-radius:999px;background:var(--blue)!important;color:#fff!important;box-shadow:0 8px 22px rgba(0,62,145,.32);display:flex!important;align-items:center;justify-content:center;cursor:pointer;transform:translateY(-35%);transition:background .2s ease,color .2s ease,opacity .2s ease,transform .2s ease}\n.interdata-carousel-arrow:hover{background:var(--blue-dark)!important;color:#fff!important;transform:translateY(-35%) scale(1.04)}\n.interdata-carousel-arrow:disabled{opacity:.78;cursor:not-allowed;background:#8aa6cf!important;color:#fff!important}\n.interdata-carousel-arrow:disabled:hover{background:#8aa6cf!important;color:#fff!important;transform:translateY(-35%)}\n.interdata-carousel-arrow svg{display:none!important}\n.interdata-carousel-arrow:before{content:none!important;display:none!important}\n.interdata-carousel-mark{display:block!important;color:#fff!important;font-family:Arial,Helvetica,sans-serif!important;font-size:38px!important;font-weight:900!important;line-height:1!important;text-align:center!important;pointer-events:none!important;transform:translateY(-2px)}\n.interdata-carousel-prev{left:14px}\n.interdata-carousel-prev .interdata-carousel-mark{margin-left:-2px}\n.interdata-carousel-next{right:14px}\n.interdata-carousel-next .interdata-carousel-mark{margin-right:-2px}\n@container (max-width:640px){.interdata-plan-carousel{padding:12px 38px 16px}.interdata-plan-card{flex-basis:calc((100% - 12px)\/2);min-height:370px}.interdata-carousel-heading{font-size:16px}}\n@container (max-width:480px){.interdata-plan-carousel{padding:12px 34px 16px}.interdata-plan-card{flex-basis:100%;min-height:360px}.interdata-plan-price{font-size:25px}.interdata-carousel-arrow{width:34px;height:44px}.interdata-carousel-mark{font-size:32px!important}.interdata-carousel-prev{left:5px}.interdata-carousel-next{right:5px}}\n<\/style>\n\n<div class=\"interdata-plan-carousel\" data-interdata-carousel>\n  <div class=\"interdata-carousel-heading\">Si\u00eau \u01afu \u0110\u00e3i VPS \/ CLOUD SERVER - Ti\u1ebft Ki\u1ec7m \u0110\u1ebfn 70%<\/div>\n\n  <svg width=\"0\" height=\"0\" style=\"position:absolute;visibility:hidden\" aria-hidden=\"true\">\n    <symbol id=\"id-icon-cpu\" viewBox=\"0 0 24 24\"><rect x=\"7\" y=\"7\" width=\"10\" height=\"10\" rx=\"2\"><\/rect><path d=\"M4 9h3M4 15h3M17 9h3M17 15h3M9 4v3M15 4v3M9 17v3M15 17v3\"><\/path><path d=\"M10 10h4v4h-4z\"><\/path><\/symbol>\n    <symbol id=\"id-icon-ram\" viewBox=\"0 0 24 24\"><rect x=\"4\" y=\"8\" width=\"16\" height=\"8\" rx=\"2\"><\/rect><path d=\"M7 16v2M11 16v2M15 16v2M19 16v2M7 11h1M11 11h1M15 11h1\"><\/path><\/symbol>\n    <symbol id=\"id-icon-storage\" viewBox=\"0 0 24 24\"><rect x=\"6\" y=\"3\" width=\"12\" height=\"18\" rx=\"2\"><\/rect><path d=\"M9 7h6\"><\/path><circle cx=\"12\" cy=\"16\" r=\"1.5\"><\/circle><\/symbol>\n    <symbol id=\"id-icon-network\" viewBox=\"0 0 24 24\"><path d=\"M5 12.5a10 10 0 0 1 14 0\"><\/path><path d=\"M8.5 16a5 5 0 0 1 7 0\"><\/path><path d=\"M12 19h.01\"><\/path><\/symbol>\n    <symbol id=\"id-icon-gift\" viewBox=\"0 0 24 24\"><rect x=\"3\" y=\"8\" width=\"18\" height=\"13\" rx=\"2\"><\/rect><path d=\"M12 8v13M3 12h18\"><\/path><path d=\"M7.5 8C6.1 8 5 6.9 5 5.5S6.1 3 7.5 3C10 3 12 8 12 8\"><\/path><path d=\"M16.5 8C17.9 8 19 6.9 19 5.5S17.9 3 16.5 3C14 3 12 8 12 8\"><\/path><\/symbol>\n  <\/svg>\n\n  <button class=\"interdata-carousel-arrow interdata-carousel-prev\" type=\"button\" aria-label=\"Xem 4 g\u00f3i tr\u01b0\u1edbc\">\n    <svg viewBox=\"0 0 24 24\" aria-hidden=\"true\"><path d=\"M15 18l-6-6 6-6\"><\/path><\/svg>\n    <span class=\"interdata-carousel-mark\" aria-hidden=\"true\">&#8249;<\/span>\n  <\/button>\n\n  <div class=\"interdata-plan-viewport\">\n    <div class=\"interdata-plan-track\">\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Base<\/h3>\n        <div class=\"interdata-plan-price\">299K<span>\/3 th\u00e1ng<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>2 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>2GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>30GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/best-value-plans-2026\/best-value-plans-premium-base\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Base<\/h3>\n        <div class=\"interdata-plan-price\">999K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>3 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>3GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>30GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cyber-week-2026\/premium-base\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Pro<\/h3>\n        <div class=\"interdata-plan-price\">2.599K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>6 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>8GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>80GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 350Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cyber-week-2026\/premium-pro\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Ultra<\/h3>\n        <div class=\"interdata-plan-price\">5.679K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>12 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>16GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>180GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 450Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cyber-week-2026\/premium-ultra\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">BD-CLOUD 1<\/h3>\n        <div class=\"interdata-plan-price\">988K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>2 vCPU<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>2 GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>30 GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300 Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/bd-cloud-performance-2026\/bd-cloud-1\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">BD-CLOUD 2<\/h3>\n        <div class=\"interdata-plan-price\">2.988K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>4 vCPU<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>8 GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>80 GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300 Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/bd-cloud-performance-2026\/bd-cloud-2\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Cloud-Day - Base<\/h3>\n        <div class=\"interdata-plan-price\">2.666K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-gift\"><\/use><\/svg><\/span>T\u1eb7ng 80GB S3 v\u00e0 1 n\u0103m s\u1eed d\u1ee5ng khi mua 2 n\u0103m tr\u1edf l\u00ean<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>4 vCPU AMD G3<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>6GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>60GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 10Gbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cloud-day-by-interdata-2026\/cloud-day-base\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Cloud-Day - Pro<\/h3>\n        <div class=\"interdata-plan-price\">5.666K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-gift\"><\/use><\/svg><\/span>T\u1eb7ng 200GB S3 v\u00e0 1 n\u0103m s\u1eed d\u1ee5ng khi mua 2 n\u0103m tr\u1edf l\u00ean<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>8 vCPU AMD G3<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>12GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>160GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 10Gbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cloud-day-by-interdata-2026\/cloud-day-pro\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n    <\/div>\n  <\/div>\n\n  <button class=\"interdata-carousel-arrow interdata-carousel-next\" type=\"button\" aria-label=\"Xem 4 g\u00f3i ti\u1ebfp theo\">\n    <svg viewBox=\"0 0 24 24\" aria-hidden=\"true\"><path d=\"M9 18l6-6-6-6\"><\/path><\/svg>\n    <span class=\"interdata-carousel-mark\" aria-hidden=\"true\">&#8250;<\/span>\n  <\/button>\n<\/div>\n\n<script>\n(function(){\n  function setupInterDataCarousel(root){\n    var track=root.querySelector('.interdata-plan-track');\n    var prev=root.querySelector('.interdata-carousel-prev');\n    var next=root.querySelector('.interdata-carousel-next');\n    if(!track||!prev||!next||track.dataset.ready==='1')return;\n    track.dataset.ready='1';\n\n    function pageWidth(){\n      return track.clientWidth;\n    }\n\n    function updateButtons(){\n      var maxScroll=track.scrollWidth-track.clientWidth-2;\n      prev.disabled=track.scrollLeft<=2;\n      next.disabled=track.scrollLeft>=maxScroll;\n    }\n\n    prev.addEventListener('click',function(){\n      track.scrollBy({left:-pageWidth(),behavior:'smooth'});\n    });\n\n    next.addEventListener('click',function(){\n      track.scrollBy({left:pageWidth(),behavior:'smooth'});\n    });\n\n    track.addEventListener('scroll',function(){\n      window.requestAnimationFrame(updateButtons);\n    });\n\n    window.addEventListener('resize',updateButtons);\n    updateButtons();\n  }\n\n  function initInterDataCarousels(){\n    document.querySelectorAll('[data-interdata-carousel]').forEach(setupInterDataCarousel);\n  }\n\n  if(document.readyState==='loading'){\n    document.addEventListener('DOMContentLoaded',initInterDataCarousels);\n  }else{\n    initInterDataCarousels();\n  }\n})();\n<\/script>\n\n\t<div id=\"gap-219188381\" class=\"gap-element clearfix\" style=\"display:block; height:auto;\">\n\t\t\n<style>\n#gap-219188381 {\n  padding-top: 30px;\n}\n<\/style>\n\t<\/div>\n\t\n<p style=\"text-align: justify;\"><span style=\"font-size: 100%;\">L\u1ed7i <strong>SQL Cannot Connect To Server<\/strong> l\u00e0 m\u1ed9t trong nh\u1eefng s\u1ef1 c\u1ed1 ph\u1ed5 bi\u1ebfn v\u00e0 g\u00e2y gi\u00e1n \u0111o\u1ea1n c\u00f4ng vi\u1ec7c nhi\u1ec1u nh\u1ea5t \u0111\u1ed1i v\u1edbi Qu\u1ea3n Tr\u1ecb Vi\u00ean H\u1ec7 Th\u1ed1ng c\u0169ng nh\u01b0 L\u1eadp Tr\u00ecnh Vi\u00ean v\u1eadn h\u00e0nh C\u01a1 S\u1edf D\u1eef Li\u1ec7u. Khi \u1ee9ng d\u1ee5ng \u0111\u1ed9t ng\u1ed9t m\u1ea5t k\u1ebft n\u1ed1i v\u1edbi C\u01a1 S\u1edf D\u1eef Li\u1ec7u, vi\u1ec7c x\u00e1c \u0111\u1ecbnh \u0111\u00fang nguy\u00ean nh\u00e2n g\u1ed1c r\u1ec5 l\u00e0 ch\u00eca kh\u00f3a \u0111\u1ec3 kh\u00f4i ph\u1ee5c d\u1ecbch v\u1ee5 nhanh nh\u1ea5t. \u0110\u1ec3 h\u1ed7 tr\u1ee3 x\u1eed l\u00fd tri\u1ec7t \u0111\u1ec3 t\u00ecnh tr\u1ea1ng n\u00e0y, <a style=\"background: linear-gradient(90deg, #1E3A8A 0%, #2563EB 100%); -webkit-background-clip: text; -webkit-text-fill-color: transparent; text-decoration: none; font-weight: bold;\" href=\"\/\" target=\"_blank\" rel=\"noopener\">InterData<\/a> cung c\u1ea5p h\u01b0\u1edbng d\u1eabn th\u1ef1c chi\u1ebfn gi\u00fap C\u1ea5u H\u00ecnh, m\u1edf c\u1ed5ng k\u1ebft n\u1ed1i v\u00e0 s\u1eeda l\u1ed7i d\u1ecbch v\u1ee5 SQL Server chi ti\u1ebft d\u01b0\u1edbi \u0111\u00e2y.<br \/>\n<\/span><\/p>\n<div style=\"background-color: #eff6ff; padding: 20px; border: 1.5px solid #BFDBFE; border-radius: 12px; margin-bottom: 40px; box-shadow: 0 8px 20px rgba(37, 99, 235, 0.05);\">\n<p style=\"font-family: 'Be Vietnam Pro', sans-serif; font-weight: bold; font-size: 18px; margin-top: 0; margin-bottom: 15px; color: #1e3a8a;\">N\u1ed8I DUNG B\u00c0I VI\u1ebeT<\/p>\n<ul style=\"list-style-type: none; padding-left: 0; margin: 0;\">\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section1\">1. T\u1ea1i sao h\u1ec7 th\u1ed1ng b\u00e1o l\u1ed7i SQL Cannot Connect To Server?<\/a><\/li>\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section2\">2. C\u00e1c b\u01b0\u1edbc kh\u1eafc ph\u1ee5c l\u1ed7i SQL Cannot Connect To Server do c\u1ea5u h\u00ecnh d\u1ecbch v\u1ee5<\/a><\/li>\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section3\">3. C\u1ea5u h\u00ecnh TCP\/IP SQL Server v\u00e0 m\u1edf port tr\u00ean Windows Firewall<\/a><\/li>\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section4\">4. B\u1eadt SQL Server Browser cho c\u00e1c Named Instance<\/a><\/li>\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section5\">5. Ki\u1ec3m tra thi\u1ebft l\u1eadp k\u1ebft n\u1ed1i trong SSMS v\u00e0 c\u1ea5u h\u00ecnh Mixed Mode Authentication<\/a><\/li>\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section6\">6. S\u1eeda l\u1ed7i SQL Cannot Connect To Server tr\u00ean c\u00e1c phi\u00ean b\u1ea3n SQL Server c\u0169<\/a><\/li>\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section7\">7. C\u00e1ch ki\u1ec3m tra k\u1ebft n\u1ed1i Database b\u1eb1ng c\u00f4ng c\u1ee5 th\u1ef1c chi\u1ebfn<\/a><\/li>\n<li style=\"margin-bottom: 10px;\"><a style=\"text-decoration: none; color: #2563eb; font-weight: bold;\" href=\"#section8\">8. Khi n\u00e0o n\u00ean chuy\u1ec3n t\u1eeb Hosting l\u00ean VPS ho\u1eb7c Cloud Server \u0111\u1ec3 ch\u1ea1y SQL Server?<\/a><\/li>\n<\/ul>\n<\/div>\n<h2 id=\"section1\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">1. T\u1ea1i sao h\u1ec7 th\u1ed1ng b\u00e1o l\u1ed7i SQL Cannot Connect To Server?<\/h2>\n<p>Th\u00f4ng b\u00e1o\u00a0<strong>SQL Cannot Connect To Server<\/strong>\u00a0th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 ch\u1ec9 nh\u00f3m l\u1ed7i x\u1ea3y ra khi \u1ee9ng d\u1ee5ng m\u00e1y kh\u00e1ch kh\u00f4ng th\u1ec3 thi\u1ebft l\u1eadp k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server \u0111ang ch\u1ea1y tr\u00ean m\u00e1y ch\u1ee7. \u0110\u00e2y kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng l\u00e0 m\u1ed9t l\u1ed7i duy nh\u1ea5t, m\u00e0 c\u00f3 th\u1ec3 l\u00e0 nhi\u1ec1u l\u1ed7i kh\u00e1c nhau li\u00ean quan \u0111\u1ebfn d\u1ecbch v\u1ee5 SQL Server, t\u00ean server, t\u00ean instance, giao th\u1ee9c m\u1ea1ng, port, Firewall ho\u1eb7c th\u00f4ng tin \u0111\u0103ng nh\u1eadp.<\/p>\n<p>N\u00f3i c\u00e1ch kh\u00e1c, l\u1ed7i k\u1ebft n\u1ed1i SQL Server c\u00f3 th\u1ec3 xu\u1ea5t ph\u00e1t t\u1eeb c\u1ea3 hai l\u1edbp:<\/p>\n<ul>\n<li><strong>L\u1edbp k\u1ebft n\u1ed1i m\u1ea1ng:<\/strong>\u00a0m\u00e1y kh\u00e1ch kh\u00f4ng t\u00ecm th\u1ea5y m\u00e1y ch\u1ee7, kh\u00f4ng truy c\u1eadp \u0111\u01b0\u1ee3c port, sai instance name, SQL Server Browser kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng ho\u1eb7c Firewall ch\u1eb7n k\u1ebft n\u1ed1i.<\/li>\n<li><strong>L\u1edbp x\u00e1c th\u1ef1c:<\/strong>\u00a0m\u00e1y kh\u00e1ch \u0111\u00e3 k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c \u0111\u1ebfn SQL Server nh\u01b0ng \u0111\u0103ng nh\u1eadp th\u1ea5t b\u1ea1i do sai t\u00e0i kho\u1ea3n, sai m\u1eadt kh\u1ea9u, sai authentication mode ho\u1eb7c t\u00e0i kho\u1ea3n ch\u01b0a \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n.<\/li>\n<\/ul>\n<p>Trong m\u00f4i tr\u01b0\u1eddng Windows Server ho\u1eb7c m\u00e1y t\u00ednh c\u00e1 nh\u00e2n, h\u1ec7 th\u1ed1ng th\u01b0\u1eddng tr\u1ea3 v\u1ec1 c\u00e1c m\u00e3 l\u1ed7i \u0111i k\u00e8m th\u00f4ng b\u00e1o k\u1ebft n\u1ed1i th\u1ea5t b\u1ea1i. Vi\u1ec7c hi\u1ec3u \u0111\u00fang \u00fd ngh\u0129a c\u1ee7a t\u1eebng m\u00e3 l\u1ed7i s\u1ebd gi\u00fap k\u1ef9 thu\u1eadt vi\u00ean khoanh v\u00f9ng nguy\u00ean nh\u00e2n nhanh h\u01a1n.<\/p>\n<table>\n<thead>\n<tr>\n<th>M\u00e3 l\u1ed7i ph\u1ed5 bi\u1ebfn<\/th>\n<th>\u00dd ngh\u0129a k\u1ef9 thu\u1eadt<\/th>\n<th>Nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>SQL Error 2<\/strong><\/td>\n<td>Th\u01b0\u1eddng xu\u1ea5t hi\u1ec7n trong nh\u00f3m l\u1ed7i\u00a0<code>Named Pipes Provider, error: 40 - Could not open a connection to SQL Server<\/code>\u00a0ho\u1eb7c l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y \u0111\u01b0\u1eddng d\u1eabn\/k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server.<\/td>\n<td>SQL Server service ch\u01b0a ch\u1ea1y, sai t\u00ean server\/instance, TCP\/IP ho\u1eb7c Named Pipes ch\u01b0a b\u1eadt, client \u0111ang d\u00f9ng sai protocol, ho\u1eb7c m\u00e1y kh\u00e1ch kh\u00f4ng truy c\u1eadp \u0111\u01b0\u1ee3c \u0111\u1ebfn m\u00e1y ch\u1ee7.<\/td>\n<\/tr>\n<tr>\n<td><strong>SQL Error 53<\/strong><\/td>\n<td>Th\u01b0\u1eddng li\u00ean quan \u0111\u1ebfn l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y \u0111\u01b0\u1eddng d\u1eabn m\u1ea1ng ho\u1eb7c kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server.<\/td>\n<td>Sai IP\/t\u00ean m\u00e1y ch\u1ee7, l\u1ed7i DNS\/hostname, m\u00e1y ch\u1ee7 kh\u00f4ng reachable, Firewall ch\u1eb7n TCP port c\u1ee7a SQL Server, ho\u1eb7c SQL Server kh\u00f4ng l\u1eafng nghe tr\u00ean port \u0111\u01b0\u1ee3c g\u1ecdi.<\/td>\n<\/tr>\n<tr>\n<td><strong>SQL Error 26<\/strong><\/td>\n<td><code>Error Locating Server\/Instance Specified<\/code>, t\u1ee9c client kh\u00f4ng \u0111\u1ecbnh v\u1ecb \u0111\u01b0\u1ee3c server ho\u1eb7c instance \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh.<\/td>\n<td>Th\u01b0\u1eddng g\u1eb7p khi k\u1ebft n\u1ed1i \u0111\u1ebfn Named Instance nh\u01b0\u00a0<code>SQLEXPRESS<\/code>\u00a0nh\u01b0ng sai t\u00ean instance, SQL Server Browser kh\u00f4ng ch\u1ea1y, UDP port\u00a0<code>1434<\/code>\u00a0b\u1ecb ch\u1eb7n, instance \u0111ang d\u00f9ng dynamic port ho\u1eb7c instance b\u1ecb \u1ea9n.<\/td>\n<\/tr>\n<tr>\n<td><strong>SQL Error 18456<\/strong><\/td>\n<td><code>Login failed for user<\/code>, t\u1ee9c k\u1ebft n\u1ed1i \u0111\u00e3 \u0111\u1ebfn l\u1edbp x\u00e1c th\u1ef1c nh\u01b0ng \u0111\u0103ng nh\u1eadp b\u1ecb t\u1eeb ch\u1ed1i.<\/td>\n<td>Sai username\/password, SQL Server ch\u01b0a b\u1eadt Mixed Mode khi d\u00f9ng SQL Login, login b\u1ecb disabled, b\u1ecb kh\u00f3a, m\u1eadt kh\u1ea9u h\u1ebft h\u1ea1n ho\u1eb7c t\u00e0i kho\u1ea3n ch\u01b0a c\u00f3 quy\u1ec1n v\u00e0o database.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Trong th\u1ef1c t\u1ebf, nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p k\u1ebft n\u1ed1i local b\u1eb1ng\u00a0<code>localhost<\/code>,\u00a0<code>.<\/code>\u00a0ho\u1eb7c\u00a0<code>(local)<\/code>\u00a0v\u1eabn th\u00e0nh c\u00f4ng, nh\u01b0ng k\u1ebft n\u1ed1i t\u1eeb m\u00e1y kh\u00e1c qua IP LAN l\u1ea1i th\u1ea5t b\u1ea1i. Nguy\u00ean nh\u00e2n th\u01b0\u1eddng l\u00e0 SQL Server ch\u1ec9 \u0111ang s\u1eb5n s\u00e0ng cho k\u1ebft n\u1ed1i n\u1ed9i b\u1ed9, trong khi k\u1ebft n\u1ed1i t\u1eeb xa ch\u01b0a \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh \u0111\u1ea7y \u0111\u1ee7.<\/p>\n<p>C\u00e1c \u0111i\u1ec3m c\u1ea7n ki\u1ec3m tra g\u1ed3m:<\/p>\n<ul>\n<li>D\u1ecbch v\u1ee5 SQL Server c\u1ee7a \u0111\u00fang instance \u0111\u00e3 ch\u1ea1y ch\u01b0a.<\/li>\n<li>T\u00ean server, IP ho\u1eb7c instance name trong chu\u1ed7i k\u1ebft n\u1ed1i \u0111\u00e3 \u0111\u00fang ch\u01b0a.<\/li>\n<li>Giao th\u1ee9c\u00a0<strong>TCP\/IP<\/strong>\u00a0\u0111\u00e3 \u0111\u01b0\u1ee3c b\u1eadt trong SQL Server Configuration Manager ch\u01b0a.<\/li>\n<li>SQL Server \u0111ang l\u1eafng nghe port n\u00e0o.<\/li>\n<li>Windows Firewall \u0111\u00e3 m\u1edf \u0111\u00fang TCP port c\u1ee7a SQL Server ch\u01b0a.<\/li>\n<li>V\u1edbi Named Instance, SQL Server Browser c\u00f3 \u0111ang ch\u1ea1y kh\u00f4ng n\u1ebfu client k\u1ebft n\u1ed1i b\u1eb1ng d\u1ea1ng\u00a0<code>TEN_SERVER\\TEN_INSTANCE<\/code>.<\/li>\n<li>UDP port\u00a0<code>1434<\/code>\u00a0c\u00f3 b\u1ecb Firewall ch\u1eb7n kh\u00f4ng n\u1ebfu h\u1ec7 th\u1ed1ng ph\u1ee5 thu\u1ed9c SQL Server Browser.<\/li>\n<li>SQL Server Authentication, Windows Authentication ho\u1eb7c Mixed Mode \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh \u0111\u00fang v\u1edbi c\u00e1ch \u1ee9ng d\u1ee5ng \u0111\u0103ng nh\u1eadp ch\u01b0a.<\/li>\n<\/ul>\n<p>Kh\u00f4ng n\u00ean m\u1eb7c \u0111\u1ecbnh cho r\u1eb1ng m\u1ecdi l\u1ed7i\u00a0<strong>SQL Cannot Connect To Server<\/strong>\u00a0\u0111\u1ec1u do port\u00a0<code>1433<\/code>\u00a0ho\u1eb7c TCP\/IP b\u1ecb t\u1eaft. \u0110\u00e2y ch\u1ec9 l\u00e0 hai nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn. \u0110\u1ec3 x\u1eed l\u00fd ch\u00ednh x\u00e1c, c\u1ea7n d\u1ef1a v\u00e0o m\u00e3 l\u1ed7i c\u1ee5 th\u1ec3, th\u00f4ng b\u00e1o chi ti\u1ebft, SQL Server Error Log v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng \u0111ang k\u1ebft n\u1ed1i \u0111\u1ebfn database.<\/p>\n<p>N\u1ebfu SQL Server d\u00f9ng\u00a0<strong>Default Instance<\/strong>, port th\u01b0\u1eddng g\u1eb7p l\u00e0\u00a0<code>1433<\/code>. N\u1ebfu d\u00f9ng\u00a0<strong>Named Instance<\/strong>\u00a0nh\u01b0\u00a0<code>SQLEXPRESS<\/code>, SQL Server c\u00f3 th\u1ec3 d\u00f9ng dynamic port ho\u1eb7c m\u1ed9t port t\u0129nh do qu\u1ea3n tr\u1ecb vi\u00ean c\u1ea5u h\u00ecnh. Trong m\u00f4i tr\u01b0\u1eddng production, n\u00ean x\u00e1c \u0111\u1ecbnh r\u00f5 port SQL Server \u0111ang l\u1eafng nghe v\u00e0 c\u1ea5u h\u00ecnh Firewall\/chu\u1ed7i k\u1ebft n\u1ed1i theo \u0111\u00fang port th\u1ef1c t\u1ebf.<\/p>\n<h2 id=\"section2\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">2. C\u00e1c b\u01b0\u1edbc kh\u1eafc ph\u1ee5c l\u1ed7i SQL Cannot Connect To Server do c\u1ea5u h\u00ecnh d\u1ecbch v\u1ee5<\/h2>\n<p>Khi g\u1eb7p l\u1ed7i\u00a0<strong>SQL Server Cannot Connect To Server<\/strong>, thao t\u00e1c \u0111\u1ea7u ti\u00ean c\u1ea7n th\u1ef1c hi\u1ec7n l\u00e0 ki\u1ec3m tra tr\u1ea1ng th\u00e1i ho\u1ea1t \u0111\u1ed9ng c\u1ee7a c\u00e1c d\u1ecbch v\u1ee5 SQL Server tr\u00ean m\u00e1y ch\u1ee7. N\u1ebfu d\u1ecbch v\u1ee5 SQL Server Database Engine ch\u01b0a \u0111\u01b0\u1ee3c kh\u1edfi ch\u1ea1y, \u1ee9ng d\u1ee5ng, ph\u1ea7n m\u1ec1m qu\u1ea3n tr\u1ecb ho\u1eb7c m\u00e1y kh\u00e1ch s\u1ebd kh\u00f4ng th\u1ec3 k\u1ebft n\u1ed1i \u0111\u1ebfn c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n<p>V\u1edbi SQL Server, d\u1ecbch v\u1ee5 ch\u00ednh th\u01b0\u1eddng c\u00f3 d\u1ea1ng:<\/p>\n<ul>\n<li><code>SQL Server (MSSQLSERVER)<\/code>\u00a0n\u1ebfu b\u1ea1n \u0111ang d\u00f9ng\u00a0<strong>Default Instance<\/strong>.<\/li>\n<li><code>SQL Server (T\u00caN_INSTANCE)<\/code>\u00a0n\u1ebfu b\u1ea1n \u0111ang d\u00f9ng\u00a0<strong>Named Instance<\/strong>, v\u00ed d\u1ee5\u00a0<code>SQL Server (SQLEXPRESS)<\/code>.<\/li>\n<\/ul>\n<p>Quy tr\u00ecnh ki\u1ec3m tra v\u00e0 kh\u1edfi ch\u1ea1y d\u1ecbch v\u1ee5 SQL Server qua Windows Services \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm\u00a0<code>Windows + R<\/code>, g\u00f5 l\u1ec7nh\u00a0<code>services.msc<\/code>, sau \u0111\u00f3 nh\u1ea5n\u00a0<code>Enter<\/code>\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 qu\u1ea3n l\u00fd d\u1ecbch v\u1ee5 h\u1ec7 th\u1ed1ng Windows Services.<\/li>\n<li><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Cu\u1ed9n danh s\u00e1ch v\u00e0 t\u00ecm c\u00e1c d\u1ecbch v\u1ee5 c\u00f3 ti\u1ec1n t\u1ed1\u00a0<code>SQL Server<\/code>. D\u1ecbch v\u1ee5 c\u1ea7n ki\u1ec3m tra th\u01b0\u1eddng l\u00e0\u00a0<code>SQL Server (MSSQLSERVER)<\/code>\u00a0\u0111\u1ed1i v\u1edbi Default Instance ho\u1eb7c\u00a0<code>SQL Server (SQLEXPRESS)<\/code>\u00a0\u0111\u1ed1i v\u1edbi Named Instance ph\u1ed5 bi\u1ebfn c\u1ee7a SQL Server Express.<\/li>\n<li><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Quan s\u00e1t c\u1ed9t\u00a0<code>Status<\/code>. N\u1ebfu c\u1ed9t n\u00e0y tr\u1ed1ng, ngh\u0129a l\u00e0 d\u1ecbch v\u1ee5 SQL Server \u0111ang d\u1eebng. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o d\u1ecbch v\u1ee5 \u0111\u00f3 v\u00e0 ch\u1ecdn\u00a0<code>Start<\/code>\u00a0\u0111\u1ec3 kh\u1edfi ch\u1ea1y.<\/li>\n<li><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0N\u1ebfu d\u1ecbch v\u1ee5 \u0111ang b\u1ecb \u0111\u1eb7t \u1edf tr\u1ea1ng th\u00e1i\u00a0<code>Disabled<\/code>, h\u00e3y nh\u1ea5p \u0111\u00fap v\u00e0o d\u1ecbch v\u1ee5, chuy\u1ec3n m\u1ee5c\u00a0<code>Startup type<\/code>\u00a0sang\u00a0<code>Automatic<\/code>\u00a0ho\u1eb7c\u00a0<code>Manual<\/code>, nh\u1ea5n\u00a0<code>Apply<\/code>, sau \u0111\u00f3 m\u1edbi b\u1ea5m\u00a0<code>Start<\/code>.<\/li>\n<li><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0\u0110\u1ec3 tr\u00e1nh l\u1ed7i SQL Server kh\u00f4ng t\u1ef1 ch\u1ea1y sau khi m\u00e1y ch\u1ee7 kh\u1edfi \u0111\u1ed9ng l\u1ea1i, n\u00ean \u0111\u1eb7t\u00a0<code>Startup type<\/code>\u00a0th\u00e0nh\u00a0<code>Automatic<\/code>, sau \u0111\u00f3 nh\u1ea5n\u00a0<code>Apply<\/code>\u00a0v\u00e0\u00a0<code>OK<\/code>\u00a0\u0111\u1ec3 l\u01b0u c\u1ea5u h\u00ecnh.<\/li>\n<\/ul>\n<p>Ngo\u00e0i Windows Services, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 ki\u1ec3m tra d\u1ecbch v\u1ee5 ch\u00ednh x\u00e1c h\u01a1n b\u1eb1ng\u00a0<strong>SQL Server Configuration Manager<\/strong>. T\u1ea1i \u0111\u00e2y, v\u00e0o m\u1ee5c\u00a0<code>SQL Server Services<\/code>\u00a0\u0111\u1ec3 xem tr\u1ea1ng th\u00e1i c\u1ee7a SQL Server Database Engine, SQL Server Agent v\u00e0 SQL Server Browser.<\/p>\n<p>\u0110\u1ed1i v\u1edbi qu\u1ea3n tr\u1ecb vi\u00ean h\u1ec7 th\u1ed1ng quen thao t\u00e1c b\u1eb1ng d\u00f2ng l\u1ec7nh, c\u00f3 th\u1ec3 m\u1edf PowerShell d\u01b0\u1edbi quy\u1ec1n Administrator v\u00e0 s\u1eed d\u1ee5ng c\u00e1c l\u1ec7nh sau:<\/p>\n<pre><code class=\"language-powershell\"># Li\u1ec7t k\u00ea c\u00e1c d\u1ecbch v\u1ee5 li\u00ean quan \u0111\u1ebfn SQL Server\r\nGet-Service -Name 'MSSQL*','SQLBrowser','SQLSERVERAGENT' -ErrorAction SilentlyContinue\r\n\r\n# Kh\u1edfi ch\u1ea1y SQL Server Default Instance\r\nStart-Service -Name 'MSSQLSERVER'\r\n\r\n# Thi\u1ebft l\u1eadp Default Instance t\u1ef1 kh\u1edfi \u0111\u1ed9ng c\u00f9ng Windows\r\nSet-Service -Name 'MSSQLSERVER' -StartupType Automatic\r\n<\/code><\/pre>\n<p>N\u1ebfu b\u1ea1n \u0111ang d\u00f9ng Named Instance, v\u00ed d\u1ee5\u00a0<code>SQLEXPRESS<\/code>, t\u00ean d\u1ecbch v\u1ee5 trong PowerShell th\u01b0\u1eddng c\u00f3 d\u1ea1ng\u00a0<code>MSSQL$SQLEXPRESS<\/code>. Khi \u0111\u00f3 c\u00f3 th\u1ec3 d\u00f9ng l\u1ec7nh:<\/p>\n<pre><code class=\"language-powershell\"># Kh\u1edfi ch\u1ea1y SQL Server Named Instance SQLEXPRESS\r\nStart-Service -Name 'MSSQL$SQLEXPRESS'\r\n\r\n# Thi\u1ebft l\u1eadp SQLEXPRESS t\u1ef1 kh\u1edfi \u0111\u1ed9ng c\u00f9ng Windows\r\nSet-Service -Name 'MSSQL$SQLEXPRESS' -StartupType Automatic\r\n<\/code><\/pre>\n<p><em><strong>L\u01b0u \u00fd:<\/strong> <\/em>Khi d\u00f9ng PowerShell v\u1edbi Named Instance, n\u00ean \u0111\u1eb7t t\u00ean d\u1ecbch v\u1ee5 trong d\u1ea5u nh\u00e1y \u0111\u01a1n, v\u00ed d\u1ee5\u00a0<code>'MSSQL$SQLEXPRESS'<\/code>, \u0111\u1ec3 tr\u00e1nh k\u00fd t\u1ef1\u00a0<code>$<\/code>\u00a0b\u1ecb hi\u1ec3u nh\u1ea7m l\u00e0 bi\u1ebfn trong PowerShell.<\/p>\n<p>N\u1ebfu b\u1ea1n k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server b\u1eb1ng d\u1ea1ng\u00a0<code>TEN_MAY_CHU\\TEN_INSTANCE<\/code>, v\u00ed d\u1ee5\u00a0<code>localhost\\SQLEXPRESS<\/code>, nh\u01b0ng v\u1eabn g\u1eb7p l\u1ed7i kh\u00f4ng t\u00ecm th\u1ea5y m\u00e1y ch\u1ee7 ho\u1eb7c instance, h\u00e3y ki\u1ec3m tra th\u00eam d\u1ecbch v\u1ee5\u00a0<strong>SQL Server Browser<\/strong>. D\u1ecbch v\u1ee5 n\u00e0y gi\u00fap m\u00e1y kh\u00e1ch x\u00e1c \u0111\u1ecbnh \u0111\u00fang instance v\u00e0 c\u1ed5ng k\u1ebft n\u1ed1i c\u1ee7a SQL Server Named Instance.<\/p>\n<p>C\u00f3 th\u1ec3 kh\u1edfi ch\u1ea1y SQL Server Browser b\u1eb1ng PowerShell nh\u01b0 sau:<\/p>\n<pre><code class=\"language-powershell\"># Kh\u1edfi ch\u1ea1y SQL Server Browser\r\nStart-Service -Name 'SQLBrowser'\r\n\r\n# Thi\u1ebft l\u1eadp SQL Server Browser t\u1ef1 kh\u1edfi \u0111\u1ed9ng c\u00f9ng Windows\r\nSet-Service -Name 'SQLBrowser' -StartupType Automatic\r\n<\/code><\/pre>\n<p>Sau khi ho\u00e0n t\u1ea5t thao t\u00e1c b\u1eadt d\u1ecbch v\u1ee5 SQL Server, h\u00e3y th\u1eed k\u1ebft n\u1ed1i l\u1ea1i b\u1eb1ng\u00a0<strong>SQL Server Management Studio (SSMS)<\/strong>\u00a0ngay tr\u00ean ch\u00ednh m\u00e1y ch\u1ee7 tr\u01b0\u1edbc. N\u1ebfu k\u1ebft n\u1ed1i n\u1ed9i b\u1ed9 th\u00e0nh c\u00f4ng nh\u01b0ng m\u00e1y kh\u00e1ch t\u1eeb xa v\u1eabn kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c, l\u00fac \u0111\u00f3 m\u1edbi ti\u1ebfp t\u1ee5c ki\u1ec3m tra c\u00e1c c\u1ea5u h\u00ecnh m\u1ea1ng nh\u01b0 TCP\/IP, port SQL Server, Windows Firewall v\u00e0 quy\u1ec1n \u0111\u0103ng nh\u1eadp.<\/p>\n<div style=\"display: flex; flex-wrap: wrap; background-color: #fff; border: 1.5px solid #BFDBFE; box-shadow: 0 8px 20px rgba(37,99,235,0.08); border-radius: 12px; overflow: hidden; margin: 35px 0;\">\n<div style=\"flex: 1; min-width: 250px; background: linear-gradient(135deg, #1E3A8A 0%, #2563EB 100%); display: flex; align-items: center; justify-content: center; padding: 30px; text-align: center;\">\n<div>\n<p style=\"color: white; font-size: 34px; font-family: 'Be Vietnam Pro', sans-serif; font-weight: bold; margin: 0; line-height: 1.1;\">Thu\u00ea VPS<\/p>\n<p style=\"color: #dbeafe; font-size: 15px; font-weight: 600; margin-top: 12px;\">\u1ed4n \u0111\u1ecbnh &#8211; To\u00e0n quy\u1ec1n Root &#8211; Kh\u1edfi t\u1ea1o nhanh<\/p>\n<\/div>\n<\/div>\n<div style=\"flex: 2; padding: 25px; min-width: 300px;\">\n<h3 style=\"font-family: 'Be Vietnam Pro', sans-serif; color: #1e3a8a; margin-top: 0; font-size: 20px;\">V\u1eadn h\u00e0nh h\u1ec7 th\u1ed1ng SQL Server \u1ed5n \u0111\u1ecbnh<\/h3>\n<p style=\"text-align: justify; font-size: 15px; margin-bottom: 15px;\">D\u1ecbch v\u1ee5 Thu\u00ea VPS t\u1ea1i InterData cung c\u1ea5p t\u00e0i nguy\u00ean \u0111\u1ed9c l\u1eadp v\u1edbi CPU th\u1ebf h\u1ec7 m\u1edbi, \u1ed5 c\u1ee9ng SSD NVMe U.2 t\u1ed1c \u0111\u1ed9 cao v\u00e0 h\u1ec7 th\u1ed1ng ch\u1ed1ng DDoS hi\u1ec7u qu\u1ea3, gi\u00fap c\u00e1c \u1ee9ng d\u1ee5ng k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp \u0111\u1ebfn C\u01a1 S\u1edf D\u1eef Li\u1ec7u SQL Server lu\u00f4n m\u01b0\u1ee3t m\u00e0 v\u00e0 an to\u00e0n.<\/p>\n<p><a style=\"background: linear-gradient(90deg, #2563EB 0%, #1E3A8A 100%); color: white; padding: 12px 25px; text-decoration: none; font-weight: 600; border-radius: 8px; font-size: 15px; display: inline-block; box-shadow: 0 5px 15px rgba(37,99,235,0.3);\" href=\"https:\/\/interdata.vn\/thue-vps\/\" target=\"_blank\" rel=\"noopener\">T\u00ecm hi\u1ec3u g\u00f3i VPS ph\u00f9 h\u1ee3p \u27f6<\/a><\/p>\n<\/div>\n<\/div>\n<h2 id=\"section3\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">3. C\u1ea5u h\u00ecnh TCP\/IP SQL Server v\u00e0 m\u1edf port tr\u00ean Windows Firewall<\/h2>\n<p>Ngay c\u1ea3 khi d\u1ecbch v\u1ee5 SQL Server \u0111ang ch\u1ea1y b\u00ecnh th\u01b0\u1eddng tr\u00ean m\u00e1y ch\u1ee7, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 g\u1eb7p l\u1ed7i\u00a0<strong>SQL Cannot Connect To Server<\/strong>\u00a0n\u1ebfu SQL Server ch\u01b0a cho ph\u00e9p k\u1ebft n\u1ed1i qua TCP\/IP, \u0111ang s\u1eed d\u1ee5ng sai port ho\u1eb7c b\u1ecb Windows Firewall ch\u1eb7n k\u1ebft n\u1ed1i t\u1eeb m\u00e1y tr\u1ea1m.<\/p>\n<p>Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p, \u0111\u1eb7c bi\u1ec7t v\u1edbi SQL Server Express ho\u1eb7c Named Instance, SQL Server c\u00f3 th\u1ec3 ch\u01b0a l\u1eafng nghe tr\u00ean port c\u1ed1 \u0111\u1ecbnh. V\u00ec v\u1eady, b\u1ea1n c\u1ea7n ki\u1ec3m tra l\u1ea1i giao th\u1ee9c TCP\/IP v\u00e0 c\u1ea5u h\u00ecnh port ph\u00f9 h\u1ee3p tr\u01b0\u1edbc khi m\u1edf Firewall.<\/p>\n<p>\u0110\u1ec3 c\u1ea5u h\u00ecnh TCP\/IP cho SQL Server, th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau trong\u00a0<strong>SQL Server Configuration Manager<\/strong>:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf\u00a0<strong>SQL Server Configuration Manager<\/strong>\u00a0t\u1eeb Start Menu. N\u1ebfu kh\u00f4ng t\u00ecm th\u1ea5y, b\u1ea1n c\u00f3 th\u1ec3 nh\u1ea5n\u00a0<code>Windows + R<\/code>\u00a0v\u00e0 ch\u1ea1y t\u1ec7p qu\u1ea3n l\u00fd t\u01b0\u01a1ng \u1ee9ng v\u1edbi phi\u00ean b\u1ea3n SQL Server \u0111ang d\u00f9ng, v\u00ed d\u1ee5:<\/p>\n<ul>\n<li><code>SQLServerManager16.msc<\/code>\u00a0cho SQL Server 2022<\/li>\n<li><code>SQLServerManager15.msc<\/code>\u00a0cho SQL Server 2019<\/li>\n<li><code>SQLServerManager14.msc<\/code>\u00a0cho SQL Server 2017<\/li>\n<li><code>SQLServerManager13.msc<\/code>\u00a0cho SQL Server 2016<\/li>\n<li><code>SQLServerManager12.msc<\/code>\u00a0cho SQL Server 2014<\/li>\n<\/ul>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0\u1ede khung b\u00ean tr\u00e1i, m\u1edf m\u1ee5c\u00a0<strong>SQL Server Network Configuration<\/strong>, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Protocols for MSSQLSERVER<\/strong>\u00a0n\u1ebfu b\u1ea1n d\u00f9ng Default Instance. N\u1ebfu d\u00f9ng Named Instance, h\u00e3y ch\u1ecdn \u0111\u00fang m\u1ee5c\u00a0<strong>Protocols for T\u00caN_INSTANCE<\/strong>, v\u00ed d\u1ee5\u00a0<strong>Protocols for SQLEXPRESS<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0\u1ede khung b\u00ean ph\u1ea3i, t\u00ecm d\u00f2ng\u00a0<strong>TCP\/IP<\/strong>. N\u1ebfu tr\u1ea1ng th\u00e1i \u0111ang l\u00e0\u00a0<strong>Disabled<\/strong>, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o\u00a0<strong>TCP\/IP<\/strong>\u00a0v\u00e0 ch\u1ecdn\u00a0<strong>Enable<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Ti\u1ebfp t\u1ee5c nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o\u00a0<strong>TCP\/IP<\/strong>, ch\u1ecdn\u00a0<strong>Properties<\/strong>, sau \u0111\u00f3 chuy\u1ec3n sang tab\u00a0<strong>IP Addresses<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0Cu\u1ed9n xu\u1ed1ng cu\u1ed1i c\u1eeda s\u1ed5 v\u00e0 t\u00ecm m\u1ee5c\u00a0<strong>IPAll<\/strong>. T\u1ea1i \u0111\u00e2y, b\u1ea1n c\u1ea5u h\u00ecnh nh\u01b0 sau:<\/p>\n<ul>\n<li>X\u00f3a to\u00e0n b\u1ed9 gi\u00e1 tr\u1ecb trong \u00f4\u00a0<strong>TCP Dynamic Ports<\/strong>\u00a0n\u1ebfu mu\u1ed1n d\u00f9ng port c\u1ed1 \u0111\u1ecbnh.<\/li>\n<li>Nh\u1eadp port c\u1ea7n d\u00f9ng v\u00e0o \u00f4\u00a0<strong>TCP Port<\/strong>.<\/li>\n<\/ul>\n<p>Th\u00f4ng th\u01b0\u1eddng, Default Instance c\u1ee7a SQL Server s\u1eed d\u1ee5ng port\u00a0<code>1433<\/code>. Tuy nhi\u00ean, n\u1ebfu m\u00e1y ch\u1ee7 \u0111ang c\u00f3 nhi\u1ec1u SQL Server Instance ho\u1eb7c port\u00a0<code>1433<\/code>\u00a0\u0111\u00e3 \u0111\u01b0\u1ee3c d\u00f9ng b\u1edfi instance kh\u00e1c, b\u1ea1n n\u00ean ch\u1ecdn m\u1ed9t port t\u0129nh kh\u00e1c ch\u01b0a b\u1ecb chi\u1ebfm d\u1ee5ng, v\u00ed d\u1ee5\u00a0<code>14330<\/code>\u00a0ho\u1eb7c m\u1ed9t port ph\u00f9 h\u1ee3p v\u1edbi quy chu\u1ea9n h\u1ec7 th\u1ed1ng c\u1ee7a b\u1ea1n.<\/p>\n<p>Sau \u0111\u00f3 nh\u1ea5n\u00a0<strong>Apply<\/strong>\u00a0v\u00e0\u00a0<strong>OK<\/strong>\u00a0\u0111\u1ec3 l\u01b0u c\u1ea5u h\u00ecnh.<\/p>\n<p>Sau khi b\u1eadt TCP\/IP ho\u1eb7c thay \u0111\u1ed5i port, b\u1ea1n c\u1ea7n kh\u1edfi \u0111\u1ed9ng l\u1ea1i d\u1ecbch v\u1ee5 SQL Server \u0111\u1ec3 c\u1ea5u h\u00ecnh c\u00f3 hi\u1ec7u l\u1ef1c. Trong\u00a0<strong>SQL Server Configuration Manager<\/strong>, v\u00e0o m\u1ee5c\u00a0<strong>SQL Server Services<\/strong>, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o\u00a0<strong>SQL Server (MSSQLSERVER)<\/strong>\u00a0ho\u1eb7c\u00a0<strong>SQL Server (T\u00caN_INSTANCE)<\/strong>, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Restart<\/strong>.<\/p>\n<p>Ti\u1ebfp theo, n\u1ebfu m\u00e1y ch\u1ee7 \u0111ang b\u1eadt\u00a0<strong>Windows Firewall<\/strong>, b\u1ea1n c\u1ea7n m\u1edf \u0111\u00fang port m\u00e0 SQL Server \u0111ang l\u1eafng nghe. N\u1ebfu b\u1ea1n \u0111\u00e3 c\u1ea5u h\u00ecnh SQL Server d\u00f9ng port\u00a0<code>1433<\/code>, c\u00f3 th\u1ec3 m\u1edf port b\u1eb1ng PowerShell v\u1edbi quy\u1ec1n\u00a0<strong>Administrator<\/strong>\u00a0nh\u01b0 sau:<\/p>\n<pre><code class=\"language-powershell\"># T\u1ea1o rule cho ph\u00e9p k\u1ebft n\u1ed1i v\u00e0o SQL Server qua TCP port 1433\r\nNew-NetFirewallRule -DisplayName \"SQL Server - TCP 1433\" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow -Profile Domain,Private\r\n<\/code><\/pre>\n<p>N\u1ebfu SQL Server c\u1ee7a b\u1ea1n d\u00f9ng port kh\u00e1c, h\u00e3y thay\u00a0<code>1433<\/code>\u00a0b\u1eb1ng port th\u1ef1c t\u1ebf \u0111\u00e3 c\u1ea5u h\u00ecnh.<\/p>\n<p>Trong m\u00f4i tr\u01b0\u1eddng n\u1ed9i b\u1ed9 ho\u1eb7c production, kh\u00f4ng n\u00ean m\u1edf port cho profile\u00a0<strong>Public<\/strong>\u00a0n\u1ebfu kh\u00f4ng th\u1eadt s\u1ef1 c\u1ea7n thi\u1ebft. \u0110\u1ec3 an to\u00e0n h\u01a1n, b\u1ea1n n\u00ean gi\u1edbi h\u1ea1n k\u1ebft n\u1ed1i theo d\u1ea3i IP n\u1ed9i b\u1ed9 ho\u1eb7c IP m\u00e1y tr\u1ea1m \u0111\u01b0\u1ee3c ph\u00e9p truy c\u1eadp.<\/p>\n<p>V\u00ed d\u1ee5 ch\u1ec9 cho ph\u00e9p m\u1ed9t IP m\u00e1y tr\u1ea1m c\u1ee5 th\u1ec3 k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server:<\/p>\n<pre><code class=\"language-powershell\">New-NetFirewallRule -DisplayName \"SQL Server - TCP 1433 Limited\" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow -Profile Domain,Private -RemoteAddress 192.168.1.50\r\n<\/code><\/pre>\n<p>N\u1ebfu mu\u1ed1n c\u1ea5u h\u00ecnh b\u1eb1ng giao di\u1ec7n \u0111\u1ed3 h\u1ecda, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf\u00a0<strong>Windows Defender Firewall with Advanced Security<\/strong>, ch\u1ecdn\u00a0<strong>Inbound Rules<\/strong>, t\u1ea1o rule m\u1edbi lo\u1ea1i\u00a0<strong>Port<\/strong>, ch\u1ecdn giao th\u1ee9c\u00a0<strong>TCP<\/strong>, nh\u1eadp port SQL Server \u0111ang s\u1eed d\u1ee5ng, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Allow the connection<\/strong>. \u1ede b\u01b0\u1edbc ch\u1ecdn profile, ch\u1ec9 n\u00ean ch\u1ecdn\u00a0<strong>Domain<\/strong>\u00a0ho\u1eb7c\u00a0<strong>Private<\/strong>\u00a0n\u1ebfu SQL Server d\u00f9ng trong m\u1ea1ng n\u1ed9i b\u1ed9. Ch\u1ec9 ch\u1ecdn\u00a0<strong>Public<\/strong>\u00a0khi b\u1ea1n hi\u1ec3u r\u00f5 r\u1ee7i ro v\u00e0 th\u1eadt s\u1ef1 c\u1ea7n m\u1edf k\u1ebft n\u1ed1i t\u1eeb m\u1ea1ng c\u00f4ng c\u1ed9ng.<\/p>\n<p>L\u01b0u \u00fd th\u00eam: N\u1ebfu b\u1ea1n d\u00f9ng Named Instance v\u00e0 v\u1eabn mu\u1ed1n k\u1ebft n\u1ed1i theo d\u1ea1ng\u00a0<code>TEN_MAY_CHU\\TEN_INSTANCE<\/code>\u00a0thay v\u00ec ch\u1ec9 \u0111\u1ecbnh tr\u1ef1c ti\u1ebfp\u00a0<code>TEN_MAY_CHU,PORT<\/code>, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea7n ki\u1ec3m tra th\u00eam d\u1ecbch v\u1ee5\u00a0<strong>SQL Server Browser<\/strong>\u00a0v\u00e0 port UDP\u00a0<code>1434<\/code>. Tuy nhi\u00ean, v\u1edbi c\u00e1ch c\u1ea5u h\u00ecnh port t\u0129nh, ph\u01b0\u01a1ng \u00e1n r\u00f5 r\u00e0ng v\u00e0 d\u1ec5 ki\u1ec3m so\u00e1t h\u01a1n l\u00e0 k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp b\u1eb1ng c\u00fa ph\u00e1p:<\/p>\n<pre><code class=\"language-text\">TEN_MAY_CHU,1433\r\n<\/code><\/pre>\n<p>ho\u1eb7c:<\/p>\n<pre><code class=\"language-text\">DIA_CHI_IP,1433<\/code><\/pre>\n<h2 id=\"section4\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">4. B\u1eadt SQL Server Browser cho c\u00e1c Named Instance<\/h2>\n<p>Trong nhi\u1ec1u h\u1ec7 th\u1ed1ng m\u00e1y ch\u1ee7, ngo\u00e0i Default Instance c\u1ee7a SQL Server, k\u1ef9 thu\u1eadt vi\u00ean c\u00f3 th\u1ec3 c\u00e0i th\u00eam c\u00e1c phi\u00ean b\u1ea3n ph\u1ee5 d\u01b0\u1edbi d\u1ea1ng\u00a0<strong>Named Instance<\/strong>. V\u00ed d\u1ee5, SQL Server Express th\u01b0\u1eddng c\u00f3 t\u00ean k\u1ebft n\u1ed1i d\u1ea1ng:<\/p>\n<pre><code class=\"language-text\">IP_MAY_CHU\\SQLEXPRESS\r\n<\/code><\/pre>\n<p>Kh\u00e1c v\u1edbi Default Instance th\u01b0\u1eddng d\u00f9ng TCP port\u00a0<code>1433<\/code>, c\u00e1c Named Instance, bao g\u1ed3m SQL Server Express, th\u01b0\u1eddng \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh d\u00f9ng\u00a0<strong>dynamic port<\/strong>\u00a0theo m\u1eb7c \u0111\u1ecbnh. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 SQL Server s\u1ebd t\u1ef1 ch\u1ecdn m\u1ed9t port kh\u1ea3 d\u1ee5ng khi d\u1ecbch v\u1ee5 kh\u1edfi \u0111\u1ed9ng. Port n\u00e0y c\u00f3 th\u1ec3 thay \u0111\u1ed5i sau khi SQL Server restart, tr\u1eeb khi qu\u1ea3n tr\u1ecb vi\u00ean \u0111\u00e3 c\u1ea5u h\u00ecnh instance \u0111\u00f3 d\u00f9ng m\u1ed9t port t\u0129nh.<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p client k\u1ebft n\u1ed1i b\u1eb1ng d\u1ea1ng:<\/p>\n<pre><code class=\"language-text\">TEN_MAY_CHU\\TEN_INSTANCE\r\n<\/code><\/pre>\n<p>ho\u1eb7c:<\/p>\n<pre><code class=\"language-text\">IP_MAY_CHU\\TEN_INSTANCE\r\n<\/code><\/pre>\n<p>d\u1ecbch v\u1ee5\u00a0<strong>SQL Server Browser<\/strong>\u00a0s\u1ebd gi\u00fap client x\u00e1c \u0111\u1ecbnh \u0111\u00fang port m\u00e0 Named Instance \u0111ang s\u1eed d\u1ee5ng. SQL Server Browser kh\u00f4ng tr\u1ef1c ti\u1ebfp x\u1eed l\u00fd k\u1ebft n\u1ed1i d\u1eef li\u1ec7u, m\u00e0 ch\u1ec9 tr\u1ea3 v\u1ec1 th\u00f4ng tin port ho\u1eb7c named pipe c\u1ee7a instance t\u01b0\u01a1ng \u1ee9ng. Sau \u0111\u00f3, \u1ee9ng d\u1ee5ng client m\u1edbi ti\u1ebfp t\u1ee5c k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server qua port th\u1ef1c t\u1ebf \u0111\u00f3.<\/p>\n<p>N\u1ebfu SQL Server Browser kh\u00f4ng ch\u1ea1y, ho\u1eb7c UDP port\u00a0<code>1434<\/code>\u00a0b\u1ecb Firewall ch\u1eb7n, m\u00e1y tr\u1ea1m c\u00f3 th\u1ec3 kh\u00f4ng t\u00ecm \u0111\u01b0\u1ee3c port c\u1ee7a Named Instance. Khi \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 g\u1eb7p c\u00e1c l\u1ed7i nh\u01b0\u00a0<strong>SQL Error 26<\/strong>,\u00a0<strong>network-related or instance-specific error<\/strong>, ho\u1eb7c l\u1ed7i\u00a0<strong>SQL Cannot Connect To Server<\/strong>.<\/p>\n<p>\u0110\u1ec3 b\u1eadt SQL Server Browser, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf\u00a0<strong>SQL Server Configuration Manager<\/strong>\u00a0ho\u1eb7c m\u1edf nhanh b\u1eb1ng\u00a0<code>services.msc<\/code>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0T\u00ecm d\u1ecbch v\u1ee5 c\u00f3 t\u00ean\u00a0<strong>SQL Server Browser<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Nh\u1ea5p \u0111\u00fap v\u00e0o d\u1ecbch v\u1ee5 n\u00e0y. T\u1ea1i m\u1ee5c\u00a0<strong>Start Mode<\/strong>\u00a0ho\u1eb7c\u00a0<strong>Startup type<\/strong>, chuy\u1ec3n t\u1eeb\u00a0<strong>Disabled<\/strong>\u00a0sang\u00a0<strong>Automatic<\/strong>\u00a0n\u1ebfu mu\u1ed1n d\u1ecbch v\u1ee5 t\u1ef1 ch\u1ea1y c\u00f9ng h\u1ec7 th\u1ed1ng. N\u1ebfu ch\u1ec9 c\u1ea7n b\u1eadt t\u1ea1m th\u1eddi \u0111\u1ec3 ki\u1ec3m tra l\u1ed7i, c\u00f3 th\u1ec3 ch\u1ecdn\u00a0<strong>Manual<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>Apply<\/strong>, sau \u0111\u00f3 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o\u00a0<strong>SQL Server Browser<\/strong>\u00a0v\u00e0 ch\u1ecdn\u00a0<strong>Start<\/strong>\u00a0\u0111\u1ec3 kh\u1edfi ch\u1ea1y d\u1ecbch v\u1ee5.<\/p>\n<p>D\u1ecbch v\u1ee5 SQL Server Browser s\u1eed d\u1ee5ng giao th\u1ee9c\u00a0<strong>UDP port 1434<\/strong>. V\u00ec v\u1eady, n\u1ebfu m\u00e1y ch\u1ee7 b\u1eadt\u00a0<strong>Windows Firewall<\/strong>, b\u1ea1n c\u1ea7n m\u1edf th\u00eam UDP port\u00a0<code>1434<\/code>\u00a0\u0111\u1ec3 m\u00e1y tr\u1ea1m c\u00f3 th\u1ec3 truy v\u1ea5n th\u00f4ng tin c\u1ee7a Named Instance.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 m\u1edf port b\u1eb1ng PowerShell v\u1edbi quy\u1ec1n\u00a0<strong>Administrator<\/strong>\u00a0nh\u01b0 sau:<\/p>\n<pre><code class=\"language-powershell\"># M\u1edf UDP port 1434 cho SQL Server Browser trong m\u1ea1ng n\u1ed9i b\u1ed9\r\nNew-NetFirewallRule -DisplayName \"SQL Server Browser - UDP 1434\" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow -Profile Domain,Private\r\n<\/code><\/pre>\n<p>N\u1ebfu m\u00e1y ch\u1ee7 ch\u1ec9 cho ph\u00e9p m\u1ed9t s\u1ed1 IP n\u1ed9i b\u1ed9 truy c\u1eadp, n\u00ean gi\u1edbi h\u1ea1n th\u00eam b\u1eb1ng tham s\u1ed1\u00a0<code>-RemoteAddress<\/code>\u00a0\u0111\u1ec3 t\u0103ng an to\u00e0n:<\/p>\n<pre><code class=\"language-powershell\">New-NetFirewallRule -DisplayName \"SQL Server Browser - UDP 1434 Limited\" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow -Profile Domain,Private -RemoteAddress 192.168.1.0\/24\r\n<\/code><\/pre>\n<p>L\u01b0u \u00fd: Kh\u00f4ng n\u00ean m\u1edf UDP port\u00a0<code>1434<\/code>\u00a0cho profile\u00a0<strong>Public<\/strong>\u00a0n\u1ebfu kh\u00f4ng th\u1eadt s\u1ef1 c\u1ea7n thi\u1ebft. V\u1edbi m\u00f4i tr\u01b0\u1eddng production, n\u00ean gi\u1edbi h\u1ea1n theo IP ngu\u1ed3n ho\u1eb7c d\u1ea3i m\u1ea1ng n\u1ed9i b\u1ed9 \u0111\u1ec3 tr\u00e1nh ph\u01a1i b\u00e0y th\u00f4ng tin SQL Server Instance ra ngo\u00e0i.<\/p>\n<p>Ngo\u00e0i ra, SQL Server Browser kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1ch duy nh\u1ea5t \u0111\u1ec3 k\u1ebft n\u1ed1i \u0111\u1ebfn Named Instance. N\u1ebfu b\u1ea1n \u0111\u00e3 c\u1ea5u h\u00ecnh Named Instance d\u00f9ng m\u1ed9t port t\u0129nh, v\u00ed d\u1ee5\u00a0<code>14330<\/code>, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp b\u1eb1ng c\u00fa ph\u00e1p:<\/p>\n<pre><code class=\"language-text\">IP_MAY_CHU,14330\r\n<\/code><\/pre>\n<p>ho\u1eb7c:<\/p>\n<pre><code class=\"language-text\">TEN_MAY_CHU,14330\r\n<\/code><\/pre>\n<p>C\u00e1ch d\u00f9ng port t\u0129nh th\u01b0\u1eddng d\u1ec5 ki\u1ec3m so\u00e1t Firewall h\u01a1n, \u0111\u1eb7c bi\u1ec7t trong m\u00f4i tr\u01b0\u1eddng server th\u1eadt ho\u1eb7c h\u1ec7 th\u1ed1ng y\u00eau c\u1ea7u b\u1ea3o m\u1eadt cao. Khi \u0111\u00f3, b\u1ea1n ch\u1ec9 c\u1ea7n m\u1edf \u0111\u00fang TCP port c\u1ee7a SQL Server Instance thay v\u00ec ph\u1ee5 thu\u1ed9c v\u00e0o SQL Server Browser.<\/p>\n<h2 id=\"section5\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">5. Ki\u1ec3m tra thi\u1ebft l\u1eadp k\u1ebft n\u1ed1i trong SSMS v\u00e0 c\u1ea5u h\u00ecnh Mixed Mode Authentication<\/h2>\n<p>Sau khi \u0111\u00e3 ki\u1ec3m tra d\u1ecbch v\u1ee5 SQL Server, b\u1eadt TCP\/IP, c\u1ea5u h\u00ecnh \u0111\u00fang port v\u00e0 m\u1edf Windows Firewall, b\u1ea1n v\u1eabn c\u00f3 th\u1ec3 g\u1eb7p l\u1ed7i k\u1ebft n\u1ed1i n\u1ebfu SQL Server b\u1ecb sai c\u1ea5u h\u00ecnh x\u00e1c th\u1ef1c ho\u1eb7c t\u00e0i kho\u1ea3n \u0111\u0103ng nh\u1eadp kh\u00f4ng h\u1ee3p l\u1ec7.<\/p>\n<p>Trong SQL Server Management Studio (SSMS), c\u00f3 hai nh\u00f3m thi\u1ebft l\u1eadp th\u01b0\u1eddng \u0111\u01b0\u1ee3c nh\u1eafc \u0111\u1ebfn khi x\u1eed l\u00fd l\u1ed7i\u00a0<strong>SQL Cannot Connect To Server<\/strong>:<\/p>\n<ul>\n<li>Thi\u1ebft l\u1eadp\u00a0<strong>Connections<\/strong>\u00a0trong Server Properties.<\/li>\n<li>Thi\u1ebft l\u1eadp\u00a0<strong>Server authentication<\/strong>\u00a0trong m\u1ee5c Security.<\/li>\n<\/ul>\n<p>Tuy nhi\u00ean, c\u1ea7n hi\u1ec3u \u0111\u00fang vai tr\u00f2 c\u1ee7a t\u1eebng ph\u1ea7n \u0111\u1ec3 tr\u00e1nh x\u1eed l\u00fd sai nguy\u00ean nh\u00e2n.<\/p>\n<h4>1. Ki\u1ec3m tra m\u1ee5c Connections trong Server Properties<\/h4>\n<p>\u0110\u1ec3 ki\u1ec3m tra ph\u1ea7n Connections, th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf\u00a0<strong>SQL Server Management Studio (SSMS)<\/strong>\u00a0v\u00e0 \u0111\u0103ng nh\u1eadp v\u00e0o SQL Server b\u1eb1ng t\u00e0i kho\u1ea3n c\u00f3 quy\u1ec1n qu\u1ea3n tr\u1ecb, th\u01b0\u1eddng l\u00e0 t\u00e0i kho\u1ea3n Windows thu\u1ed9c nh\u00f3m Administrator ho\u1eb7c t\u00e0i kho\u1ea3n c\u00f3 quy\u1ec1n\u00a0<code>sysadmin<\/code>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Trong khung\u00a0<strong>Object Explorer<\/strong>, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean Server \u1edf tr\u00ean c\u00f9ng, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Properties<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Trong c\u1eeda s\u1ed5\u00a0<strong>Server Properties<\/strong>, ch\u1ecdn m\u1ee5c\u00a0<strong>Connections<\/strong>\u00a0\u1edf c\u1ed9t b\u00ean tr\u00e1i.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0T\u1ea1i khu v\u1ef1c\u00a0<strong>Remote server connections<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y t\u00f9y ch\u1ecdn\u00a0<strong>Allow remote connections to this server<\/strong>.<\/p>\n<p>L\u01b0u \u00fd quan tr\u1ecdng: T\u00f9y ch\u1ecdn\u00a0<strong>Allow remote connections to this server<\/strong>\u00a0trong SSMS kh\u00f4ng ph\u1ea3i l\u00e0 thi\u1ebft l\u1eadp ch\u00ednh \u0111\u1ec3 b\u1eadt k\u1ebft n\u1ed1i t\u1eeb m\u00e1y tr\u1ea1m v\u00e0o SQL Server qua TCP\/IP. Thi\u1ebft l\u1eadp n\u00e0y ch\u1ee7 y\u1ebfu li\u00ean quan \u0111\u1ebfn c\u00e1c k\u1ebft n\u1ed1i gi\u1eefa nh\u1eefng SQL Server v\u1edbi nhau, ch\u1eb3ng h\u1ea1n remote stored procedures ho\u1eb7c remote server connections.<\/p>\n<p>V\u00ec v\u1eady, n\u1ebfu m\u1ee5c n\u00e0y \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1eadt nh\u01b0ng m\u00e1y tr\u1ea1m v\u1eabn kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c, b\u1ea1n v\u1eabn c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u00e1c y\u1ebfu t\u1ed1 quan tr\u1ecdng h\u01a1n nh\u01b0:<\/p>\n<ul>\n<li>SQL Server service \u0111\u00e3 ch\u1ea1y ch\u01b0a.<\/li>\n<li>Giao th\u1ee9c TCP\/IP \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1eadt trong SQL Server Configuration Manager ch\u01b0a.<\/li>\n<li>SQL Server \u0111ang l\u1eafng nghe \u0111\u00fang port ch\u01b0a.<\/li>\n<li>Windows Firewall \u0111\u00e3 m\u1edf \u0111\u00fang TCP port ch\u01b0a.<\/li>\n<li>V\u1edbi Named Instance, SQL Server Browser ho\u1eb7c port t\u0129nh \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh \u0111\u00fang ch\u01b0a.<\/li>\n<li>Chu\u1ed7i k\u1ebft n\u1ed1i t\u1eeb \u1ee9ng d\u1ee5ng \u0111\u00e3 \u0111\u00fang t\u00ean server, instance ho\u1eb7c port ch\u01b0a.<\/li>\n<\/ul>\n<p>Kh\u00f4ng n\u00ean ch\u1ec9nh\u00a0<strong>Remote query timeout<\/strong>\u00a0\u0111\u1ec3 x\u1eed l\u00fd l\u1ed7i k\u1ebft n\u1ed1i th\u00f4ng th\u01b0\u1eddng. Th\u00f4ng s\u1ed1 n\u00e0y kh\u00f4ng ph\u1ea3i l\u00e0 nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn g\u00e2y l\u1ed7i kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c t\u1eeb m\u00e1y tr\u1ea1m v\u00e0o SQL Server.<\/p>\n<h4>2. Chuy\u1ec3n sang Mixed Mode n\u1ebfu c\u1ea7n d\u00f9ng SQL Server Authentication<\/h4>\n<p>M\u1ed9t nguy\u00ean nh\u00e2n kh\u00e1c khi\u1ebfn ng\u01b0\u1eddi d\u00f9ng t\u01b0\u1edfng l\u00e0 l\u1ed7i k\u1ebft n\u1ed1i SQL Server l\u00e0 l\u1ed7i x\u00e1c th\u1ef1c \u0111\u0103ng nh\u1eadp. Tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi \u1ee9ng d\u1ee5ng ho\u1eb7c ng\u01b0\u1eddi d\u00f9ng \u0111\u0103ng nh\u1eadp b\u1eb1ng t\u00e0i kho\u1ea3n SQL Server nh\u01b0\u00a0<code>sa<\/code>, nh\u01b0ng SQL Server l\u1ea1i \u0111ang \u0111\u01b0\u1ee3c c\u1ea5u h\u00ecnh \u1edf ch\u1ebf \u0111\u1ed9 ch\u1ec9 cho ph\u00e9p\u00a0<strong>Windows Authentication<\/strong>.<\/p>\n<p>Khi \u0111\u00f3, h\u1ec7 th\u1ed1ng c\u00f3 th\u1ec3 tr\u1ea3 v\u1ec1 l\u1ed7i:<\/p>\n<pre><code class=\"language-text\">Login failed for user 'sa'. Error: 18456\r\n<\/code><\/pre>\n<p>\u0110\u1ec3 cho ph\u00e9p \u0111\u0103ng nh\u1eadp b\u1eb1ng c\u1ea3 t\u00e0i kho\u1ea3n Windows v\u00e0 t\u00e0i kho\u1ea3n SQL Server, b\u1ea1n c\u1ea7n chuy\u1ec3n SQL Server sang\u00a0<strong>Mixed Mode Authentication<\/strong>.<\/p>\n<p>C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Trong SSMS, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean Server \u1edf khung\u00a0<strong>Object Explorer<\/strong>, sau \u0111\u00f3 ch\u1ecdn\u00a0<strong>Properties<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Trong c\u1eeda s\u1ed5\u00a0<strong>Server Properties<\/strong>, ch\u1ecdn m\u1ee5c\u00a0<strong>Security<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0T\u1ea1i ph\u1ea7n\u00a0<strong>Server authentication<\/strong>, ch\u1ecdn:<\/p>\n<pre><code class=\"language-text\">SQL Server and Windows Authentication mode\r\n<\/code><\/pre>\n<p>\u0110\u00e2y ch\u00ednh l\u00e0 ch\u1ebf \u0111\u1ed9\u00a0<strong>Mixed Mode<\/strong>, cho ph\u00e9p SQL Server ch\u1ea5p nh\u1eadn c\u1ea3 \u0111\u0103ng nh\u1eadp b\u1eb1ng Windows Authentication v\u00e0 SQL Server Authentication.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>OK<\/strong>\u00a0\u0111\u1ec3 l\u01b0u c\u1ea5u h\u00ecnh. SSMS s\u1ebd hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o y\u00eau c\u1ea7u kh\u1edfi \u0111\u1ed9ng l\u1ea1i SQL Server \u0111\u1ec3 thay \u0111\u1ed5i c\u00f3 hi\u1ec7u l\u1ef1c.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0Kh\u1edfi \u0111\u1ed9ng l\u1ea1i d\u1ecbch v\u1ee5 SQL Server. B\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u1eb1ng c\u00e1ch nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean Server trong SSMS v\u00e0 ch\u1ecdn\u00a0<strong>Restart<\/strong>, ho\u1eb7c v\u00e0o\u00a0<strong>SQL Server Configuration Manager &gt; SQL Server Services<\/strong>, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u00fang d\u1ecbch v\u1ee5 SQL Server Instance v\u00e0 ch\u1ecdn\u00a0<strong>Restart<\/strong>.<\/p>\n<h4>3. Ki\u1ec3m tra l\u1ea1i t\u00e0i kho\u1ea3n SQL Login sau khi b\u1eadt Mixed Mode<\/h4>\n<p>Vi\u1ec7c chuy\u1ec3n sang Mixed Mode ch\u1ec9 cho ph\u00e9p SQL Server h\u1ed7 tr\u1ee3 SQL Server Authentication. \u0110i\u1ec1u n\u00e0y kh\u00f4ng c\u00f3 ngh\u0129a l\u00e0 m\u1ecdi t\u00e0i kho\u1ea3n SQL Login \u0111\u1ec1u t\u1ef1 \u0111\u1ed9ng \u0111\u0103ng nh\u1eadp \u0111\u01b0\u1ee3c.<\/p>\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n d\u00f9ng t\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>, c\u1ea7n ki\u1ec3m tra th\u00eam:<\/p>\n<ul>\n<li>T\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>\u00a0c\u00f3 \u0111ang b\u1ecb disabled kh\u00f4ng.<\/li>\n<li>M\u1eadt kh\u1ea9u c\u1ee7a\u00a0<code>sa<\/code>\u00a0c\u00f3 \u0111\u00fang kh\u00f4ng.<\/li>\n<li>T\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>\u00a0c\u00f3 \u0111ang b\u1ecb kh\u00f3a do nh\u1eadp sai m\u1eadt kh\u1ea9u nhi\u1ec1u l\u1ea7n kh\u00f4ng.<\/li>\n<li>SQL Server \u0111\u00e3 \u0111\u01b0\u1ee3c restart sau khi \u0111\u1ed5i sang Mixed Mode ch\u01b0a.<\/li>\n<\/ul>\n<p>Trong m\u00f4i tr\u01b0\u1eddng th\u1ef1c t\u1ebf, kh\u00f4ng n\u00ean l\u1ea1m d\u1ee5ng t\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>\u00a0cho \u1ee9ng d\u1ee5ng. C\u00e1ch an to\u00e0n h\u01a1n l\u00e0 t\u1ea1o m\u1ed9t SQL Login ri\u00eang cho t\u1eebng \u1ee9ng d\u1ee5ng, c\u1ea5p \u0111\u00fang quy\u1ec1n c\u1ea7n thi\u1ebft tr\u00ean database t\u01b0\u01a1ng \u1ee9ng v\u00e0 s\u1eed d\u1ee5ng m\u1eadt kh\u1ea9u m\u1ea1nh.<\/p>\n<p>V\u00ed d\u1ee5, n\u1ebfu \u1ee9ng d\u1ee5ng d\u00f9ng SQL Login ri\u00eang, chu\u1ed7i k\u1ebft n\u1ed1i n\u00ean s\u1eed d\u1ee5ng t\u00e0i kho\u1ea3n \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n ph\u00f9 h\u1ee3p thay v\u00ec d\u00f9ng\u00a0<code>sa<\/code>:<\/p>\n<pre><code class=\"language-text\">Server=IP_MAY_CHU,1433;Database=TEN_DATABASE;User Id=app_user;Password=MAT_KHAU_MANH;\r\n<\/code><\/pre>\n<p>T\u00f3m l\u1ea1i, v\u1edbi l\u1ed7i\u00a0<strong>SQL Cannot Connect To Server<\/strong>, b\u1ea1n kh\u00f4ng n\u00ean ch\u1ec9 t\u1eadp trung v\u00e0o t\u00f9y ch\u1ecdn\u00a0<strong>Allow remote connections to this server<\/strong>\u00a0trong SSMS. H\u00e3y \u01b0u ti\u00ean ki\u1ec3m tra TCP\/IP, port, Firewall, SQL Browser v\u00e0 chu\u1ed7i k\u1ebft n\u1ed1i. C\u00f2n\u00a0<strong>Mixed Mode<\/strong>\u00a0ch\u1ec9 c\u1ea7n c\u1ea5u h\u00ecnh khi b\u1ea1n mu\u1ed1n \u0111\u0103ng nh\u1eadp b\u1eb1ng SQL Server Authentication, ch\u1eb3ng h\u1ea1n\u00a0<code>sa<\/code>\u00a0ho\u1eb7c m\u1ed9t SQL Login ri\u00eang cho \u1ee9ng d\u1ee5ng.<\/p>\n<div style=\"display: flex; flex-wrap: wrap; background-color: #fff; border: 1.5px solid #BFDBFE; box-shadow: 0 8px 20px rgba(37,99,235,0.08); border-radius: 12px; overflow: hidden; margin: 35px 0;\">\n<div style=\"flex: 1; min-width: 250px; background: linear-gradient(135deg, #1E3A8A 0%, #2563EB 100%); display: flex; align-items: center; justify-content: center; padding: 30px; text-align: center;\">\n<div>\n<p style=\"color: white; font-size: 34px; font-family: 'Be Vietnam Pro', sans-serif; font-weight: bold; margin: 0; line-height: 1.1;\">Cloud Server<\/p>\n<p style=\"color: #dbeafe; font-size: 15px; font-weight: 600; margin-top: 12px;\">Scale linh ho\u1ea1t &#8211; Hi\u1ec7u n\u0103ng cao &#8211; Backup li\u00ean t\u1ee5c<\/p>\n<\/div>\n<\/div>\n<div style=\"flex: 2; padding: 25px; min-width: 300px;\">\n<h3 style=\"font-family: 'Be Vietnam Pro', sans-serif; color: #1e3a8a; margin-top: 0; font-size: 20px;\">H\u1ea1 t\u1ea7ng l\u00fd t\u01b0\u1edfng cho Database l\u1edbn<\/h3>\n<p style=\"text-align: justify; font-size: 15px; margin-bottom: 15px;\">Khi c\u00e1c truy v\u1ea5n SQL Server \u0111\u00f2i h\u1ecfi hi\u1ec7u n\u0103ng x\u1eed l\u00fd c\u1ef1c cao v\u00e0 kh\u1ea3 n\u0103ng m\u1edf r\u1ed9ng t\u00e0i nguy\u00ean nhanh ch\u00f3ng m\u00e0 kh\u00f4ng g\u00e2y gi\u00e1n \u0111o\u1ea1n h\u1ec7 th\u1ed1ng, Cloud Server c\u1ee7a InterData l\u00e0 ph\u01b0\u01a1ng \u00e1n thay th\u1ebf t\u1ed1i \u01b0u nh\u1ea5t v\u1edbi c\u1ea5u h\u00ecnh ph\u1ea7n c\u1ee9ng m\u1ea1nh m\u1ebd.<\/p>\n<p><a style=\"background: linear-gradient(90deg, #2563EB 0%, #1E3A8A 100%); color: white; padding: 12px 25px; text-decoration: none; font-weight: 600; border-radius: 8px; font-size: 15px; display: inline-block; box-shadow: 0 5px 15px rgba(37,99,235,0.3);\" href=\"https:\/\/interdata.vn\/cloud-server\/\" target=\"_blank\" rel=\"noopener\">Kh\u00e1m ph\u00e1 Cloud Server ngay \u27f6<\/a><\/p>\n<\/div>\n<\/div>\n<h2 id=\"section6\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">6. S\u1eeda l\u1ed7i SQL Cannot Connect To Server tr\u00ean c\u00e1c phi\u00ean b\u1ea3n SQL Server c\u0169<\/h2>\n<p>Nhi\u1ec1u doanh nghi\u1ec7p v\u00e0 h\u1ec7 th\u1ed1ng ph\u1ea7n m\u1ec1m c\u0169 t\u1ea1i Vi\u1ec7t Nam v\u1eabn \u0111ang s\u1eed d\u1ee5ng SQL Server 2014, SQL Server 2012 ho\u1eb7c c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o t\u01b0\u01a1ng th\u00edch v\u1edbi ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n, ERP, ph\u1ea7n m\u1ec1m b\u00e1n h\u00e0ng ho\u1eb7c \u1ee9ng d\u1ee5ng n\u1ed9i b\u1ed9 \u0111\u00e3 tri\u1ec3n khai l\u00e2u n\u0103m.<\/p>\n<p>Khi x\u1eed l\u00fd l\u1ed7i\u00a0<strong>SQL Cannot Connect To Server<\/strong>\u00a0tr\u00ean c\u00e1c phi\u00ean b\u1ea3n SQL Server c\u0169, k\u1ef9 thu\u1eadt vi\u00ean kh\u00f4ng ch\u1ec9 c\u1ea7n ki\u1ec3m tra d\u1ecbch v\u1ee5, TCP\/IP, port v\u00e0 Firewall, m\u00e0 c\u00f2n ph\u1ea3i ch\u00fa \u00fd \u0111\u1ebfn v\u1ea5n \u0111\u1ec1 t\u01b0\u01a1ng th\u00edch gi\u1eefa SQL Server, h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows Server, giao th\u1ee9c b\u1ea3o m\u1eadt TLS v\u00e0 driver k\u1ebft n\u1ed1i tr\u00ean m\u00e1y tr\u1ea1m.<\/p>\n<p>M\u1ed9t nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p l\u00e0 s\u1ef1 kh\u00f4ng t\u01b0\u01a1ng th\u00edch v\u1ec1 giao th\u1ee9c\u00a0<strong>TLS (Transport Layer Security)<\/strong>. Trong nhi\u1ec1u m\u00f4i tr\u01b0\u1eddng Windows Server m\u1edbi ho\u1eb7c \u0111\u00e3 \u0111\u01b0\u1ee3c si\u1ebft ch\u1eb7t b\u1ea3o m\u1eadt, c\u00e1c giao th\u1ee9c c\u0169 nh\u01b0 TLS 1.0 v\u00e0 TLS 1.1 c\u00f3 th\u1ec3 b\u1ecb v\u00f4 hi\u1ec7u h\u00f3a \u0111\u1ec3 \u01b0u ti\u00ean TLS 1.2 tr\u1edf l\u00ean. Trong khi \u0111\u00f3, SQL Server ho\u1eb7c driver k\u1ebft n\u1ed1i c\u0169 ch\u01b0a \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt c\u00f3 th\u1ec3 kh\u00f4ng h\u1ed7 tr\u1ee3 TLS 1.2 \u0111\u1ea7y \u0111\u1ee7, d\u1eabn \u0111\u1ebfn l\u1ed7i b\u1eaft tay b\u1ea3o m\u1eadt v\u00e0 l\u00e0m \u1ee9ng d\u1ee5ng kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c \u0111\u1ebfn c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n<p>\u0110\u1ec3 kh\u1eafc ph\u1ee5c, b\u1ea1n n\u00ean ki\u1ec3m tra v\u00e0 x\u1eed l\u00fd theo c\u00e1c h\u01b0\u1edbng sau:<\/p>\n<h3>6.1. C\u1eadp nh\u1eadt Service Pack, Cumulative Update v\u00e0 b\u1ea3n v\u00e1 TLS cho SQL Server<\/h3>\n<p>Tr\u01b0\u1edbc ti\u00ean, h\u00e3y ki\u1ec3m tra phi\u00ean b\u1ea3n SQL Server \u0111ang s\u1eed d\u1ee5ng, bao g\u1ed3m b\u1ea3n RTM, Service Pack v\u00e0 Cumulative Update hi\u1ec7n t\u1ea1i.<\/p>\n<p>V\u1edbi SQL Server 2014, SQL Server 2012, SQL Server 2008 R2 ho\u1eb7c SQL Server 2008, b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o h\u1ec7 th\u1ed1ng \u0111\u00e3 \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt l\u00ean b\u1ea3n Service Pack\/Cumulative Update c\u00f3 h\u1ed7 tr\u1ee3 TLS 1.2. N\u1ebfu SQL Server qu\u00e1 c\u0169 ho\u1eb7c ch\u01b0a c\u1eadp nh\u1eadt b\u1ea3n v\u00e1 c\u1ea7n thi\u1ebft, vi\u1ec7c t\u1eaft TLS 1.0\/1.1 tr\u00ean h\u1ec7 \u0111i\u1ec1u h\u00e0nh c\u00f3 th\u1ec3 khi\u1ebfn \u1ee9ng d\u1ee5ng kh\u00f4ng th\u1ec3 k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra phi\u00ean b\u1ea3n SQL Server b\u1eb1ng c\u00e2u l\u1ec7nh:<\/p>\n<pre><code class=\"language-sql\">SELECT @@VERSION;\r\n<\/code><\/pre>\n<p>Sau khi x\u00e1c \u0111\u1ecbnh phi\u00ean b\u1ea3n, h\u00e3y \u0111\u1ed1i chi\u1ebfu v\u1edbi t\u00e0i li\u1ec7u c\u1eadp nh\u1eadt c\u1ee7a Microsoft \u0111\u1ec3 c\u00e0i \u0111\u00fang Service Pack, Cumulative Update ho\u1eb7c b\u1ea3n v\u00e1 TLS t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<h3>6.2. C\u1eadp nh\u1eadt driver k\u1ebft n\u1ed1i tr\u00ean m\u00e1y tr\u1ea1m v\u00e0 \u1ee9ng d\u1ee5ng<\/h3>\n<p>L\u1ed7i k\u1ebft n\u1ed1i kh\u00f4ng ch\u1ec9 \u0111\u1ebfn t\u1eeb m\u00e1y ch\u1ee7 SQL Server. Trong nhi\u1ec1u h\u1ec7 th\u1ed1ng c\u0169, \u1ee9ng d\u1ee5ng k\u1ebf to\u00e1n, ERP ho\u1eb7c ph\u1ea7n m\u1ec1m n\u1ed9i b\u1ed9 c\u00f3 th\u1ec3 \u0111ang s\u1eed d\u1ee5ng driver c\u0169 nh\u01b0:<\/p>\n<pre><code class=\"language-text\">SQL Server Native Client 10.0\r\nSQL Server Native Client 11.0\r\nSQLOLEDB\r\nSQLSRV32.DLL\r\n<\/code><\/pre>\n<p>N\u1ebfu c\u00e1c driver n\u00e0y kh\u00f4ng h\u1ed7 tr\u1ee3 TLS 1.2 ho\u1eb7c ch\u01b0a \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt, m\u00e1y tr\u1ea1m v\u1eabn c\u00f3 th\u1ec3 b\u00e1o l\u1ed7i d\u00f9 SQL Server \u0111\u00e3 \u0111\u01b0\u1ee3c v\u00e1 \u0111\u1ea7y \u0111\u1ee7.<\/p>\n<p>V\u00ec v\u1eady, b\u1ea1n n\u00ean ki\u1ec3m tra m\u00e1y tr\u1ea1m ho\u1eb7c m\u00e1y ch\u1ea1y \u1ee9ng d\u1ee5ng trung gian \u0111ang d\u00f9ng driver n\u00e0o. N\u1ebfu ph\u1ea7n m\u1ec1m v\u1eabn ph\u1ee5 thu\u1ed9c v\u00e0o\u00a0<strong>SQL Server Native Client<\/strong>, h\u00e3y c\u00e0i \u0111\u00fang phi\u00ean b\u1ea3n Native Client t\u01b0\u01a1ng th\u00edch v\u00e0 b\u1ea3n c\u1eadp nh\u1eadt c\u1ea7n thi\u1ebft. N\u1ebfu ph\u1ea7n m\u1ec1m h\u1ed7 tr\u1ee3 driver m\u1edbi h\u01a1n, n\u00ean \u01b0u ti\u00ean d\u00f9ng c\u00e1c driver hi\u1ec7n \u0111\u1ea1i h\u01a1n nh\u01b0\u00a0<strong>Microsoft ODBC Driver for SQL Server<\/strong>\u00a0ho\u1eb7c\u00a0<strong>Microsoft OLE DB Driver for SQL Server<\/strong>.<\/p>\n<p>C\u00e1c l\u1ed7i trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y c\u00f3 th\u1ec3 xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi d\u1ea1ng:<\/p>\n<pre><code class=\"language-text\">Client unable to establish connection\r\n<\/code><\/pre>\n<pre><code class=\"language-text\">An existing connection was forcibly closed by the remote host\r\n<\/code><\/pre>\n<pre><code class=\"language-text\">SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm\r\n<\/code><\/pre>\n<p>ho\u1eb7c c\u00e1c l\u1ed7i k\u1ebft n\u1ed1i d\u1ea1ng network-related\/instance-specific kh\u00e1c.<\/p>\n<h3>6.3. Ki\u1ec3m tra l\u1ea1i TCP\/IP, port t\u0129nh v\u00e0 SQL Server Browser<\/h3>\n<p>V\u1edbi SQL Server c\u0169, \u0111\u1eb7c bi\u1ec7t l\u00e0 SQL Server Express ho\u1eb7c Named Instance, b\u1ea1n v\u1eabn c\u1ea7n ki\u1ec3m tra l\u1ea1i c\u1ea5u h\u00ecnh m\u1ea1ng trong\u00a0<strong>SQL Server Configuration Manager<\/strong>.<\/p>\n<p>C\u00e1c m\u1ee5c c\u1ea7n ki\u1ec3m tra g\u1ed3m:<\/p>\n<ul>\n<li>TCP\/IP \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1eadt trong\u00a0<strong>SQL Server Network Configuration<\/strong>\u00a0ch\u01b0a.<\/li>\n<li>SQL Server \u0111ang d\u00f9ng port t\u0129nh hay dynamic port.<\/li>\n<li>Windows Firewall \u0111\u00e3 m\u1edf \u0111\u00fang TCP port c\u1ee7a SQL Server ch\u01b0a.<\/li>\n<li>N\u1ebfu k\u1ebft n\u1ed1i b\u1eb1ng d\u1ea1ng\u00a0<code>TEN_MAY_CHU\\TEN_INSTANCE<\/code>, d\u1ecbch v\u1ee5 SQL Server Browser c\u00f3 \u0111ang ch\u1ea1y kh\u00f4ng.<\/li>\n<li>UDP port\u00a0<code>1434<\/code>\u00a0c\u00f3 b\u1ecb Firewall ch\u1eb7n kh\u00f4ng n\u1ebfu h\u1ec7 th\u1ed1ng ph\u1ee5 thu\u1ed9c v\u00e0o SQL Server Browser.<\/li>\n<\/ul>\n<p>N\u1ebfu l\u00e0 m\u00f4i tr\u01b0\u1eddng production ho\u1eb7c c\u1ea7n ki\u1ec3m so\u00e1t Firewall ch\u1eb7t ch\u1ebd, n\u00ean c\u1ea5u h\u00ecnh Named Instance d\u00f9ng port t\u0129nh thay v\u00ec ph\u1ee5 thu\u1ed9c ho\u00e0n to\u00e0n v\u00e0o dynamic port. Khi \u0111\u00f3, chu\u1ed7i k\u1ebft n\u1ed1i c\u00f3 th\u1ec3 d\u00f9ng d\u1ea1ng:<\/p>\n<pre><code class=\"language-text\">IP_MAY_CHU,PORT\r\n<\/code><\/pre>\n<p>V\u00ed d\u1ee5:<\/p>\n<pre><code class=\"language-text\">192.168.1.10,14330\r\n<\/code><\/pre>\n<p>C\u00e1ch n\u00e0y gi\u00fap k\u1ef9 thu\u1eadt vi\u00ean d\u1ec5 m\u1edf \u0111\u00fang Firewall rule v\u00e0 gi\u1ea3m r\u1ee7i ro l\u1ed7i do port thay \u0111\u1ed5i sau khi d\u1ecbch v\u1ee5 SQL Server kh\u1edfi \u0111\u1ed9ng l\u1ea1i.<\/p>\n<h3>6.4. Ch\u1ec9 d\u00f9ng Named Pipes khi ph\u1ea7n m\u1ec1m legacy th\u1eadt s\u1ef1 c\u1ea7n<\/h3>\n<p>M\u1ed9t s\u1ed1 ph\u1ea7n m\u1ec1m c\u0169 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 k\u1ebft n\u1ed1i SQL Server qua\u00a0<strong>Named Pipes<\/strong>\u00a0trong m\u1ea1ng LAN. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra v\u00e0 b\u1eadt Named Pipes trong\u00a0<strong>SQL Server Configuration Manager<\/strong>\u00a0n\u1ebfu t\u00e0i li\u1ec7u ph\u1ea7n m\u1ec1m ho\u1eb7c nh\u00e0 cung c\u1ea5p y\u00eau c\u1ea7u.<\/p>\n<p>Tuy nhi\u00ean, kh\u00f4ng n\u00ean xem Named Pipes l\u00e0 gi\u1ea3i ph\u00e1p thay th\u1ebf m\u1eb7c \u0111\u1ecbnh cho TCP\/IP. V\u1edbi \u0111a s\u1ed1 h\u1ec7 th\u1ed1ng hi\u1ec7n nay, \u0111\u1eb7c bi\u1ec7t khi k\u1ebft n\u1ed1i qua nhi\u1ec1u subnet, VPN, Firewall ho\u1eb7c Cloud Server, TCP\/IP v\u1eabn l\u00e0 giao th\u1ee9c d\u1ec5 ki\u1ec3m so\u00e1t v\u00e0 ph\u00f9 h\u1ee3p h\u01a1n.<\/p>\n<p>N\u1ebfu c\u1ea7n b\u1eadt Named Pipes, h\u00e3y th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf\u00a0<strong>SQL Server Configuration Manager<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0V\u00e0o\u00a0<strong>SQL Server Network Configuration<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Ch\u1ecdn\u00a0<strong>Protocols for MSSQLSERVER<\/strong>\u00a0ho\u1eb7c\u00a0<strong>Protocols for T\u00caN_INSTANCE<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o\u00a0<strong>Named Pipes<\/strong>\u00a0v\u00e0 ch\u1ecdn\u00a0<strong>Enable<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0Kh\u1edfi \u0111\u1ed9ng l\u1ea1i d\u1ecbch v\u1ee5 SQL Server \u0111\u1ec3 thay \u0111\u1ed5i c\u00f3 hi\u1ec7u l\u1ef1c.<\/p>\n<p>Sau khi b\u1eadt Named Pipes, c\u1ea7n ki\u1ec3m tra l\u1ea1i Firewall, quy\u1ec1n truy c\u1eadp m\u1ea1ng n\u1ed9i b\u1ed9 v\u00e0 chu\u1ed7i k\u1ebft n\u1ed1i c\u1ee7a \u1ee9ng d\u1ee5ng. N\u1ebfu ph\u1ea7n m\u1ec1m kh\u00f4ng y\u00eau c\u1ea7u Named Pipes, b\u1ea1n n\u00ean \u01b0u ti\u00ean x\u1eed l\u00fd k\u1ebft n\u1ed1i qua TCP\/IP tr\u01b0\u1edbc.<\/p>\n<h3>6.5. C\u00e2n nh\u1eafc n\u00e2ng c\u1ea5p SQL Server c\u0169<\/h3>\n<p>Vi\u1ec7c duy tr\u00ec SQL Server 2014, SQL Server 2012, SQL Server 2008 R2 ho\u1eb7c c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n ti\u1ec1m \u1ea9n nhi\u1ec1u r\u1ee7i ro v\u1ec1 b\u1ea3o m\u1eadt, hi\u1ec7u n\u0103ng v\u00e0 kh\u1ea3 n\u0103ng t\u01b0\u01a1ng th\u00edch v\u1edbi h\u1ec7 \u0111i\u1ec1u h\u00e0nh, driver, ph\u1ea7n m\u1ec1m sao l\u01b0u, ph\u1ea7n m\u1ec1m antivirus v\u00e0 c\u00e1c ch\u00ednh s\u00e1ch b\u1ea3o m\u1eadt m\u1edbi.<\/p>\n<p>N\u1ebfu h\u1ec7 th\u1ed1ng v\u1eabn b\u1eaft bu\u1ed9c d\u00f9ng SQL Server c\u0169 v\u00ec ph\u1ee5 thu\u1ed9c ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n ho\u1eb7c ERP, k\u1ef9 thu\u1eadt vi\u00ean n\u00ean:<\/p>\n<ul>\n<li>C\u1eadp nh\u1eadt SQL Server l\u00ean b\u1ea3n v\u00e1 cu\u1ed1i c\u00f9ng c\u00f2n ph\u00f9 h\u1ee3p.<\/li>\n<li>Sao l\u01b0u database \u0111\u1ecbnh k\u1ef3 v\u00e0 ki\u1ec3m tra kh\u1ea3 n\u0103ng kh\u00f4i ph\u1ee5c.<\/li>\n<li>Gi\u1edbi h\u1ea1n IP \u0111\u01b0\u1ee3c ph\u00e9p k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server.<\/li>\n<li>Kh\u00f4ng m\u1edf port SQL Server tr\u1ef1c ti\u1ebfp ra Internet.<\/li>\n<li>T\u00e1ch database server kh\u1ecfi c\u00e1c d\u1ecbch v\u1ee5 kh\u00f4ng c\u1ea7n thi\u1ebft.<\/li>\n<li>L\u1eadp k\u1ebf ho\u1ea1ch n\u00e2ng c\u1ea5p SQL Server ho\u1eb7c n\u00e2ng c\u1ea5p ph\u1ea7n m\u1ec1m \u1ee9ng d\u1ee5ng trong t\u01b0\u01a1ng lai.<\/li>\n<\/ul>\n<p>V\u1ec1 l\u00e2u d\u00e0i, doanh nghi\u1ec7p n\u00ean c\u00e2n nh\u1eafc n\u00e2ng c\u1ea5p l\u00ean phi\u00ean b\u1ea3n SQL Server c\u00f2n \u0111\u01b0\u1ee3c h\u1ed7 tr\u1ee3 ho\u1eb7c di chuy\u1ec3n h\u1ec7 th\u1ed1ng sang m\u00f4i tr\u01b0\u1eddng m\u00e1y ch\u1ee7 \u1ed5n \u0111\u1ecbnh h\u01a1n nh\u01b0 VPS, Cloud Server ho\u1eb7c m\u00e1y ch\u1ee7 ri\u00eang c\u00f3 ch\u00ednh s\u00e1ch backup, b\u1ea3o m\u1eadt v\u00e0 gi\u00e1m s\u00e1t r\u00f5 r\u00e0ng. \u0110i\u1ec1u n\u00e0y gi\u00fap gi\u1ea3m r\u1ee7i ro m\u1ea5t d\u1eef li\u1ec7u, l\u1ed7i t\u01b0\u01a1ng th\u00edch v\u00e0 gi\u00e1n \u0111o\u1ea1n v\u1eadn h\u00e0nh khi h\u1ec7 \u0111i\u1ec1u h\u00e0nh ho\u1eb7c ph\u1ea7n m\u1ec1m client ti\u1ebfp t\u1ee5c \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt.<\/p>\n<h2 id=\"section7\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">7. C\u00e1ch ki\u1ec3m tra k\u1ebft n\u1ed1i Database b\u1eb1ng c\u00f4ng c\u1ee5 th\u1ef1c chi\u1ebfn<\/h2>\n<p>Sau khi ho\u00e0n t\u1ea5t qu\u00e1 tr\u00ecnh\u00a0<strong>c\u1ea5u h\u00ecnh SQL Server<\/strong>, m\u1edf \u0111\u00fang port k\u1ebft n\u1ed1i v\u00e0 k\u00edch ho\u1ea1t c\u00e1c d\u1ecbch v\u1ee5 li\u00ean quan, b\u1ea1n n\u00ean ki\u1ec3m tra k\u1ebft n\u1ed1i t\u1eeb\u00a0<strong>m\u00e1y kh\u00e1ch<\/strong>\u00a0\u0111\u1ebfn\u00a0<strong>m\u00e1y ch\u1ee7 SQL Server<\/strong>\u00a0tr\u01b0\u1edbc khi c\u1ea5u h\u00ecnh \u1ee9ng d\u1ee5ng ch\u00ednh th\u1ee9c.<\/p>\n<p>Vi\u1ec7c ki\u1ec3m tra n\u00e0y gi\u00fap t\u00e1ch bi\u1ec7t l\u1ed7i do h\u1ea1 t\u1ea7ng m\u1ea1ng, Firewall, SQL Server hay do m\u00e3 ngu\u1ed3n c\u1ee7a ch\u01b0\u01a1ng tr\u00ecnh g\u00e2y ra. N\u1ebfu m\u00e1y kh\u00e1ch ch\u01b0a th\u1ec3 k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp \u0111\u1ebfn SQL Server b\u1eb1ng c\u00f4ng c\u1ee5 ki\u1ec3m tra \u0111\u1ed9c l\u1eadp, \u1ee9ng d\u1ee5ng g\u1ea7n nh\u01b0 ch\u1eafc ch\u1eafn c\u0169ng s\u1ebd g\u1eb7p l\u1ed7i khi ch\u1ea1y.<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 hai ph\u01b0\u01a1ng ph\u00e1p ki\u1ec3m tra k\u1ebft n\u1ed1i Database nhanh g\u1ecdn th\u01b0\u1eddng \u0111\u01b0\u1ee3c k\u1ef9 s\u01b0 h\u1ec7 th\u1ed1ng s\u1eed d\u1ee5ng.<\/p>\n<h3>7.1. Ki\u1ec3m tra port SQL Server b\u1eb1ng Telnet ho\u1eb7c PowerShell<\/h3>\n<p>\u0110\u00e2y l\u00e0 b\u01b0\u1edbc ki\u1ec3m tra nhanh \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh m\u00e1y kh\u00e1ch c\u00f3 truy c\u1eadp \u0111\u01b0\u1ee3c \u0111\u1ebfn port TCP c\u1ee7a SQL Server tr\u00ean m\u00e1y ch\u1ee7 hay kh\u00f4ng.<\/p>\n<p>N\u1ebfu SQL Server \u0111ang d\u00f9ng port m\u1eb7c \u0111\u1ecbnh\u00a0<code>1433<\/code>, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf\u00a0<strong>Command Prompt<\/strong>\u00a0ho\u1eb7c\u00a0<strong>PowerShell<\/strong>\u00a0tr\u00ean m\u00e1y kh\u00e1ch v\u00e0 ch\u1ea1y l\u1ec7nh:<\/p>\n<pre><code class=\"language-powershell\">telnet IP_MAY_CHU 1433\r\n<\/code><\/pre>\n<p>Ho\u1eb7c d\u00f9ng PowerShell:<\/p>\n<pre><code class=\"language-powershell\">Test-NetConnection -ComputerName IP_MAY_CHU -Port 1433\r\n<\/code><\/pre>\n<p>N\u1ebfu SQL Server s\u1eed d\u1ee5ng port kh\u00e1c, h\u00e3y thay\u00a0<code>1433<\/code>\u00a0b\u1eb1ng port th\u1ef1c t\u1ebf \u0111\u00e3 c\u1ea5u h\u00ecnh.<\/p>\n<p>V\u00ed d\u1ee5:<\/p>\n<pre><code class=\"language-powershell\">Test-NetConnection -ComputerName 192.168.1.50 -Port 14330\r\n<\/code><\/pre>\n<p>N\u1ebfu k\u1ebft qu\u1ea3 PowerShell hi\u1ec3n th\u1ecb:<\/p>\n<pre><code class=\"language-text\">TcpTestSucceeded : True\r\n<\/code><\/pre>\n<p>ho\u1eb7c m\u00e0n h\u00ecnh Telnet chuy\u1ec3n sang tr\u1ea1ng th\u00e1i tr\u1ed1ng m\u00e0 kh\u00f4ng b\u00e1o l\u1ed7i, \u0111i\u1ec1u \u0111\u00f3 cho th\u1ea5y m\u00e1y kh\u00e1ch \u0111\u00e3 m\u1edf \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i TCP \u0111\u1ebfn port SQL Server tr\u00ean m\u00e1y ch\u1ee7.<\/p>\n<p>Tuy nhi\u00ean, k\u1ebft qu\u1ea3 n\u00e0y ch\u1ec9 x\u00e1c nh\u1eadn \u0111\u01b0\u1eddng m\u1ea1ng v\u00e0 port \u0111ang th\u00f4ng. N\u00f3 ch\u01b0a kh\u1eb3ng \u0111\u1ecbnh SQL Server Authentication, t\u00e0i kho\u1ea3n \u0111\u0103ng nh\u1eadp, database, quy\u1ec1n truy c\u1eadp, driver ho\u1eb7c c\u1ea5u h\u00ecnh m\u00e3 h\u00f3a TLS \u0111\u00e3 ch\u00ednh x\u00e1c.<\/p>\n<p>N\u1ebfu\u00a0<code>TcpTestSucceeded : False<\/code>, b\u1ea1n n\u00ean ki\u1ec3m tra l\u1ea1i c\u00e1c y\u1ebfu t\u1ed1 sau:<\/p>\n<ul>\n<li>IP ho\u1eb7c t\u00ean m\u00e1y ch\u1ee7 c\u00f3 \u0111\u00fang kh\u00f4ng.<\/li>\n<li>SQL Server service c\u00f3 \u0111ang ch\u1ea1y kh\u00f4ng.<\/li>\n<li>SQL Server c\u00f3 \u0111ang l\u1eafng nghe \u0111\u00fang port kh\u00f4ng.<\/li>\n<li>TCP\/IP \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1eadt trong SQL Server Configuration Manager ch\u01b0a.<\/li>\n<li>Windows Firewall tr\u00ean m\u00e1y ch\u1ee7 \u0111\u00e3 m\u1edf \u0111\u00fang TCP port ch\u01b0a.<\/li>\n<li>Firewall m\u1ea1ng, router, VPN ho\u1eb7c security group c\u00f3 \u0111ang ch\u1eb7n k\u1ebft n\u1ed1i kh\u00f4ng.<\/li>\n<li>V\u1edbi Named Instance, b\u1ea1n \u0111ang k\u1ebft n\u1ed1i b\u1eb1ng port t\u0129nh hay ph\u1ee5 thu\u1ed9c v\u00e0o SQL Server Browser.<\/li>\n<\/ul>\n<p>L\u01b0u \u00fd: Tr\u00ean m\u1ed9t s\u1ed1 m\u00e1y Windows, Telnet Client c\u00f3 th\u1ec3 ch\u01b0a \u0111\u01b0\u1ee3c c\u00e0i s\u1eb5n. Trong tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3, b\u1ea1n n\u00ean \u01b0u ti\u00ean d\u00f9ng\u00a0<code>Test-NetConnection<\/code>\u00a0v\u00ec PowerShell th\u01b0\u1eddng c\u00f3 s\u1eb5n tr\u00ean Windows Server v\u00e0 Windows client hi\u1ec7n \u0111\u1ea1i.<\/p>\n<h3>7.2. T\u1ea1o file Universal Data Link \u0111\u1ec3 ki\u1ec3m tra \u0111\u0103ng nh\u1eadp SQL Server<\/h3>\n<p>Sau khi x\u00e1c nh\u1eadn port \u0111\u00e3 th\u00f4ng, b\u1ea1n n\u00ean ki\u1ec3m tra ti\u1ebfp l\u1edbp \u0111\u0103ng nh\u1eadp v\u00e0 driver k\u1ebft n\u1ed1i. M\u1ed9t c\u00e1ch nhanh g\u1ecdn l\u00e0 t\u1ea1o file\u00a0<strong>Universal Data Link<\/strong>, th\u01b0\u1eddng g\u1ecdi l\u00e0 file\u00a0<code>.udl<\/code>.<\/p>\n<p>Ph\u01b0\u01a1ng ph\u00e1p n\u00e0y h\u1eefu \u00edch khi m\u00e1y kh\u00e1ch kh\u00f4ng c\u00e0i SQL Server Management Studio nh\u01b0ng v\u1eabn c\u1ea7n ki\u1ec3m tra xem driver OLE DB tr\u00ean m\u00e1y c\u00f3 k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c \u0111\u1ebfn SQL Server hay kh\u00f4ng.<\/p>\n<p>C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0Tr\u00ean Desktop, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn\u00a0<strong>New &gt; Text Document<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0\u0110\u1ed5i t\u00ean file th\u00e0nh:<\/p>\n<pre><code class=\"language-text\">test_connection.udl\r\n<\/code><\/pre>\n<p>H\u00e3y ch\u1eafc ch\u1eafn ph\u1ea7n m\u1edf r\u1ed9ng \u0111\u00e3 \u0111\u1ed5i t\u1eeb\u00a0<code>.txt<\/code>\u00a0sang\u00a0<code>.udl<\/code>. N\u1ebfu Windows \u0111ang \u1ea9n ph\u1ea7n m\u1edf r\u1ed9ng file, b\u1ea1n c\u1ea7n b\u1eadt t\u00f9y ch\u1ecdn hi\u1ec3n th\u1ecb file extension tr\u01b0\u1edbc.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Nh\u1ea5p \u0111\u00fap v\u00e0o file\u00a0<code>test_connection.udl<\/code>. C\u1eeda s\u1ed5\u00a0<strong>Data Link Properties<\/strong>\u00a0s\u1ebd xu\u1ea5t hi\u1ec7n.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0T\u1ea1i tab\u00a0<strong>Provider<\/strong>, ch\u1ecdn provider ph\u00f9 h\u1ee3p v\u1edbi h\u1ec7 th\u1ed1ng.<\/p>\n<p>N\u1ebfu m\u00e1y \u0111\u00e3 c\u00e0i driver m\u1edbi, n\u00ean \u01b0u ti\u00ean:<\/p>\n<pre><code class=\"language-text\">Microsoft OLE DB Driver for SQL Server\r\n<\/code><\/pre>\n<p>ho\u1eb7c provider t\u01b0\u01a1ng \u1ee9ng nh\u01b0:<\/p>\n<pre><code class=\"language-text\">MSOLEDBSQL\r\n<\/code><\/pre>\n<p>N\u1ebfu ch\u1ec9 ki\u1ec3m tra ph\u1ea7n m\u1ec1m legacy, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y c\u00e1c provider c\u0169 nh\u01b0:<\/p>\n<pre><code class=\"language-text\">Microsoft OLE DB Provider for SQL Server\r\n<\/code><\/pre>\n<p>ho\u1eb7c:<\/p>\n<pre><code class=\"language-text\">SQL Server Native Client\r\n<\/code><\/pre>\n<p>Tuy nhi\u00ean, c\u00e1c provider c\u0169 kh\u00f4ng c\u00f2n l\u00e0 l\u1ef1a ch\u1ecdn khuy\u1ebfn ngh\u1ecb cho h\u1ec7 th\u1ed1ng m\u1edbi. N\u1ebfu c\u00f3 th\u1ec3, n\u00ean c\u00e0i v\u00e0 d\u00f9ng Microsoft OLE DB Driver for SQL Server phi\u00ean b\u1ea3n m\u1edbi h\u01a1n.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0Chuy\u1ec3n sang tab\u00a0<strong>Connection<\/strong>\u00a0v\u00e0 nh\u1eadp th\u00f4ng tin k\u1ebft n\u1ed1i.<\/p>\n<p>N\u1ebfu SQL Server d\u00f9ng port m\u1eb7c \u0111\u1ecbnh:<\/p>\n<pre><code class=\"language-text\">IP_MAY_CHU\r\n<\/code><\/pre>\n<p>N\u1ebfu SQL Server d\u00f9ng port t\u00f9y ch\u1ec9nh, nh\u1eadp theo d\u1ea1ng:<\/p>\n<pre><code class=\"language-text\">IP_MAY_CHU,PORT\r\n<\/code><\/pre>\n<p>V\u00ed d\u1ee5:<\/p>\n<pre><code class=\"language-text\">192.168.1.50,1433\r\n<\/code><\/pre>\n<p>ho\u1eb7c:<\/p>\n<pre><code class=\"language-text\">192.168.1.50,14330\r\n<\/code><\/pre>\n<p>Sau \u0111\u00f3 ch\u1ecdn ph\u01b0\u01a1ng th\u1ee9c x\u00e1c th\u1ef1c ph\u00f9 h\u1ee3p:<\/p>\n<ul>\n<li><strong>Windows Authentication<\/strong>\u00a0n\u1ebfu d\u00f9ng t\u00e0i kho\u1ea3n Windows\/domain.<\/li>\n<li><strong>SQL Server Authentication<\/strong>\u00a0n\u1ebfu d\u00f9ng SQL Login ri\u00eang.<\/li>\n<\/ul>\n<p>Trong m\u00f4i tr\u01b0\u1eddng th\u1ef1c t\u1ebf, kh\u00f4ng n\u00ean m\u1eb7c \u0111\u1ecbnh d\u00f9ng t\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>\u00a0cho \u1ee9ng d\u1ee5ng. T\u1ed1t h\u01a1n l\u00e0 d\u00f9ng m\u1ed9t SQL Login ri\u00eang, \u0111\u01b0\u1ee3c c\u1ea5p \u0111\u00fang quy\u1ec1n tr\u00ean database c\u1ea7n truy c\u1eadp.<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong>\u00a0Ch\u1ecdn database c\u1ea7n ki\u1ec3m tra n\u1ebfu danh s\u00e1ch database hi\u1ec3n th\u1ecb \u0111\u01b0\u1ee3c. Sau \u0111\u00f3 nh\u1ea5n\u00a0<strong>Test Connection<\/strong>.<\/p>\n<p>N\u1ebfu xu\u1ea5t hi\u1ec7n th\u00f4ng b\u00e1o:<\/p>\n<pre><code class=\"language-text\">Test connection succeeded\r\n<\/code><\/pre>\n<p>\u0111i\u1ec1u \u0111\u00f3 cho th\u1ea5y m\u00e1y kh\u00e1ch \u0111\u00e3 k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c \u0111\u1ebfn SQL Server b\u1eb1ng provider, t\u00e0i kho\u1ea3n v\u00e0 th\u00f4ng tin k\u1ebft n\u1ed1i \u0111\u00e3 nh\u1eadp.<\/p>\n<p>N\u1ebfu ki\u1ec3m tra b\u1eb1ng Telnet ho\u1eb7c PowerShell th\u00e0nh c\u00f4ng nh\u01b0ng UDL th\u1ea5t b\u1ea1i, nguy\u00ean nh\u00e2n th\u01b0\u1eddng kh\u00f4ng c\u00f2n n\u1eb1m \u1edf port m\u1ea1ng \u0111\u01a1n thu\u1ea7n. L\u00fac n\u00e0y, b\u1ea1n n\u00ean ki\u1ec3m tra ti\u1ebfp:<\/p>\n<ul>\n<li>Sai username ho\u1eb7c password.<\/li>\n<li>SQL Server ch\u01b0a b\u1eadt Mixed Mode n\u1ebfu d\u00f9ng SQL Login.<\/li>\n<li>Login b\u1ecb disabled, b\u1ecb kh\u00f3a ho\u1eb7c ch\u01b0a \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n v\u00e0o database.<\/li>\n<li>Driver OLE DB tr\u00ean m\u00e1y kh\u00e1ch qu\u00e1 c\u0169 ho\u1eb7c kh\u00f4ng t\u01b0\u01a1ng th\u00edch.<\/li>\n<li>C\u1ea5u h\u00ecnh TLS\/encryption gi\u1eefa client v\u00e0 server kh\u00f4ng t\u01b0\u01a1ng th\u00edch.<\/li>\n<li>Nh\u1eadp sai instance name, port ho\u1eb7c database name.<\/li>\n<\/ul>\n<p>T\u00f3m l\u1ea1i,\u00a0<code>Test-NetConnection<\/code>\u00a0ho\u1eb7c Telnet gi\u00fap ki\u1ec3m tra l\u1edbp m\u1ea1ng v\u00e0 port. File\u00a0<code>.udl<\/code>\u00a0gi\u00fap ki\u1ec3m tra s\u00e2u h\u01a1n \u1edf l\u1edbp driver, x\u00e1c th\u1ef1c v\u00e0 quy\u1ec1n truy c\u1eadp SQL Server. N\u00ean k\u1ebft h\u1ee3p c\u1ea3 hai ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh l\u1ed7i n\u1eb1m \u1edf h\u1ea1 t\u1ea7ng k\u1ebft n\u1ed1i hay \u1edf c\u1ea5u h\u00ecnh \u0111\u0103ng nh\u1eadp c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/p>\n<h2 id=\"section8\" style=\"color: #1e3a8a; font-size: 24px; font-weight: bold; text-align: left; border-left: 5px solid #2563EB; padding-left: 15px; margin-top: 40px; margin-bottom: 20px; line-height: 1.4;\">8. Khi n\u00e0o n\u00ean chuy\u1ec3n t\u1eeb Hosting l\u00ean VPS ho\u1eb7c Cloud Server \u0111\u1ec3 ch\u1ea1y SQL Server?<\/h2>\n<p style=\"text-align: justify;\">\u0110\u1ed1i v\u1edbi c\u00e1c d\u1ef1 \u00e1n Website ho\u1eb7c \u1ee9ng d\u1ee5ng nh\u1ecf l\u00fac m\u1edbi b\u1eaft \u0111\u1ea7u, vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c d\u1ecbch v\u1ee5 Hosting chia s\u1ebb (Shared Hosting) c\u00f3 th\u1ec3 gi\u00fap t\u1ed1i \u01b0u h\u00f3a chi ph\u00ed v\u1eadn h\u00e0nh ban \u0111\u1ea7u. M\u1eb7c d\u00f9 v\u1eady, khi C\u01a1 S\u1edf D\u1eef Li\u1ec7u SQL Server b\u1eaft \u0111\u1ea7u ph\u00ecnh to, l\u01b0\u1ee3ng truy v\u1ea5n \u0111\u1ed3ng th\u1eddi t\u0103ng l\u00ean v\u00e0 y\u00eau c\u1ea7u v\u1ec1 t\u00ednh b\u1ea3o m\u1eadt d\u1eef li\u1ec7u tr\u1edf n\u00ean kh\u1eaft khe h\u01a1n, m\u00f4 h\u00ecnh Hosting chia s\u1ebb s\u1ebd b\u1ed9c l\u1ed9 nhi\u1ec1u h\u1ea1n ch\u1ebf v\u1ec1 m\u1eb7t t\u00e0i nguy\u00ean v\u00e0 quy\u1ec1n ki\u1ec3m so\u00e1t h\u1ec7 th\u1ed1ng.<\/p>\n<p style=\"text-align: justify;\">M\u00f4 h\u00ecnh Shared Hosting ph\u00e2n chia t\u00e0i nguy\u00ean m\u00e1y ch\u1ee7 cho h\u00e0ng tr\u0103m t\u00e0i kho\u1ea3n kh\u00e1c nhau, d\u1eabn \u0111\u1ebfn vi\u1ec7c L\u1ed7i Database c\u1ee7a b\u1ea1n d\u1ec5 x\u1ea3y ra ho\u1eb7c b\u1ecb \u1ea3nh h\u01b0\u1edfng hi\u1ec7u n\u0103ng n\u1ebfu c\u00e1c website kh\u00e1c tr\u00ean c\u00f9ng h\u1ec7 th\u1ed1ng g\u1eb7p qu\u00e1 t\u1ea3i. Do \u0111\u00f3, vi\u1ec7c n\u00e2ng c\u1ea5p l\u00ean m\u00f4i tr\u01b0\u1eddng chuy\u00ean d\u1ee5ng nh\u01b0 VPS ho\u1eb7c Cloud Server l\u00e0 b\u01b0\u1edbc chuy\u1ec3n d\u1ecbch c\u1ea7n thi\u1ebft gi\u00fap doanh nghi\u1ec7p l\u00e0m ch\u1ee7 h\u1ea1 t\u1ea7ng c\u00f4ng ngh\u1ec7.<\/p>\n<p style=\"text-align: justify;\">D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c ti\u00eau ch\u00ed so s\u00e1nh chi ti\u1ebft gi\u00fap b\u1ea1n \u0111\u01b0a ra l\u1ef1a ch\u1ecdn n\u00e2ng c\u1ea5p h\u1ea1 t\u1ea7ng ph\u00f9 h\u1ee3p:<\/p>\n<table style=\"width: 100%; border-collapse: collapse; margin: 20px 0; font-size: 15px; text-align: left; color: #1f2937;\">\n<thead>\n<tr style=\"background-color: #1e3a8a; color: white;\">\n<th style=\"padding: 12px; border: 1px solid #D1D5DB;\">Ti\u00eau Ch\u00ed K\u1ef9 Thu\u1eadt<\/th>\n<th style=\"padding: 12px; border: 1px solid #D1D5DB;\">Shared Hosting (C\u01a1 B\u1ea3n)<\/th>\n<th style=\"padding: 12px; border: 1px solid #D1D5DB;\">Thu\u00ea VPS (T\u1ea7m Trung)<\/th>\n<th style=\"padding: 12px; border: 1px solid #D1D5DB;\">Cloud Server (Cao C\u1ea5p)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr style=\"background-color: #f9fafb;\">\n<td style=\"padding: 12px; border: 1px solid #D1D5DB; font-weight: bold;\">Quy\u1ec1n Qu\u1ea3n Tr\u1ecb Cao Nh\u1ea5t<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">Kh\u00f4ng c\u00f3 quy\u1ec1n Root\/Administrator. Kh\u00f4ng c\u1ea5u h\u00ecnh s\u00e2u h\u1ec7 th\u1ed1ng \u0111\u01b0\u1ee3c.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">To\u00e0n quy\u1ec1n Root\/Administrator. T\u1ef1 do c\u1ea5u h\u00ecnh c\u1ed5ng, b\u1eadt t\u1eaft d\u1ecbch v\u1ee5.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">To\u00e0n quy\u1ec1n Administrator, qu\u1ea3n l\u00fd h\u1ea1 t\u1ea7ng \u1ea3o h\u00f3a ch\u1ee7 \u0111\u1ed9ng qua Portal.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB; font-weight: bold;\">T\u00e0i Nguy\u00ean CPU\/RAM<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">Chia s\u1ebb chung v\u1edbi h\u00e0ng tr\u0103m website kh\u00e1c, d\u1ec5 b\u1ecb ngh\u1ebdn truy v\u1ea5n SQL.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">T\u00e0i nguy\u00ean ph\u00e2n t\u00e1ch ri\u00eang bi\u1ec7t, \u0111\u1ea3m b\u1ea3o \u0111\u1ed9 \u1ed5n \u0111\u1ecbnh cho c\u00e1c t\u00e1c v\u1ee5 t\u00ednh to\u00e1n.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">T\u00e0i nguy\u00ean chuy\u00ean d\u1ee5ng c\u1ea5p ph\u00e1t th\u1ef1c t\u1ebf, cam k\u1ebft hi\u1ec7u n\u0103ng cao kh\u00f4ng ngh\u1ebdn c\u1ed5 chai.<\/td>\n<\/tr>\n<tr style=\"background-color: #f9fafb;\">\n<td style=\"padding: 12px; border: 1px solid #D1D5DB; font-weight: bold;\">Kh\u1ea3 N\u0103ng M\u1edf R\u1ed9ng (Scale)<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">B\u1ecb gi\u1edbi h\u1ea1n b\u1edfi c\u1ea5u h\u00ecnh g\u00f3i c\u1ee9ng nh\u1eafc t\u1eeb nh\u00e0 cung c\u1ea5p d\u1ecbch v\u1ee5.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">C\u00f3 th\u1ec3 n\u00e2ng c\u1ea5p g\u00f3i d\u1ecbch v\u1ee5 khi nhu c\u1ea7u l\u01b0u tr\u1eef t\u0103ng l\u00ean.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">M\u1edf r\u1ed9ng t\u1ee9c th\u00ec dung l\u01b0\u1ee3ng l\u01b0u tr\u1eef, RAM v\u00e0 vCPU ch\u1ec9 v\u1edbi v\u00e0i c\u00fa nh\u1ea5p chu\u1ed9t.<\/td>\n<\/tr>\n<tr>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB; font-weight: bold;\">T\u1ed1c \u0110\u1ed9 \u0110\u1ecdc\/Ghi D\u1eef Li\u1ec7u (I\/O)<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">Th\u1ea5p do d\u00f9ng chung \u1ed5 c\u1ee9ng, \u1ea3nh h\u01b0\u1edfng l\u1edbn \u0111\u1ebfn th\u1eddi gian ph\u1ea3n h\u1ed3i DB.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">R\u1ea5t nhanh nh\u1edd s\u1eed d\u1ee5ng c\u00e1c d\u00f2ng \u1ed5 c\u1ee9ng SSD NVMe chuy\u00ean d\u1ee5ng.<\/td>\n<td style=\"padding: 12px; border: 1px solid #D1D5DB;\">B\u0103ng th\u00f4ng \u0111\u1ecdc ghi c\u1ef1c cao, ph\u00f9 h\u1ee3p ch\u1ea1y c\u00e1c h\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u si\u00eau l\u1edbn.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Th\u1ef1c t\u1ebf v\u1eadn h\u00e0nh cho th\u1ea5y, vi\u1ec7c s\u1edf h\u1eefu quy\u1ec1n qu\u1ea3n tr\u1ecb cao nh\u1ea5t tr\u00ean M\u00e1y Ch\u1ee7 \u1ea2o l\u00e0 y\u1ebfu t\u1ed1 c\u1ef1c k\u1ef3 quan tr\u1ecdng gi\u00fap kh\u1eafc ph\u1ee5c tri\u1ec7t \u0111\u1ec3 l\u1ed7i SQL Cannot Connect To Server. Khi c\u00f3 to\u00e0n quy\u1ec1n thao t\u00e1c tr\u00ean VPS ho\u1eb7c Cloud Server, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 do ch\u1ec9nh s\u1eeda file c\u1ea5u h\u00ecnh, m\u1edf c\u00e1c Port b\u1ea3o m\u1eadt \u0111\u1eb7c th\u00f9, ph\u00e2n quy\u1ec1n cho d\u1ecbch v\u1ee5 SQL Server v\u00e0 ch\u1ee7 \u0111\u1ed9ng sao l\u01b0u d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng b\u1ecb gi\u1edbi h\u1ea1n b\u1edfi b\u1ea5t k\u1ef3 ch\u00ednh s\u00e1ch ki\u1ec3m so\u00e1t d\u00f9ng chung n\u00e0o c\u1ee7a m\u00f4i tr\u01b0\u1eddng Hosting.<\/p>\n<div style=\"background-color: #f9fafb; border: 1px solid #E5E7EB; border-radius: 12px; padding: 25px; margin-bottom: 40px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.02);\">\n<h2>C\u00c2U H\u1eceI TH\u01af\u1edcNG G\u1eb6P (FAQ)<\/h2>\n<h3>1. T\u1ea1i sao t\u00f4i k\u1ebft n\u1ed1i SQL Server local \u0111\u01b0\u1ee3c nh\u01b0ng k\u1ebft n\u1ed1i qua IP m\u1ea1ng LAN l\u1ea1i b\u00e1o l\u1ed7i?<\/h3>\n<p>Tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u01b0\u1eddng x\u1ea3y ra khi SQL Server ch\u1ec9 \u0111ang ho\u1ea1t \u0111\u1ed9ng t\u1ed1t tr\u00ean m\u00e1y c\u1ee5c b\u1ed9 nh\u01b0ng ch\u01b0a s\u1eb5n s\u00e0ng nh\u1eadn k\u1ebft n\u1ed1i t\u1eeb m\u00e1y kh\u00e1c trong m\u1ea1ng LAN.<\/p>\n<p>M\u1ed9t s\u1ed1 nguy\u00ean nh\u00e2n ph\u1ed5 bi\u1ebfn g\u1ed3m:<\/p>\n<ul>\n<li>Giao th\u1ee9c TCP\/IP c\u1ee7a SQL Server ch\u01b0a \u0111\u01b0\u1ee3c b\u1eadt.<\/li>\n<li>SQL Server ch\u01b0a l\u1eafng nghe \u0111\u00fang port.<\/li>\n<li>Windows Firewall \u0111ang ch\u1eb7n port k\u1ebft n\u1ed1i.<\/li>\n<li>B\u1ea1n nh\u1eadp sai IP, sai t\u00ean m\u00e1y ch\u1ee7 ho\u1eb7c sai t\u00ean instance.<\/li>\n<li>V\u1edbi Named Instance nh\u01b0\u00a0<code>SQLEXPRESS<\/code>, m\u00e1y kh\u00e1ch kh\u00f4ng x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c port n\u1ebfu SQL Server Browser ch\u01b0a ch\u1ea1y ho\u1eb7c UDP port\u00a0<code>1434<\/code>\u00a0b\u1ecb ch\u1eb7n.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 x\u1eed l\u00fd, h\u00e3y ki\u1ec3m tra l\u1ea1i trong\u00a0<strong>SQL Server Configuration Manager<\/strong>, b\u1eadt\u00a0<strong>TCP\/IP<\/strong>\u00a0cho \u0111\u00fang instance, c\u1ea5u h\u00ecnh port t\u0129nh n\u1ebfu c\u1ea7n, restart d\u1ecbch v\u1ee5 SQL Server v\u00e0 m\u1edf \u0111\u00fang port tr\u00ean Windows Firewall.<\/p>\n<p>N\u1ebfu d\u00f9ng Default Instance, port th\u01b0\u1eddng g\u1eb7p l\u00e0\u00a0<code>1433<\/code>. N\u1ebfu d\u00f9ng Named Instance ho\u1eb7c port t\u00f9y ch\u1ec9nh, h\u00e3y ki\u1ec3m tra port th\u1ef1c t\u1ebf tr\u01b0\u1edbc khi m\u1edf Firewall.<\/p>\n<hr \/>\n<h3>2. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eeda l\u1ed7i SQL Error 18456 \u201cLogin failed for user &#8216;sa&#8217;\u201d?<\/h3>\n<p>SQL Error\u00a0<code>18456<\/code>\u00a0l\u00e0 l\u1ed7i x\u00e1c th\u1ef1c \u0111\u0103ng nh\u1eadp. L\u1ed7i n\u00e0y kh\u00f4ng ch\u1ec9 x\u1ea3y ra v\u1edbi t\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>, m\u00e0 c\u00f3 th\u1ec3 x\u1ea3y ra v\u1edbi b\u1ea5t k\u1ef3 t\u00e0i kho\u1ea3n SQL Server ho\u1eb7c Windows Login n\u00e0o.<\/p>\n<p>C\u00e1c nguy\u00ean nh\u00e2n th\u01b0\u1eddng g\u1eb7p g\u1ed3m:<\/p>\n<ul>\n<li>Sai username ho\u1eb7c password.<\/li>\n<li>SQL Server \u0111ang \u1edf ch\u1ebf \u0111\u1ed9\u00a0<strong>Windows Authentication mode<\/strong>, trong khi b\u1ea1n l\u1ea1i \u0111\u0103ng nh\u1eadp b\u1eb1ng SQL Login nh\u01b0\u00a0<code>sa<\/code>.<\/li>\n<li>T\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>\u00a0ho\u1eb7c SQL Login \u0111ang b\u1ecb disabled.<\/li>\n<li>M\u1eadt kh\u1ea9u h\u1ebft h\u1ea1n ho\u1eb7c t\u00e0i kho\u1ea3n b\u1ecb kh\u00f3a.<\/li>\n<li>Login ch\u01b0a \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n truy c\u1eadp v\u00e0o database c\u1ea7n d\u00f9ng.<\/li>\n<li>\u1ee8ng d\u1ee5ng \u0111ang d\u00f9ng sai chu\u1ed7i k\u1ebft n\u1ed1i.<\/li>\n<\/ul>\n<p>N\u1ebfu c\u1ea7n \u0111\u0103ng nh\u1eadp b\u1eb1ng t\u00e0i kho\u1ea3n SQL Server nh\u01b0\u00a0<code>sa<\/code>\u00a0ho\u1eb7c m\u1ed9t SQL Login ri\u00eang, b\u1ea1n c\u1ea7n b\u1eadt\u00a0<strong>Mixed Mode Authentication<\/strong>\u00a0trong SSMS:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf SSMS v\u00e0 \u0111\u0103ng nh\u1eadp b\u1eb1ng t\u00e0i kho\u1ea3n c\u00f3 quy\u1ec1n qu\u1ea3n tr\u1ecb.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong>\u00a0Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean Server, ch\u1ecdn\u00a0<strong>Properties<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong>\u00a0Ch\u1ecdn m\u1ee5c\u00a0<strong>Security<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong>\u00a0T\u1ea1i ph\u1ea7n\u00a0<strong>Server authentication<\/strong>, ch\u1ecdn:<\/p>\n<pre><code class=\"language-text\">SQL Server and Windows Authentication mode\r\n<\/code><\/pre>\n<p><strong>B\u01b0\u1edbc 5:<\/strong>\u00a0Nh\u1ea5n\u00a0<strong>OK<\/strong>\u00a0v\u00e0 restart d\u1ecbch v\u1ee5 SQL Server.<\/p>\n<p>Sau \u0111\u00f3, h\u00e3y ki\u1ec3m tra l\u1ea1i t\u00e0i kho\u1ea3n \u0111\u0103ng nh\u1eadp. N\u1ebfu d\u00f9ng\u00a0<code>sa<\/code>, c\u1ea7n \u0111\u1ea3m b\u1ea3o t\u00e0i kho\u1ea3n n\u00e0y \u0111ang \u0111\u01b0\u1ee3c b\u1eadt v\u00e0 c\u00f3 m\u1eadt kh\u1ea9u \u0111\u00fang. Trong m\u00f4i tr\u01b0\u1eddng th\u1ef1c t\u1ebf, kh\u00f4ng n\u00ean d\u00f9ng\u00a0<code>sa<\/code>\u00a0cho \u1ee9ng d\u1ee5ng. T\u1ed1t h\u01a1n l\u00e0 t\u1ea1o m\u1ed9t SQL Login ri\u00eang, c\u1ea5p \u0111\u00fang quy\u1ec1n c\u1ea7n thi\u1ebft tr\u00ean database t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<hr \/>\n<h3>3. Vi\u1ec7c b\u1eadt d\u1ecbch v\u1ee5 SQL Server Browser c\u00f3 th\u1ef1c s\u1ef1 b\u1eaft bu\u1ed9c kh\u00f4ng?<\/h3>\n<p>Kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng b\u1eaft bu\u1ed9c b\u1eadt SQL Server Browser.<\/p>\n<p>D\u1ecbch v\u1ee5\u00a0<strong>SQL Server Browser<\/strong>\u00a0th\u01b0\u1eddng c\u1ea7n thi\u1ebft khi b\u1ea1n k\u1ebft n\u1ed1i \u0111\u1ebfn\u00a0<strong>Named Instance<\/strong>\u00a0theo d\u1ea1ng:<\/p>\n<pre><code class=\"language-text\">TEN_SERVER\\TEN_INSTANCE\r\n<\/code><\/pre>\n<p>V\u00ed d\u1ee5:<\/p>\n<pre><code class=\"language-text\">192.168.1.50\\SQLEXPRESS\r\n<\/code><\/pre>\n<p>SQL Server Browser gi\u00fap m\u00e1y kh\u00e1ch x\u00e1c \u0111\u1ecbnh Named Instance \u0111\u00f3 \u0111ang ch\u1ea1y tr\u00ean port n\u00e0o. D\u1ecbch v\u1ee5 n\u00e0y s\u1eed d\u1ee5ng giao th\u1ee9c\u00a0<strong>UDP port 1434<\/strong>.<\/p>\n<p>Tuy nhi\u00ean, n\u1ebfu b\u1ea1n \u0111\u00e3 c\u1ea5u h\u00ecnh Named Instance d\u00f9ng port t\u0129nh v\u00e0 k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp b\u1eb1ng d\u1ea1ng:<\/p>\n<pre><code class=\"language-text\">IP_MAY_CHU,PORT\r\n<\/code><\/pre>\n<p>v\u00ed d\u1ee5:<\/p>\n<pre><code class=\"language-text\">192.168.1.50,14330\r\n<\/code><\/pre>\n<p>th\u00ec kh\u00f4ng nh\u1ea5t thi\u1ebft ph\u1ea3i b\u1eadt SQL Server Browser.<\/p>\n<p>V\u1edbi m\u00f4i tr\u01b0\u1eddng production ho\u1eb7c h\u1ec7 th\u1ed1ng y\u00eau c\u1ea7u b\u1ea3o m\u1eadt cao, c\u00e1ch d\u1ec5 ki\u1ec3m so\u00e1t h\u01a1n l\u00e0 c\u1ea5u h\u00ecnh SQL Server d\u00f9ng port t\u0129nh, m\u1edf \u0111\u00fang TCP port tr\u00ean Firewall v\u00e0 cho \u1ee9ng d\u1ee5ng k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp b\u1eb1ng\u00a0<code>IP,PORT<\/code>.<\/p>\n<hr \/>\n<h3>4. T\u00f4i n\u00ean c\u1ea5u h\u00ecnh Dynamic Port hay Static Port cho h\u1ec7 th\u1ed1ng SQL Server production?<\/h3>\n<p>V\u1edbi h\u1ec7 th\u1ed1ng SQL Server production, n\u00ean \u01b0u ti\u00ean d\u00f9ng\u00a0<strong>Static Port<\/strong>\u00a0thay v\u00ec\u00a0<strong>Dynamic Port<\/strong>.<\/p>\n<p>Dynamic Port c\u00f3 th\u1ec3 khi\u1ebfn port SQL Server thay \u0111\u1ed5i khi d\u1ecbch v\u1ee5 kh\u1edfi \u0111\u1ed9ng l\u1ea1i. \u0110i\u1ec1u n\u00e0y g\u00e2y kh\u00f3 kh\u0103n cho vi\u1ec7c c\u1ea5u h\u00ecnh Firewall, gi\u00e1m s\u00e1t h\u1ec7 th\u1ed1ng v\u00e0 thi\u1ebft l\u1eadp chu\u1ed7i k\u1ebft n\u1ed1i \u1ed5n \u0111\u1ecbnh cho \u1ee9ng d\u1ee5ng.<\/p>\n<p>Static Port gi\u00fap k\u1ef9 thu\u1eadt vi\u00ean ki\u1ec3m so\u00e1t r\u00f5 SQL Server \u0111ang l\u1eafng nghe \u1edf port n\u00e0o. Nh\u1edd \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf \u0111\u00fang Firewall rule, c\u1ea5u h\u00ecnh \u1ee9ng d\u1ee5ng ch\u00ednh x\u00e1c v\u00e0 d\u1ec5 ki\u1ec3m tra l\u1ed7i h\u01a1n.<\/p>\n<p>Port t\u0129nh ph\u1ed5 bi\u1ebfn c\u1ee7a Default Instance l\u00e0\u00a0<code>1433<\/code>. Tuy nhi\u00ean, b\u1ea1n kh\u00f4ng b\u1eaft bu\u1ed9c ph\u1ea3i d\u00f9ng\u00a0<code>1433<\/code>\u00a0trong m\u1ecdi tr\u01b0\u1eddng h\u1ee3p. N\u1ebfu m\u00e1y ch\u1ee7 c\u00f3 nhi\u1ec1u SQL Server Instance ho\u1eb7c ch\u00ednh s\u00e1ch b\u1ea3o m\u1eadt n\u1ed9i b\u1ed9 y\u00eau c\u1ea7u port ri\u00eang, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea5u h\u00ecnh m\u1ed9t port c\u1ed1 \u0111\u1ecbnh kh\u00e1c, v\u00ed d\u1ee5:<\/p>\n<pre><code class=\"language-text\">14330\r\n<\/code><\/pre>\n<p>ho\u1eb7c port ph\u00f9 h\u1ee3p v\u1edbi quy chu\u1ea9n h\u1ec7 th\u1ed1ng c\u1ee7a b\u1ea1n.<\/p>\n<p>Sau khi thay \u0111\u1ed5i port trong\u00a0<strong>TCP\/IP Properties &gt; IPAll<\/strong>, h\u00e3y restart d\u1ecbch v\u1ee5 SQL Server v\u00e0 m\u1edf \u0111\u00fang TCP port t\u01b0\u01a1ng \u1ee9ng tr\u00ean Windows Firewall.<\/p>\n<hr \/>\n<h3>5. L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ea3o m\u1eadt port SQL Server sau khi m\u1edf Remote Connection?<\/h3>\n<p>Kh\u00f4ng n\u00ean m\u1edf c\u00f4ng khai port SQL Server, \u0111\u1eb7c bi\u1ec7t l\u00e0 TCP port\u00a0<code>1433<\/code>, cho m\u1ecdi IP tr\u00ean Internet. Vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 khi\u1ebfn m\u00e1y ch\u1ee7 \u0111\u1ed1i m\u1eb7t v\u1edbi c\u00e1c cu\u1ed9c d\u00f2 qu\u00e9t, brute force m\u1eadt kh\u1ea9u ho\u1eb7c khai th\u00e1c l\u1ed7i b\u1ea3o m\u1eadt n\u1ebfu h\u1ec7 th\u1ed1ng ch\u01b0a \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt \u0111\u1ea7y \u0111\u1ee7.<\/p>\n<p>\u0110\u1ec3 b\u1ea3o m\u1eadt k\u1ebft n\u1ed1i SQL Server, b\u1ea1n n\u00ean \u00e1p d\u1ee5ng c\u00e1c nguy\u00ean t\u1eafc sau:<\/p>\n<ul>\n<li>Ch\u1ec9 cho ph\u00e9p IP t\u0129nh c\u1ee7a m\u00e1y ch\u1ee7 \u1ee9ng d\u1ee5ng, m\u00e1y qu\u1ea3n tr\u1ecb ho\u1eb7c d\u1ea3i IP VPN n\u1ed9i b\u1ed9 truy c\u1eadp v\u00e0o port SQL Server.<\/li>\n<li>Kh\u00f4ng m\u1edf port SQL Server cho profile\u00a0<strong>Public<\/strong>\u00a0n\u1ebfu kh\u00f4ng th\u1eadt s\u1ef1 c\u1ea7n thi\u1ebft.<\/li>\n<li>\u01afu ti\u00ean k\u1ebft n\u1ed1i qua VPN, private network ho\u1eb7c m\u1ea1ng n\u1ed9i b\u1ed9 thay v\u00ec m\u1edf tr\u1ef1c ti\u1ebfp ra Internet.<\/li>\n<li>Kh\u00f4ng d\u00f9ng t\u00e0i kho\u1ea3n\u00a0<code>sa<\/code>\u00a0cho \u1ee9ng d\u1ee5ng.<\/li>\n<li>T\u1ea1o SQL Login ri\u00eang cho t\u1eebng \u1ee9ng d\u1ee5ng v\u00e0 c\u1ea5p quy\u1ec1n t\u1ed1i thi\u1ec3u c\u1ea7n thi\u1ebft.<\/li>\n<li>S\u1eed d\u1ee5ng m\u1eadt kh\u1ea9u m\u1ea1nh v\u00e0 ch\u00ednh s\u00e1ch kh\u00f3a t\u00e0i kho\u1ea3n ph\u00f9 h\u1ee3p.<\/li>\n<li>C\u1eadp nh\u1eadt SQL Server, Windows Server v\u00e0 driver k\u1ebft n\u1ed1i \u0111\u1ecbnh k\u1ef3.<\/li>\n<li>Theo d\u00f5i log \u0111\u0103ng nh\u1eadp th\u1ea5t b\u1ea1i \u0111\u1ec3 ph\u00e1t hi\u1ec7n h\u00e0nh vi d\u00f2 m\u1eadt kh\u1ea9u b\u1ea5t th\u01b0\u1eddng.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5, thay v\u00ec m\u1edf port\u00a0<code>1433<\/code>\u00a0cho m\u1ecdi IP, b\u1ea1n n\u00ean gi\u1edbi h\u1ea1n Firewall ch\u1ec9 cho ph\u00e9p m\u1ed9t IP ho\u1eb7c m\u1ed9t d\u1ea3i m\u1ea1ng c\u1ee5 th\u1ec3:<\/p>\n<pre><code class=\"language-powershell\">New-NetFirewallRule -DisplayName \"SQL Server - TCP 1433 Limited\" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow -Profile Domain,Private -RemoteAddress 192.168.1.0\/24\r\n<\/code><\/pre>\n<p>N\u1ebfu SQL Server d\u00f9ng port kh\u00e1c, h\u00e3y thay\u00a0<code>1433<\/code>\u00a0b\u1eb1ng port th\u1ef1c t\u1ebf \u0111\u00e3 c\u1ea5u h\u00ecnh.<\/p>\n<p>T\u00f3m l\u1ea1i, m\u1edf port SQL Server ch\u1ec9 l\u00e0 b\u01b0\u1edbc cho ph\u00e9p k\u1ebft n\u1ed1i. \u0110\u1ec3 v\u1eadn h\u00e0nh an to\u00e0n, b\u1ea1n c\u1ea7n gi\u1edbi h\u1ea1n IP truy c\u1eadp, d\u00f9ng t\u00e0i kho\u1ea3n \u0111\u00fang quy\u1ec1n, tr\u00e1nh m\u1edf tr\u1ef1c ti\u1ebfp ra Internet v\u00e0 duy tr\u00ec c\u1eadp nh\u1eadt b\u1ea3o m\u1eadt th\u01b0\u1eddng xuy\u00ean.<\/p>\n<\/div>\n<div style=\"border-top: 2px dashed #BFDBFE; margin-top: 50px; padding-top: 30px;\">\n<div style=\"background: #EFF6FF; border: 1px solid #2563EB; padding: 30px; margin-top: 25px; border-radius: 12px; text-align: center;\">\n<p style=\"font-family: 'Be Vietnam Pro', sans-serif; font-size: 20px; font-weight: bold; color: #1e3a8a; margin-top: 0;\">Kh\u1edfi t\u1ea1o VPS ch\u1ea1y SQL Server hi\u1ec7u n\u0103ng cao<\/p>\n<p style=\"font-size: 15px; margin-bottom: 20px; color: #4b5563;\">S\u1edf h\u1eefu ngay h\u1ea1 t\u1ea7ng M\u00e1y Ch\u1ee7 \u1ea2o m\u1ea1nh m\u1ebd, b\u1ea3o m\u1eadt v\u00e0 to\u00e0n quy\u1ec1n qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng.<\/p>\n<p><a style=\"background: #2563EB; color: #ffffff; padding: 12px 30px; text-decoration: none; font-weight: 600; border-radius: 6px; display: inline-block;\" href=\"https:\/\/interdata.vn\/thue-vps\/\" target=\"_blank\" rel=\"noopener\">\u0110\u0103ng k\u00fd thu\u00ea VPS InterData ngay \u27f6<\/a><\/p>\n<\/div>\n<\/div>\n<p style=\"text-align: justify; font-size: 13px; font-style: italic; color: #6b7280; margin-top: 30px; border-top: 1px solid #E5E7EB; padding-top: 15px;\"><span style=\"font-size: 100%;\"><em>L\u01b0u \u00fd k\u1ef9 thu\u1eadt: N\u1ed9i dung h\u01b0\u1edbng d\u1eabn x\u1eed l\u00fd l\u1ed7i trong b\u00e0i vi\u1ebft n\u00e0y mang t\u00ednh ch\u1ea5t tham kh\u1ea3o chung d\u1ef1a tr\u00ean c\u00e1c c\u1ea5u h\u00ecnh ti\u00eau chu\u1ea9n c\u1ee7a h\u1ec7 th\u1ed1ng SQL Server. Tr\u00ean th\u1ef1c t\u1ebf, c\u00e1c c\u00e2u l\u1ec7nh, \u0111\u01b0\u1eddng d\u1eabn qu\u1ea3n l\u00fd v\u00e0 c\u1ea5u h\u00ecnh c\u1ed5ng c\u00f3 th\u1ec3 thay \u0111\u1ed5i t\u00f9y thu\u1ed9c v\u00e0o phi\u00ean b\u1ea3n h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows Server, phi\u00ean b\u1ea3n C\u01a1 S\u1edf D\u1eef Li\u1ec7u c\u1ee5 th\u1ec3 v\u00e0 c\u00e1c ch\u00ednh s\u00e1ch b\u1ea3o m\u1eadt m\u1ea1ng hi\u1ec7n h\u00e0nh t\u1ea1i \u0111\u01a1n v\u1ecb. K\u1ef9 thu\u1eadt vi\u00ean n\u00ean ti\u1ebfn h\u00e0nh ki\u1ec3m th\u1eed c\u00e1c thi\u1ebft l\u1eadp tr\u00ean m\u00f4i tr\u01b0\u1eddng th\u1eed nghi\u1ec7m (Staging\/Sandbox), \u0111\u1ed3ng th\u1eddi th\u1ef1c hi\u1ec7n sao l\u01b0u (Backup) C\u01a1 S\u1edf D\u1eef Li\u1ec7u \u0111\u1ea7y \u0111\u1ee7 tr\u01b0\u1edbc khi \u00e1p d\u1ee5ng b\u1ea5t k\u1ef3 thay \u0111\u1ed5i c\u1ea5u h\u00ecnh n\u00e0o tr\u00ean h\u1ec7 th\u1ed1ng \u0111ang ho\u1ea1t \u0111\u1ed9ng th\u1ef1c t\u1ebf (Production).<\/em><\/span><\/p>\n\n\n<style>\n.interdata-plan-carousel,.interdata-plan-carousel *{box-sizing:border-box}\n.interdata-plan-carousel{--blue:#005bea;--blue-dark:#004dcc;--text:#071832;--muted:#516173;--border:#d8e6fb;--bg:#f3f8ff;--shadow:0 5px 14px rgba(0,62,145,.08);container-type:inline-size;background:var(--bg);padding:14px 40px 18px;position:relative;overflow:hidden}\n.interdata-carousel-heading{color:#f00;font-family:Roboto,sans-serif;font-size:18px;line-height:1.35;font-weight:800;text-align:center;margin:0 0 14px}\n.interdata-plan-viewport{overflow:hidden;width:100%}\n.interdata-plan-track{display:flex;gap:12px;overflow-x:auto;scroll-snap-type:x mandatory;scroll-behavior:smooth;-webkit-overflow-scrolling:touch;scrollbar-width:none;padding:0 0 4px}\n.interdata-plan-track::-webkit-scrollbar{display:none}\n.interdata-plan-card{flex:0 0 calc((100% - 36px)\/4);min-width:0;background:#fff;border:1px solid var(--border);border-radius:8px;padding:15px 10px 13px;min-height:370px;display:flex;flex-direction:column;scroll-snap-align:start;box-shadow:var(--shadow)}\n.interdata-plan-title{color:var(--blue-dark);font-size:16px;line-height:1.22;font-weight:800;text-align:center;margin:0 0 7px;text-transform:uppercase;white-space:nowrap;overflow:hidden;text-overflow:ellipsis}\n.interdata-plan-price{color:var(--blue-dark);font-size:24px;line-height:1;font-weight:900;text-align:center;margin-bottom:12px;white-space:nowrap;letter-spacing:0}\n.interdata-plan-price span{font-size:10px;font-weight:800;margin-left:2px}\n.interdata-plan-badge{align-self:center;display:inline-flex;align-items:center;justify-content:center;background:#ff3934;color:#fff;border-radius:5px;padding:7px 8px;font-size:9px;line-height:1;font-weight:800;margin-bottom:15px;white-space:nowrap;max-width:100%}\n.interdata-plan-features{list-style:none!important;padding:0!important;margin:0!important}\n.interdata-plan-features li{display:flex;gap:7px;align-items:flex-start;color:var(--text);font-size:12px;line-height:1.35;font-weight:700;text-align:left;margin:0 0 10px!important;padding:0!important}\n.interdata-plan-icon{width:14px;min-width:14px;height:14px;color:#0069ff;margin-top:2px}\n.interdata-plan-icon svg{display:block;width:100%;height:100%;fill:none;stroke:currentColor;stroke-width:2;stroke-linecap:round;stroke-linejoin:round}\n.interdata-plan-spacer{flex:1;min-height:16px}\n.interdata-plan-button{display:flex;align-items:center;justify-content:center;min-height:42px;width:100%;background:var(--blue);color:#fff!important;border-radius:5px;font-size:13px;font-weight:800;text-decoration:none!important;box-shadow:0 7px 14px rgba(0,91,234,.24);transition:transform .2s ease,background .2s ease}\n.interdata-plan-button:hover{background:var(--blue-dark);color:#fff!important;transform:translateY(-1px)}\n.interdata-carousel-arrow{position:absolute;top:50%;z-index:5;width:44px;height:54px;border:2px solid #fff!important;border-radius:999px;background:var(--blue)!important;color:#fff!important;box-shadow:0 8px 22px rgba(0,62,145,.32);display:flex!important;align-items:center;justify-content:center;cursor:pointer;transform:translateY(-35%);transition:background .2s ease,color .2s ease,opacity .2s ease,transform .2s ease}\n.interdata-carousel-arrow:hover{background:var(--blue-dark)!important;color:#fff!important;transform:translateY(-35%) scale(1.04)}\n.interdata-carousel-arrow:disabled{opacity:.78;cursor:not-allowed;background:#8aa6cf!important;color:#fff!important}\n.interdata-carousel-arrow:disabled:hover{background:#8aa6cf!important;color:#fff!important;transform:translateY(-35%)}\n.interdata-carousel-arrow svg{display:none!important}\n.interdata-carousel-arrow:before{content:none!important;display:none!important}\n.interdata-carousel-mark{display:block!important;color:#fff!important;font-family:Arial,Helvetica,sans-serif!important;font-size:38px!important;font-weight:900!important;line-height:1!important;text-align:center!important;pointer-events:none!important;transform:translateY(-2px)}\n.interdata-carousel-prev{left:14px}\n.interdata-carousel-prev .interdata-carousel-mark{margin-left:-2px}\n.interdata-carousel-next{right:14px}\n.interdata-carousel-next .interdata-carousel-mark{margin-right:-2px}\n@container (max-width:640px){.interdata-plan-carousel{padding:12px 38px 16px}.interdata-plan-card{flex-basis:calc((100% - 12px)\/2);min-height:370px}.interdata-carousel-heading{font-size:16px}}\n@container (max-width:480px){.interdata-plan-carousel{padding:12px 34px 16px}.interdata-plan-card{flex-basis:100%;min-height:360px}.interdata-plan-price{font-size:25px}.interdata-carousel-arrow{width:34px;height:44px}.interdata-carousel-mark{font-size:32px!important}.interdata-carousel-prev{left:5px}.interdata-carousel-next{right:5px}}\n<\/style>\n\n<div class=\"interdata-plan-carousel\" data-interdata-carousel>\n  <div class=\"interdata-carousel-heading\">Si\u00eau \u01afu \u0110\u00e3i VPS \/ CLOUD SERVER - Ti\u1ebft Ki\u1ec7m \u0110\u1ebfn 70%<\/div>\n\n  <svg width=\"0\" height=\"0\" style=\"position:absolute;visibility:hidden\" aria-hidden=\"true\">\n    <symbol id=\"id-icon-cpu\" viewBox=\"0 0 24 24\"><rect x=\"7\" y=\"7\" width=\"10\" height=\"10\" rx=\"2\"><\/rect><path d=\"M4 9h3M4 15h3M17 9h3M17 15h3M9 4v3M15 4v3M9 17v3M15 17v3\"><\/path><path d=\"M10 10h4v4h-4z\"><\/path><\/symbol>\n    <symbol id=\"id-icon-ram\" viewBox=\"0 0 24 24\"><rect x=\"4\" y=\"8\" width=\"16\" height=\"8\" rx=\"2\"><\/rect><path d=\"M7 16v2M11 16v2M15 16v2M19 16v2M7 11h1M11 11h1M15 11h1\"><\/path><\/symbol>\n    <symbol id=\"id-icon-storage\" viewBox=\"0 0 24 24\"><rect x=\"6\" y=\"3\" width=\"12\" height=\"18\" rx=\"2\"><\/rect><path d=\"M9 7h6\"><\/path><circle cx=\"12\" cy=\"16\" r=\"1.5\"><\/circle><\/symbol>\n    <symbol id=\"id-icon-network\" viewBox=\"0 0 24 24\"><path d=\"M5 12.5a10 10 0 0 1 14 0\"><\/path><path d=\"M8.5 16a5 5 0 0 1 7 0\"><\/path><path d=\"M12 19h.01\"><\/path><\/symbol>\n    <symbol id=\"id-icon-gift\" viewBox=\"0 0 24 24\"><rect x=\"3\" y=\"8\" width=\"18\" height=\"13\" rx=\"2\"><\/rect><path d=\"M12 8v13M3 12h18\"><\/path><path d=\"M7.5 8C6.1 8 5 6.9 5 5.5S6.1 3 7.5 3C10 3 12 8 12 8\"><\/path><path d=\"M16.5 8C17.9 8 19 6.9 19 5.5S17.9 3 16.5 3C14 3 12 8 12 8\"><\/path><\/symbol>\n  <\/svg>\n\n  <button class=\"interdata-carousel-arrow interdata-carousel-prev\" type=\"button\" aria-label=\"Xem 4 g\u00f3i tr\u01b0\u1edbc\">\n    <svg viewBox=\"0 0 24 24\" aria-hidden=\"true\"><path d=\"M15 18l-6-6 6-6\"><\/path><\/svg>\n    <span class=\"interdata-carousel-mark\" aria-hidden=\"true\">&#8249;<\/span>\n  <\/button>\n\n  <div class=\"interdata-plan-viewport\">\n    <div class=\"interdata-plan-track\">\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Base<\/h3>\n        <div class=\"interdata-plan-price\">299K<span>\/3 th\u00e1ng<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>2 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>2GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>30GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/best-value-plans-2026\/best-value-plans-premium-base\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Base<\/h3>\n        <div class=\"interdata-plan-price\">999K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>3 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>3GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>30GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cyber-week-2026\/premium-base\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Pro<\/h3>\n        <div class=\"interdata-plan-price\">2.599K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>6 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>8GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>80GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 350Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cyber-week-2026\/premium-pro\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Premium Ultra<\/h3>\n        <div class=\"interdata-plan-price\">5.679K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>12 vCore Intel<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>16GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>180GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 450Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cyber-week-2026\/premium-ultra\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">BD-CLOUD 1<\/h3>\n        <div class=\"interdata-plan-price\">988K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>2 vCPU<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>2 GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>30 GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300 Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/bd-cloud-performance-2026\/bd-cloud-1\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">BD-CLOUD 2<\/h3>\n        <div class=\"interdata-plan-price\">2.988K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>4 vCPU<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>8 GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>80 GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 300 Mbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/bd-cloud-performance-2026\/bd-cloud-2\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Cloud-Day - Base<\/h3>\n        <div class=\"interdata-plan-price\">2.666K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-gift\"><\/use><\/svg><\/span>T\u1eb7ng 80GB S3 v\u00e0 1 n\u0103m s\u1eed d\u1ee5ng khi mua 2 n\u0103m tr\u1edf l\u00ean<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>4 vCPU AMD G3<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>6GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>60GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 10Gbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cloud-day-by-interdata-2026\/cloud-day-base\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n\n      <article class=\"interdata-plan-card\">\n        <h3 class=\"interdata-plan-title\">Cloud-Day - Pro<\/h3>\n        <div class=\"interdata-plan-price\">5.666K<span>\/n\u0103m<\/span><\/div>\n        <div class=\"interdata-plan-badge\">GIA H\u1ea0N KH\u00d4NG \u0110\u1ed4I GI\u00c1<\/div>\n        <ul class=\"interdata-plan-features\">\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-gift\"><\/use><\/svg><\/span>T\u1eb7ng 200GB S3 v\u00e0 1 n\u0103m s\u1eed d\u1ee5ng khi mua 2 n\u0103m tr\u1edf l\u00ean<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-cpu\"><\/use><\/svg><\/span>8 vCPU AMD G3<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-ram\"><\/use><\/svg><\/span>12GB RAM<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-storage\"><\/use><\/svg><\/span>160GB SSD NVMe<\/li>\n          <li><span class=\"interdata-plan-icon\"><svg><use href=\"#id-icon-network\"><\/use><\/svg><\/span>Network: 10Gbps<\/li>\n        <\/ul>\n        <div class=\"interdata-plan-spacer\"><\/div>\n        <a class=\"interdata-plan-button\" href=\"https:\/\/support.interdata.vn\/index.php?rp=\/store\/cloud-day-by-interdata-2026\/cloud-day-pro\" target=\"_blank\" rel=\"nofollow sponsored noopener\">\u0110\u0103ng k\u00fd ngay<\/a>\n      <\/article>\n    <\/div>\n  <\/div>\n\n  <button class=\"interdata-carousel-arrow interdata-carousel-next\" type=\"button\" aria-label=\"Xem 4 g\u00f3i ti\u1ebfp theo\">\n    <svg viewBox=\"0 0 24 24\" aria-hidden=\"true\"><path d=\"M9 18l6-6-6-6\"><\/path><\/svg>\n    <span class=\"interdata-carousel-mark\" aria-hidden=\"true\">&#8250;<\/span>\n  <\/button>\n<\/div>\n\n<script>\n(function(){\n  function setupInterDataCarousel(root){\n    var track=root.querySelector('.interdata-plan-track');\n    var prev=root.querySelector('.interdata-carousel-prev');\n    var next=root.querySelector('.interdata-carousel-next');\n    if(!track||!prev||!next||track.dataset.ready==='1')return;\n    track.dataset.ready='1';\n\n    function pageWidth(){\n      return track.clientWidth;\n    }\n\n    function updateButtons(){\n      var maxScroll=track.scrollWidth-track.clientWidth-2;\n      prev.disabled=track.scrollLeft<=2;\n      next.disabled=track.scrollLeft>=maxScroll;\n    }\n\n    prev.addEventListener('click',function(){\n      track.scrollBy({left:-pageWidth(),behavior:'smooth'});\n    });\n\n    next.addEventListener('click',function(){\n      track.scrollBy({left:pageWidth(),behavior:'smooth'});\n    });\n\n    track.addEventListener('scroll',function(){\n      window.requestAnimationFrame(updateButtons);\n    });\n\n    window.addEventListener('resize',updateButtons);\n    updateButtons();\n  }\n\n  function initInterDataCarousels(){\n    document.querySelectorAll('[data-interdata-carousel]').forEach(setupInterDataCarousel);\n  }\n\n  if(document.readyState==='loading'){\n    document.addEventListener('DOMContentLoaded',initInterDataCarousels);\n  }else{\n    initInterDataCarousels();\n  }\n})();\n<\/script>\n\n\t<div id=\"gap-473313108\" class=\"gap-element clearfix\" style=\"display:block; height:auto;\">\n\t\t\n<style>\n#gap-473313108 {\n  padding-top: 30px;\n}\n<\/style>\n\t<\/div>\n\t\n","protected":false},"excerpt":{"rendered":"<p>L\u1ed7i SQL Cannot Connect To Server l\u00e0 m\u1ed9t trong nh\u1eefng s\u1ef1 c\u1ed1 ph\u1ed5 bi\u1ebfn v\u00e0 g\u00e2y gi\u00e1n \u0111o\u1ea1n c\u00f4ng vi\u1ec7c nhi\u1ec1u nh\u1ea5t \u0111\u1ed1i v\u1edbi Qu\u1ea3n Tr\u1ecb Vi\u00ean H\u1ec7 Th\u1ed1ng c\u0169ng nh\u01b0 L\u1eadp Tr\u00ecnh Vi\u00ean v\u1eadn h\u00e0nh C\u01a1 S\u1edf D\u1eef Li\u1ec7u. Khi \u1ee9ng d\u1ee5ng \u0111\u1ed9t ng\u1ed9t m\u1ea5t k\u1ebft n\u1ed1i v\u1edbi C\u01a1 S\u1edf D\u1eef Li\u1ec7u, vi\u1ec7c x\u00e1c<\/p>\n","protected":false},"author":2,"featured_media":42248,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[140],"tags":[],"class_list":["post-42246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lap-trinh"],"_links":{"self":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/42246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/comments?post=42246"}],"version-history":[{"count":5,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/42246\/revisions"}],"predecessor-version":[{"id":42252,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/posts\/42246\/revisions\/42252"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/media\/42248"}],"wp:attachment":[{"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/media?parent=42246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/categories?post=42246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/interdata.vn\/blog\/wp-json\/wp\/v2\/tags?post=42246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}