{"id":1441,"date":"2018-12-25T17:52:02","date_gmt":"2018-12-25T10:52:02","guid":{"rendered":"http:\/\/help.sme2019.misa.local\/?post_type=ht_kb&#038;p=1441"},"modified":"2025-10-27T14:08:31","modified_gmt":"2025-10-27T07:08:31","slug":"cai_dat_lai_sql","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2023\/kb\/cai_dat_lai_sql\/","title":{"rendered":"C\u00e0i \u0111\u1eb7t l\u1ea1i SQL"},"content":{"rendered":"<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>B\u00e0i vi\u1ebft gi\u00fap Anh\/ch\u1ecb hi\u1ec3u t\u1ed5ng th\u1ec3 quy tr\u00ecnh c\u00e0i \u0111\u1eb7t l\u1ea1i SQL Server b\u1eb1ng c\u00f4ng c\u1ee5 MISA Installer \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o ph\u1ea7n m\u1ec1m MISA SME ho\u1ea1t \u0111\u1ed9ng \u1ed5n \u0111\u1ecbnh, k\u1ebft n\u1ed1i d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3.<\/p>\n<p>Sau khi \u0111\u1ecdc, Anh\/ch\u1ecb s\u1ebd n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c b\u01b0\u1edbc chu\u1ea9n b\u1ecb, thao t\u00e1c c\u00e0i \u0111\u1eb7t v\u00e0 l\u01b0u \u00fd quan tr\u1ecdng khi thay \u0111\u1ed5i t\u00ean m\u00e1y ch\u1ee7 SQL.<\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><iframe loading=\"lazy\" src=\"\/\/www.youtube.com\/embed\/LpRabs9RUCw\" width=\"860\" height=\"482\" allowfullscreen=\"allowfullscreen\" data-mce-fragment=\"1\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 1:<\/strong> T\u1ea3i c\u00f4ng c\u1ee5 MISA Installer <a href=\"https:\/\/product.misa.vn\/HTKT\/Tools\/MISASQLInstaller\/MISA%20SQL%20Installer.zip\" target=\"_blank\" rel=\"noopener noreferrer\">t\u1ea1i \u0111\u00e2y<\/a>.<\/span><br \/>\n<span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 2:<\/strong> Gi\u1ea3i n\u00e9n file v\u1eeba t\u1ea3i v\u1ec1 v\u00e0 m\u1edf c\u00f4ng c\u1ee5 MISA Installer l\u00ean b\u1eb1ng c\u00e1ch nh\u1ea5n chu\u1ed9t ph\u1ea3i, ch\u1ecdn <strong>Run administrator<\/strong>.<\/span><\/p>\n<blockquote><p><span style=\"font-size: 12pt;\"><img decoding=\"async\" class=\"aligncenter\" style=\"border: 1px solid #d8d8d8;\" src=\"\/2022\/wp-content\/uploads\/2019\/12\/r12_ketnoisql_01.png&quot;\" alt=\"\" \/><\/span><\/p><\/blockquote>\n<p><span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 3:<\/strong> \u0110\u1ed5i t\u00ean SQL t\u1ea1i m\u1ee5c <strong>Instance Name <\/strong>(Vi\u1ebft li\u1ec1n kh\u00f4ng d\u1ea5u). Nh\u1ea5n <strong>Install<\/strong>.<\/span><\/p>\n<blockquote><p><span style=\"font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-16997\" src=\"\/2022\/wp-content\/uploads\/2018\/12\/khac.png&quot;\" alt=\"\" width=\"509\" height=\"369\" srcset=\"\/2023\/wp-content\/uploads\/2018\/12\/khac.png 509w, \/2023\/wp-content\/uploads\/2018\/12\/khac-50x36.png 50w, \/2023\/wp-content\/uploads\/2018\/12\/khac-60x43.png 60w, \/2023\/wp-content\/uploads\/2018\/12\/khac-100x72.png 100w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><\/span><\/p>\n<p><em><span style=\"font-size: 12pt;\"><strong>L\u01b0u \u00fd:<\/strong> V\u1eabn c\u00f3 th\u1ec3 d\u00f9ng t\u00ean sql SME2021<\/span><\/em><\/p><\/blockquote>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\"><strong>B\u01b0\u1edbc 4:<\/strong> Sau khi c\u00e0i \u0111\u1eb7t xong, t\u00ean m\u00e1y ch\u1ee7 SQL s\u1ebd \u0111\u01b0\u1ee3c \u0111\u1ed5i sang t\u00ean m\u1edbi. V\u00ed d\u1ee5: T\u1eeb <strong>PMTAM\\MISASME2021<\/strong> chuy\u1ec3n th\u00e0nh <strong>PMTAM\\SQL2014<\/strong> =&gt; C\u1ea7n nh\u1eadp l\u1ea1i t\u00ean <strong>m\u00e1y ch\u1ee7 SQL<\/strong> tr\u00ean ph\u1ea7n m\u1ec1m theo t\u00ean m\u00e1y ch\u1ee7 SQL m\u1edbi t\u1ea1o khi th\u1ef1c hi\u1ec7n c\u00e1c ch\u1ee9c n\u0103ng nh\u01b0 <a href=\"html_10020000\" target=\"_blank\" rel=\"noopener noreferrer\">\u0110\u0103ng nh\u1eadp v\u00e0o ph\u1ea7n m\u1ec1m<\/a>, <a href=\"ket_noi_voi_du_lieu_ke_toan_tren_may_chu\" target=\"_blank\" rel=\"noopener noreferrer\">K\u1ebft n\u1ed1i v\u1edbi m\u00e1y ch\u1ee7<\/a>,<a href=\"html_10010000\" target=\"_blank\" rel=\"noopener noreferrer\"> T\u1ea1o m\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n<\/a> hay <a href=\"html_10030000\" target=\"_blank\" rel=\"noopener noreferrer\">Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u<\/a>.<\/span><\/p>\n<\/div><\/div>\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><strong>3. L\u01b0u \u00fd<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-size: 12pt;\"><em>Ph\u1ea3i \u0111\u0103ng nh\u1eadp v\u00e0o m\u00e1y t\u00ednh l\u00e0m vi\u1ec7c b\u1eb1ng t\u00e0i kho\u1ea3n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng (user) <strong>c\u00f3 quy\u1ec1n admin. <\/strong>\u0110\u1ec3 bi\u1ebft ng\u01b0\u1eddi d\u00f9ng n\u00e0o c\u00f3 quy\u1ec1n admin c\u1ee7a m\u00e1y t\u00ednh, xem h\u01b0\u1edbng d\u1eabn <a href=\"kiem_tra_quyen_admin_tren_may_tinh\" target=\"_blank\" rel=\"noopener noreferrer\">t\u1ea1i \u0111\u00e2y<\/a>.<strong><br \/>\n<\/strong><\/em><\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-size: 12pt;\"><em>T\u00ean m\u00e1y t\u00ednh v\u00e0 t\u00ean \u0111\u0103ng nh\u1eadp (t\u00ean user \u0111\u0103ng nh\u1eadp v\u00e0o m\u00e1y t\u00ednh) ph\u1ea3i kh\u00e1c nhau. N\u1ebfu tr\u00f9ng nhau ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd xu\u1ea5t hi\u1ec7n c\u1ea3nh b\u00e1o, khi \u0111\u00f3 c\u1ea7n th\u1ef1c hi\u1ec7n \u0111\u1ed5i t\u00ean m\u00e1y t\u00ednh cho kh\u00e1c v\u1edbi t\u00ean user theo h\u01b0\u1edbng d\u1eabn <a href=\"doi_ten_may_tinh\" target=\"_blank\" rel=\"noopener noreferrer\">t\u1ea1i \u0111\u00e2y,<\/a> sau \u0111\u00f3, kh\u1edfi \u0111\u1ed9ng l\u1ea1i m\u00e1y t\u00ednh v\u00e0 th\u1ef1c hi\u1ec7n ti\u1ebfp.<\/em><\/span><\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\n<p style=\"text-align: justify;\">\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":133,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[2608],"ht-kb-tag":[],"class_list":["post-1441","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-khac-huong-dan-4__khac"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/1441","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=1441"}],"version-history":[{"count":6,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/1441\/revisions"}],"predecessor-version":[{"id":45605,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb\/1441\/revisions\/45605"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/media?parent=1441"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-category?post=1441"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2023\/wp-json\/wp\/v2\/ht-kb-tag?post=1441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}