{"id":11840,"date":"2020-08-13T11:49:56","date_gmt":"2020-08-13T04:49:56","guid":{"rendered":"http:\/\/help.sme2020.misa.vn\/?post_type=ht_kb&#038;p=11840"},"modified":"2026-01-30T15:16:06","modified_gmt":"2026-01-30T08:16:06","slug":"khi-tao-moi-du-lieu-ke-toan-hoac-vao-quan-ly-du-lieu-chuong-trinh-bao-loi-thong-tin-dang-nhap-may-chu-sql","status":"publish","type":"ht_kb","link":"https:\/\/helpsme.misa.vn\/2026\/kb\/khi-tao-moi-du-lieu-ke-toan-hoac-vao-quan-ly-du-lieu-chuong-trinh-bao-loi-thong-tin-dang-nhap-may-chu-sql\/","title":{"rendered":"L\u00e0m th\u1ebf n\u00e0o khi t\u1ea1o m\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n ho\u1eb7c v\u00e0o Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u ch\u01b0\u01a1ng tr\u00ecnh b\u00e1o l\u1ed7i Th\u00f4ng tin \u0111\u0103ng nh\u1eadp m\u00e1y ch\u1ee7 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><strong>M\u1ee5c \u0111\u00edch:<\/strong> B\u00e0i vi\u1ebft n\u00e0y gi\u00fap k\u1ebf to\u00e1n v\u00e0 qu\u1ea3n tr\u1ecb vi\u00ean kh\u1eafc ph\u1ee5c l\u1ed7i Th\u00f4ng tin \u0111\u0103ng nh\u1eadp m\u00e1y ch\u1ee7 SQL khi t\u1ea1o m\u1edbi ho\u1eb7c ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u k\u1ebf to\u00e1n, \u0111\u1ea3m b\u1ea3o qu\u00e1 tr\u00ecnh kh\u1edfi t\u1ea1o v\u00e0 ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u di\u1ec5n ra thu\u1eadn l\u1ee3i tr\u00ean ph\u1ea7n m\u1ec1m.<\/p>\n<p><strong>N\u1ed9i dung b\u00e0i vi\u1ebft g\u1ed3m:<\/strong><\/p>\n<ul>\n<li>Nh\u1eadn bi\u1ebft l\u1ed7i v\u00e0 nguy\u00ean nh\u00e2n<\/li>\n<li>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft kh\u1eafc ph\u1ee5c b\u1eb1ng c\u00f4ng c\u1ee5 MISA All In One Database Tool<\/li>\n<li>L\u01b0u \u00fd v\u00e0 \u0111i\u1ec1u ki\u1ec7n \u0111\u1eb7c bi\u1ec7t khi thao t\u00e1c<\/li>\n<\/ul>\n<p><strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> D\u00e0nh cho k\u1ebf to\u00e1n, qu\u1ea3n tr\u1ecb vi\u00ean h\u1ec7 th\u1ed1ng s\u1eed d\u1ee5ng ph\u1ea7n m\u1ec1m k\u1ebf to\u00e1n MISA \u0111\u1ec3 qu\u1ea3n l\u00fd d\u1eef li\u1ec7u k\u1ebf to\u00e1n.<\/p>\n<\/div><\/div>\n<\/div>\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>2. C\u00e1ch x\u1eed l\u00fd<\/strong><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><b>Bi\u1ec3u hi\u1ec7n:<\/b>\u00a0Khi\u00a0<a class=\"externalLink\" href=\"\/2026\/kb\/html_10010000\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">t\u1ea1o d\u1eef li\u1ec7u k\u1ebf to\u00e1n m\u1edbi<\/a>\u00a0ho\u1eb7c v\u00e0o <strong>T\u1ec7p\/qu\u1ea3n l\u00fd d\u1eef li\u1ec7u<\/strong> \u0111\u1ec3 ph\u1ee5c h\u1ed3i d\u1eef li\u1ec7u c\u0169, d\u00f9 b\u1ea1n \u0111\u00e3 ch\u1ecdn \u0111\u00fang m\u00e1y ch\u1ee7 ch\u1ee9a c\u01a1 s\u1edf d\u1eef li\u1ec7u nh\u01b0ng ch\u01b0\u01a1ng tr\u00ecnh v\u1eabn hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o l\u1ed7i<\/p>\n<p style=\"padding-left: 120px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11842\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/08\/upload_2018-9-5_11-24-47.png\" alt=\"\" width=\"356\" height=\"240\" srcset=\"\/2026\/wp-content\/uploads\/2020\/08\/upload_2018-9-5_11-24-47.png 356w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2018-9-5_11-24-47-50x34.png 50w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2018-9-5_11-24-47-60x40.png 60w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2018-9-5_11-24-47-100x67.png 100w\" sizes=\"auto, (max-width: 356px) 100vw, 356px\" \/><\/p>\n<p><b>C\u00e1ch kh\u1eafc ph\u1ee5c :\u00a0<\/b>Th\u1ef1c hi\u1ec7n theo 7 b\u01b0\u1edbc sau:<\/p>\n<ul>\n<li><b>B\u01b0\u1edbc 1:<\/b>\u00a0T\u1ea3i c\u00f4ng c\u1ee5\u00a0<b>MISA All in one Database Tool<\/b>\u00a0<a class=\"externalLink\" href=\"https:\/\/drive.google.com\/file\/d\/1JQpIX-ZyR0F4dKd8Zen-SKTucptQAKRj\/view?usp=sharing\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">t\u1ea1i \u0111\u00e2y<\/a>.<\/li>\n<\/ul>\n<ul>\n<li><b>B\u01b0\u1edbc 2:<\/b>\u00a0Gi\u1ea3i n\u00e9n file v\u1eeba t\u1ea3i v\u1ec1 v\u00e0 m\u1edf c\u00f4ng c\u1ee5\u00a0<b>MISA All In One Database Tool\u00a0<\/b>b\u1eb1ng ch\u1ebf \u0111\u1ed9<b> Run as adminnistrator.<\/b><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-11843\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/08\/upload_2020-6-24_15-23-43-700x325.png\" alt=\"\" width=\"700\" height=\"325\" srcset=\"\/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-24_15-23-43-700x325.png 700w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-24_15-23-43-50x23.png 50w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-24_15-23-43-60x28.png 60w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-24_15-23-43-100x46.png 100w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-24_15-23-43.png 717w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/p>\n<ul>\n<li><b>B\u01b0\u1edbc 3:<\/b>\u00a0T\u1ea1i m\u1ee5c\u00a0<b>Server<\/b>: nh\u1ea5n bi\u1ec3u t\u01b0\u1ee3ng (m\u0169i t\u00ean) \u0111\u1ec3 ch\u1ecdn\u00a0<b>SQL Server<\/b>\u00a0r\u1ed3i nh\u1ea5n\u00a0<b>T\u1ea1o t\u00e0i kho\u1ea3n SQL MISA.<\/b><\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11844\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/08\/upload_2020-6-19_17-12-4.png\" alt=\"\" width=\"604\" height=\"416\" srcset=\"\/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-19_17-12-4.png 604w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-19_17-12-4-50x34.png 50w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-19_17-12-4-60x41.png 60w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-19_17-12-4-100x69.png 100w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p style=\"padding-left: 40px;\"><i><b>L\u01b0u \u00fd:<\/b><\/i><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: disc;\">\n<li><i>N\u1ebfu kh\u00f4ng th\u1ea5y t\u00ean m\u00e1y ch\u1ee7 SQL Server trong danh s\u00e1ch th\u00ec t\u1ef1 nh\u1eadp tay th\u00f4ng tin\u00a0<b>SQL Server.<\/b><\/i><\/li>\n<li><i>Tr\u01b0\u1eddng h\u1ee3p 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) tr\u00f9ng nhau, ch\u01b0\u01a1ng tr\u00ecnh s\u1ebd xu\u1ea5t hi\u1ec7n c\u1ea3nh b\u00e1o:<\/i><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"padding-left: 120px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11846\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/08\/R4_sqlserver_07.jpg\" alt=\"\" width=\"403\" height=\"193\" srcset=\"\/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_07.jpg 403w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_07-50x24.jpg 50w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_07-60x29.jpg 60w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_07-100x48.jpg 100w\" sizes=\"auto, (max-width: 403px) 100vw, 403px\" \/><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: disc;\">\n<li><em>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\u00a0<a class=\"externalLink\" href=\"\/2026\/kb\/doi_ten_may_tinh\/\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">t\u1ea1i \u0111\u00e2y<\/a>.<\/em><\/li>\n<li><em>Kh\u1edfi \u0111\u1ed9ng l\u1ea1i m\u00e1y t\u00ednh v\u00e0 th\u1ef1c hi\u1ec7n l\u1ea1i c\u00e1c b\u01b0\u1edbc v\u1edbi c\u00f4ng c\u1ee5\u00a0<b>MISA All In One Database Tool<\/b>.<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li><b>B\u01b0\u1edbc 4:<\/b>\u00a0Ch\u1ecdn ph\u1ea7n m\u1ec1m t\u01b0\u01a1ng \u1ee9ng \u0111ang s\u1eed d\u1ee5ng (V\u00ed d\u1ee5 \u1edf \u0111\u00e2y l\u00e0 MISA SME.NET), nh\u1ea5n\u00a0<b>T\u1ea1o t\u00e0i kho\u1ea3n<\/b>.<\/li>\n<\/ul>\n<p style=\"padding-left: 200px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11848\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/08\/upload_2020-6-18_16-8-9.png\" alt=\"\" width=\"288\" height=\"272\" srcset=\"\/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-18_16-8-9.png 288w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-18_16-8-9-50x47.png 50w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-18_16-8-9-60x57.png 60w, \/2026\/wp-content\/uploads\/2020\/08\/upload_2020-6-18_16-8-9-100x94.png 100w\" sizes=\"auto, (max-width: 288px) 100vw, 288px\" \/><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul style=\"list-style-type: disc;\">\n<li>L\u01b0u \u00fd: t\u1eeb phi\u00ean b\u1ea3n MISA SME.NET 2020 tr\u1edf l\u00ean anh\/ch\u1ecb m\u1eb7c \u0111\u1ecbnh ch\u1ecdn d\u00f2ng MISA SME.NET 2020<\/li>\n<\/ul>\n<\/li>\n<li><b>B\u01b0\u1edbc 5:<\/b>\u00a0Nh\u1ea5n\u00a0<b>Agree<\/b>.<\/li>\n<\/ul>\n<p style=\"padding-left: 120px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11849\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/08\/R4_sqlserver_14.jpg\" alt=\"\" width=\"470\" height=\"320\" srcset=\"\/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_14.jpg 470w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_14-50x34.jpg 50w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_14-60x41.jpg 60w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_14-100x68.jpg 100w\" sizes=\"auto, (max-width: 470px) 100vw, 470px\" \/><\/p>\n<ul>\n<li><b>B\u01b0\u1edbc 6:\u00a0<\/b>Ch\u01b0\u01a1ng tr\u00ecnh hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o t\u1ea1o t\u00e0i kho\u1ea3n th\u00e0nh c\u00f4ng.<\/li>\n<\/ul>\n<p style=\"padding-left: 240px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-11850\" src=\"https:\/\/helpsme.misa.vn\/2022\/wp-content\/uploads\/2020\/08\/R4_sqlserver_15.jpg\" alt=\"\" width=\"230\" height=\"147\" srcset=\"\/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_15.jpg 230w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_15-50x32.jpg 50w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_15-60x38.jpg 60w, \/2026\/wp-content\/uploads\/2020\/08\/R4_sqlserver_15-100x64.jpg 100w\" sizes=\"auto, (max-width: 230px) 100vw, 230px\" \/><\/p>\n<ul>\n<li><b>B\u01b0\u1edbc 7:<\/b>\u00a0Sau khi th\u1ef1c hi\u1ec7n xong c\u00e1c b\u01b0\u1edbc tr\u00ean, m\u1edf ph\u1ea7n m\u1ec1m MISA \u0111\u1ec3 th\u1ef1c hi\u1ec7n<b>\u00a0T\u1ea1o m\u1edbi d\u1eef li\u1ec7u k\u1ebf to\u00e1n\u00a0<\/b>ho\u1eb7c v\u00e0o\u00a0<b>T\u1ec7p\/Qu\u1ea3n l\u00fd d\u1eef li\u1ec7u<\/b> \u0111\u1ec3 ph\u1ee5c h\u1ed3i l\u1ea1i d\u1eef li\u1ec7u c\u0169.<\/li>\n<\/ul>\n<\/div><\/div>\n<\/div>\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":[2639,2642,2568],"ht-kb-tag":[3887,3889],"class_list":["post-11840","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","ht_kb_tag-loi-ket-noi-du-lieu","ht_kb_tag-sql-server"],"_links":{"self":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/11840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/users\/133"}],"replies":[{"embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/comments?post=11840"}],"version-history":[{"count":4,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/11840\/revisions"}],"predecessor-version":[{"id":61153,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb\/11840\/revisions\/61153"}],"wp:attachment":[{"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/media?parent=11840"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-category?post=11840"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/helpsme.misa.vn\/2026\/wp-json\/wp\/v2\/ht-kb-tag?post=11840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}