{"id":2347,"date":"2018-12-25T18:01:26","date_gmt":"2018-12-25T11:01:26","guid":{"rendered":"http:\/\/help.sme2019.misa.local\/?post_type=ht_kb&#038;p=2347"},"modified":"2025-11-07T10:23:31","modified_gmt":"2025-11-07T03:23:31","slug":"khong_ket_noi_duoc_voi_may_chu_sql_server_thi_lam_the_nao","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/khong_ket_noi_duoc_voi_may_chu_sql_server_thi_lam_the_nao\/","title":{"rendered":"Khi \u0110\u0103ng nh\u1eadp, T\u1ea1o m\u1edbi d\u1eef li\u1ec7u ho\u1eb7c Ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u c\u0169 ch\u01b0\u01a1ng tr\u00ecnh b\u00e1o Kh\u00f4ng t\u00ecm th\u1ea5y m\u00e1y ch\u1ee7 th\u00ec ph\u1ea3i l\u00e0m th\u1ebf n\u00e0o?"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/97jNAl3EXnA\" width=\"860\" height=\"482\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>1. T\u1ed5ng quan<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p style=\"text-align: justify;\"><strong>M\u1ee5c \u0111\u00edch:<\/strong> Gi\u00fap Qu\u00fd kh\u00e1ch nh\u1eadn bi\u1ebft nguy\u00ean nh\u00e2n v\u00e0 n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c b\u01b0\u1edbc x\u1eed l\u00fd khi g\u1eb7p c\u1ea3nh b\u00e1o <strong>\u201cKh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c v\u1edbi m\u00e1y ch\u1ee7 SQL Server\u201d<\/strong> trong qu\u00e1 tr\u00ecnh \u0111\u0103ng nh\u1eadp, t\u1ea1o m\u1edbi ho\u1eb7c ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u tr\u00ean ph\u1ea7n m\u1ec1m MISA SME. Vi\u1ec7c x\u1eed l\u00fd \u0111\u00fang gi\u00fap \u0111\u1ea3m b\u1ea3o truy c\u1eadp v\u00e0 l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n kh\u00f4ng b\u1ecb gi\u00e1n \u0111o\u1ea1n.<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 14pt;\"><strong><span style=\"font-size: 12pt;\">Bi\u1ec3u hi\u1ec7n: <\/span><\/strong><\/span><span style=\"font-size: 12pt; color: #1a1a1a;\">Khi <\/span><strong style=\"font-size: 12pt; color: #1a1a1a;\">\u0110\u0103ng nh\u1eadp<\/strong><span style=\"font-size: 12pt; color: #1a1a1a;\"> v\u00e0o ph\u1ea7n m\u1ec1m ho\u1eb7c <\/span><strong style=\"font-size: 12pt; color: #1a1a1a;\">T\u1ea1o m\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n <\/strong>ho\u1eb7c <strong>Ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u c\u0169<\/strong><span style=\"font-size: 12pt; color: #1a1a1a;\">, ch\u01b0\u01a1ng tr\u00ecnh xu\u1ea5t hi\u1ec7n c\u1ea3nh b\u00e1o: <strong>&#8220;Kh\u00f4ng t\u00ecm th\u1ea5y m\u00e1y ch\u1ee7. Xem h\u01b0\u1edbng d\u1eabn kh\u1eafc ph\u1ee5c t\u1ea1i \u0111\u00e2y.&#8221;<\/strong><\/span><\/p>\n<p style=\"padding-left: 80px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14988\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/33.png&quot;\" alt=\"\" width=\"477\" height=\"310\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/33.png 477w, \/2023\/wp-content\/uploads\/2018\/12\/33-50x32.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/33-60x39.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/33-100x65.png 100w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/p>\n<p><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong><\/p>\n<ul>\n<li>Nh\u1eadn bi\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p l\u1ed7i k\u1ebft n\u1ed1i SQL Server tr\u00ean m\u00e1y ch\u1ee7 v\u00e0 m\u00e1y tr\u1ea1m<\/li>\n<li>H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t l\u1ea1i SQL Server b\u1eb1ng c\u00f4ng c\u1ee5 MISA Installer<\/li>\n<li>C\u00e1ch k\u1ebft n\u1ed1i l\u1ea1i m\u00e1y tr\u1ea1m v\u1edbi m\u00e1y ch\u1ee7 SQL<\/li>\n<li>L\u01b0u \u00fd khi nh\u1eadp t\u00ean m\u00e1y ch\u1ee7 SQL trong qu\u00e1 tr\u00ecnh \u0111\u0103ng k\u00fd, ph\u1ee5c h\u1ed3i ho\u1eb7c t\u1ea1o m\u1edbi d\u1eef li\u1ec7u<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong>\u00a0K\u1ebf to\u00e1n, qu\u1ea3n tr\u1ecb h\u1ec7 th\u1ed1ng, ng\u01b0\u1eddi d\u00f9ng MISA SME tr\u00ean m\u1ea1ng LAN<\/p>\n<\/div><\/div> <div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1c tr\u01b0\u1eddng h\u1ee3p v\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 100%;\"><\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><strong>2.1. M\u00e1y ch\u1ee7 \u0111\u0103ng nh\u1eadp b\u00ecnh th\u01b0\u1eddng, m\u00e1y tr\u1ea1m \u0111\u0103ng nh\u1eadp b\u00e1o l\u1ed7i Kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c v\u1edbi m\u00e1y ch\u1ee7 SQL<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>Gi\u1ea3i ph\u00e1p:<\/strong> <a href=\"\/2023\/kb\/ket_noi_voi_du_lieu_ke_toan_tren_may_chu\/\" target=\"_blank\" rel=\"noopener\">K\u1ebft n\u1ed1i l\u1ea1i m\u00e1y tr\u1ea1m v\u1edbi d\u1eef li\u1ec7u tr\u00ean m\u00e1y ch\u1ee7<\/a><\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h4><strong>2.2. M\u00e1y ch\u1ee7 \u0111\u0103ng nh\u1eadp ho\u1eb7c t\u1ea1o m\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n b\u00e1o l\u1ed7i Kh\u00f4ng k\u1ebft n\u1ed1i \u0111\u01b0\u1ee3c v\u1edbi m\u00e1y ch\u1ee7 SQL<\/strong><\/h4>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><b>Nguy\u00ean nh\u00e2n: <\/b>Do\u00a0<b>M\u00e1y ch\u1ee7 SQL\u00a0<\/b>ch\u01b0a \u0111\u01b0\u1ee3c c\u00e0i tr\u00ean m\u00e1y t\u00ednh n\u00e0y.<\/p>\n<p><strong style=\"font-size: 12pt; color: #1a1a1a;\">Gi\u1ea3i ph\u00e1p:<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: C\u00e0i l\u1ea1i SQL<\/p>\n<ul>\n<li>T\u1ea3i c\u00f4ng c\u1ee5 <b>MISA Installer<\/b> \u0111\u1ec3 c\u00e0i \u0111\u1eb7t SQL theo link <a href=\"https:\/\/support.misa.com.vn\/HTKT\/Tools\/MISASQLInstaller\/MISA SQL Installer.zip\" target=\"_blank\" rel=\"noopener\">t\u1ea1i \u0111\u00e2y<\/a>.<\/li>\n<li>Gi\u1ea3i n\u00e9n file t\u1ea3i v\u1ec1, chu\u1ed9t ph\u1ea3i v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <b>MISA Installer<\/b>\u00a0v\u00e0 ch\u1ecdn\u00a0<b>Run as administrator.<\/b><\/li>\n<\/ul>\n<p><em>L\u01b0u \u00fd: N\u1ebfu sau khi thao t\u00e1c\u00a0<strong>Run as administrator<\/strong>\u00a0b\u1ecb c\u1ea3nh b\u00e1o\u00a0<strong>User Account Control<\/strong>\u00a0th\u00ec nh\u1ea5n <strong>Yes<\/strong>\u00a0\u0111\u1ec3 cho ph\u00e9p ch\u1ea1y file b\u1eb1ng quy\u1ec1n admin<\/em><\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10845\" src=\"\/2022\/wp-content\/uploads\/2019\/12\/1-4.png&quot;\" alt=\"\" width=\"597\" height=\"426\" srcset=\"\/2023\/wp-content\/uploads\/2019\/12\/1-4.png 597w, \/2023\/wp-content\/uploads\/2019\/12\/1-4-50x36.png 50w, \/2023\/wp-content\/uploads\/2019\/12\/1-4-60x43.png 60w, \/2023\/wp-content\/uploads\/2019\/12\/1-4-100x71.png 100w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><\/p>\n<ul>\n<li>Ch\u1ecdn t\u00ean s\u1ea3n ph\u1ea9m <b>MISA SME.NET\u00a0<\/b><\/li>\n<li>Nh\u1eadp t\u00ean SQL \u1edf m\u1ee5c <strong>Instance Name<\/strong>\\nh\u1ea5n <b>Install.<\/b><\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15016\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/34-1.png&quot;\" alt=\"\" width=\"509\" height=\"369\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/34-1.png 509w, \/2023\/wp-content\/uploads\/2018\/12\/34-1-50x36.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/34-1-60x43.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/34-1-100x72.png 100w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-10848\" src=\"\/2022\/wp-content\/uploads\/2019\/12\/2-2.png&quot;\" alt=\"\" width=\"508\" height=\"373\" srcset=\"\/2023\/wp-content\/uploads\/2019\/12\/2-2.png 508w, \/2023\/wp-content\/uploads\/2019\/12\/2-2-50x37.png 50w, \/2023\/wp-content\/uploads\/2019\/12\/2-2-60x44.png 60w, \/2023\/wp-content\/uploads\/2019\/12\/2-2-100x73.png 100w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/p>\n<p><span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 2<\/strong>: <\/span><span style=\"font-size: 12pt;\">N\u1ebfu <strong>\u0111\u0103ng nh\u1eadp v\u00e0o d\u1eef li\u1ec7u<\/strong> b\u00e1o l\u1ed7i th\u00ec <a href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/html_10030300\/\" target=\"_blank\" rel=\"noopener\">\u0110\u0103ng k\u00fd<\/a> ho\u1eb7c <a href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/html_10030200\/\" target=\"_blank\" rel=\"noopener\">Ph\u1ee5c h\u1ed3i l\u1ea1i d\u1eef li\u1ec7u<\/a> tr\u00ean m\u00e1y ch\u1ee7 SQL t\u1ea1o \u1edf b\u01b0\u1edbc 1.<\/span><\/p>\n<p><em style=\"font-size: 12pt; color: #1a1a1a;\"><strong>L\u01b0u \u00fd<\/strong>: T\u1ea1i b\u01b0\u1edbc ch\u1ecdn <strong>M\u00e1y ch\u1ee7 SQL<\/strong>, c\u1ea7n nh\u1eadp l\u1ea1i t\u00ean SQL theo t\u00ean SQL \u0111\u00e3 t\u1ea1o \u1edf b\u01b0\u1edbc 1.<\/em><\/p>\n<p style=\"padding-left: 80px;\"><span style=\"font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15018\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/35-1.png&quot;\" alt=\"\" width=\"401\" height=\"254\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/35-1.png 401w, \/2023\/wp-content\/uploads\/2018\/12\/35-1-50x32.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/35-1-60x38.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/35-1-100x63.png 100w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/span><\/p>\n<ul style=\"list-style-type: circle;\">\n<li><span style=\"font-size: 12pt;\">N\u1ebfu <strong>t\u1ea1o m\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n<\/strong> b\u00e1o l\u1ed7i th\u00ec <a href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/html_10010000\/\" target=\"_blank\" rel=\"noopener\">T\u1ea1o m\u1edbi l\u1ea1i d\u1eef li\u1ec7u k\u1ebf to\u00e1n<\/a> tr\u00ean m\u00e1y ch\u1ee7 SQL t\u1ea1o \u1edf b\u01b0\u1edbc 1.<\/span><\/li>\n<\/ul>\n<p><em style=\"font-size: 12pt; font-family: inherit;\"><strong>L\u01b0u \u00fd<\/strong>: T\u1ea1i b\u01b0\u1edbc ch\u1ecdn <strong>M\u00e1y ch\u1ee7 SQL<\/strong>, c\u1ea7n nh\u1eadp l\u1ea1i t\u00ean SQL theo t\u00ean SQL \u0111\u00e3 t\u1ea1o \u1edf b\u01b0\u1edbc 1.<\/em><\/p>\n<p style=\"padding-left: 120px;\"><span style=\"font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15022\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/36-1.png&quot;\" alt=\"\" width=\"799\" height=\"598\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/36-1.png 799w, \/2023\/wp-content\/uploads\/2018\/12\/36-1-700x524.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/36-1-768x575.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/36-1-50x37.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/36-1-60x45.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/36-1-100x75.png 100w\" sizes=\"auto, (max-width: 799px) 100vw, 799px\" \/><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 3<\/strong>: <a href=\"https:\/\/helpsme.misa.vn\/2023\/kb\/ket_noi_voi_du_lieu_ke_toan_tren_may_chu\/\" target=\"_blank\" rel=\"noopener\">M\u00e1y tr\u1ea1m k\u1ebft n\u1ed1i l\u1ea1i v\u1edbi m\u00e1y ch\u1ee7<\/a> (theo th\u00f4ng tin m\u00e1y ch\u1ee7 SQL t\u1ea1o \u1edf b\u01b0\u1edbc 1)<\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><em><strong>L\u01b0u \u00fd<\/strong>: T\u1ea1i b\u01b0\u1edbc ch\u1ecdn <strong>M\u00e1y ch\u1ee7 k\u1ebft n\u1ed1i<\/strong>, c\u1ea7n nh\u1eadp l\u1ea1i t\u00ean SQL theo t\u00ean SQL \u0111\u00e3 t\u1ea1o \u1edf b\u01b0\u1edbc 1.<\/em><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15023\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/37-2.png&quot;\" alt=\"\" width=\"803\" height=\"500\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/37-2.png 803w, \/2023\/wp-content\/uploads\/2018\/12\/37-2-700x436.png 700w, \/2023\/wp-content\/uploads\/2018\/12\/37-2-800x498.png 800w, \/2023\/wp-content\/uploads\/2018\/12\/37-2-768x478.png 768w, \/2023\/wp-content\/uploads\/2018\/12\/37-2-50x31.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/37-2-60x37.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/37-2-100x62.png 100w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-size: 12pt;\"><\/div><\/div> <\/div><\/span><\/p>\n<p><span style=\"font-size: 12pt;\"><strong>\u00a0<\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; \u00a0<\/p>\n","protected":false},"author":133,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2639,2642,2568],"ht-kb-tag":[],"class_list":["post-2347","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cau-hoi-thuong-gap-chung","ht_kb_category-sql-server","ht_kb_category-cau-hoi-thuong-gap"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/2347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/comments?post=2347"}],"version-history":[{"count":8,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/2347\/revisions"}],"predecessor-version":[{"id":55267,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/2347\/revisions\/55267"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=2347"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=2347"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=2347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}