{"id":29891,"date":"2024-08-05T10:22:48","date_gmt":"2024-08-05T03:22:48","guid":{"rendered":"\/vi\/?post_type=ht_kb&p=29891"},"modified":"2024-08-07T09:57:53","modified_gmt":"2024-08-07T02:57:53","slug":"huong-dan-nang-cap-sql-server-2017-express","status":"publish","type":"ht_kb","link":"\/vi\/kb\/huong-dan-nang-cap-sql-server-2017-express\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn N\u00e2ng c\u1ea5p SQL Server 2017 Express"},"content":{"rendered":"
\n
\n
\n
\n

D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc n\u00e2ng c\u1ea5p t\u1eeb SQL Server 2005 Express l\u00ean SQL Server 2017 Express<\/span><\/p>\n

<\/span>
\n
<\/span>B\u01b0\u1edbc 1: Sao l\u01b0u d\u1eef li\u1ec7u hi\u1ec7n t\u1ea1i c\u1ee7a nh\u00e0 h\u00e0ng<\/div>
<\/span><\/p>\n

Tr\u01b0\u1edbc khi n\u00e2ng c\u1ea5p l\u00ean SQL Server 2017 Express, nh\u00e0 h\u00e0ng c\u1ea7n sao l\u01b0u d\u1eef li\u1ec7u hi\u1ec7n c\u00f3 \u1edf SQL Server 2005. D\u1eef li\u1ec7u sao l\u01b0u n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c kh\u00f4i ph\u1ee5c v\u00e0o SQL Server 2017.<\/span><\/p>\n

M\u1edf \u1ee9ng d\u1ee5ng Microsoft SQL Server Management Studio.\u00a0<\/span>Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o d\u1eef li\u1ec7u nh\u00e0 h\u00e0ng c\u1ea7n sao l\u01b0u. Ch\u1ecdn Tasks <\/strong>v\u00e0 Back Up.<\/strong><\/span><\/span><\/p>\n

\"\"<\/span><\/p>\n

L\u01b0u \u00fd:<\/span><\/strong><\/span><\/p>\n

    \n
  • V\u1edbi m\u00f4 h\u00ecnh Online, nh\u00e0 h\u00e0ng c\u00f3 1 database l\u00e0 CUKCUK_Offline (Sale)<\/span><\/li>\n
  • V\u1edbi m\u00f4 h\u00ecnh Offline, nh\u00e0 h\u00e0ng c\u00f3 2 database l\u00e0 CUKCUK_Offline (Sale) v\u00e0 CUKCUKENTERPRISE_{domain} (Server Enterprise)<\/span><\/li>\n<\/ul>\n

    Ch\u1ecdn v\u1ecb tr\u00ed \u0111\u1ec3 l\u01b0u l\u1ea1i t\u1ec7p sao l\u01b0u (c\u00f3 \u0111u\u00f4i m\u1edf r\u1ed9ng .mbk)<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    <\/div><\/div><\/span><\/p>\n

    <\/div><\/span><\/p>\n

    <\/span>
    \n
    <\/span>B\u01b0\u1edbc 2: G\u1ee1 ph\u1ea7n m\u1ec1m SQL Server 2005<\/div>
    <\/span><\/p>\n

    M\u1edf Control Panel.<\/strong><\/span><\/p>\n

    \"\"<\/span><\/p>\n

    Ch\u1ecdn Uninstall a program<\/strong>.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    T\u00ecm \u1ee9ng d\u1ee5ng Microsoft SQL Server 2005. Sau \u0111\u00f3, t\u1ea1i \u1ee9ng d\u1ee5ng nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Uninstall<\/strong>.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    Ch\u1ecdn radio MISACUKCUKVN: Database Engine<\/strong> v\u00e0 t\u00edch v\u00e0o \u00f4 Workstation Components<\/strong>. Sau \u0111\u00f3, nh\u1ea5n Next<\/strong>.\"\"<\/span><\/p>\n

    Nh\u1ea5n Finish<\/strong> \u0111\u1ec3 ho\u00e0n th\u00e0nh g\u1ee1 \u1ee9ng d\u1ee5ng.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    L\u01b0u \u00fd:<\/span><\/strong><\/span><\/p>\n

    N\u1ebfu ph\u1ea7n m\u1ec1m hi\u1ec3n th\u1ecb th\u00f4ng b\u00e1o nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi th\u00ec t\u1ee9c l\u00e0 Services SQL Server 2005 \u0111ang ch\u1ea1y.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    \u0110i \u0111\u1ebfn Services<\/strong>.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    T\u00ecm \u0111\u1ebfn SQL Server (MISACUKCUKVN)<\/strong>, nh\u1ea5n chu\u1ed9t ph\u1ea3i, v\u00e0 ch\u1ecdn Stop<\/strong>.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    Ti\u1ebfp theo, quay l\u1ea1i m\u00e0n h\u00ecnh g\u1ee1 c\u00e0i \u0111\u1eb7t \u1edf b\u01b0\u1edbc tr\u01b0\u1edbc v\u00e0 nh\u1ea5n Retry<\/strong>.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    \u0110\u1ee3i windows g\u1ee1 xong ph\u1ea7n m\u1ec1m. Sau \u0111\u00f3, quay l\u1ea1i Control Panel<\/strong> ki\u1ec3m tra. N\u1ebfu kh\u00f4ng th\u1ea5y Microsoft SQL Server 2005 th\u00ec t\u1ee9c l\u00e0 \u0111\u00e3 g\u1ee1 th\u00e0nh c\u00f4ng.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    <\/div><\/div><\/span><\/p>\n

    <\/div><\/span><\/p>\n

    <\/span>
    \n
    <\/span>B\u01b0\u1edbc 3: C\u00e0i \u0111\u1eb7t ph\u1ea7n m\u1ec1m SQL Server 2017<\/div>
    <\/span><\/p>\n

    L\u01b0u \u00fd:<\/strong> T\u1eeb phi\u00ean b\u1ea3n R113.0.0.109 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p b\u1ed9 c\u00e0i SQL Server 2017<\/span><\/p>\n

    Download phi\u00ean b\u1ea3n Server ENT, Sale phi\u00ean b\u1ea3n t\u1eeb R113.0.0.109 ho\u1eb7c m\u1edbi h\u01a1n<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    \u1ede b\u01b0\u1edbc n\u00e0y, c\u00f3 02 c\u00e1ch th\u1ef1c hi\u1ec7n:<\/span><\/p>\n

    <\/div><\/span>
    \n
    <\/span>C\u00e1ch 1: Gi\u1ea3i n\u00e9n b\u1ed9 c\u00e0i CUKCUK v\u00e0 c\u00e0i th\u1ee7 c\u00f4ng SQL Server 2017<\/div>
    <\/div><\/div><\/span><\/p>\n

    Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o file CUKCUK Setup c\u00f3 \u0111u\u00f4i .exe (ENT ho\u1eb7c Sale). <\/span>Ch\u1ecdn 7zip ho\u1eb7c b\u1ea5t k\u1ef3 ph\u1ea7n m\u1ec1m gi\u1ea3i n\u00e9n n\u00e0o \u0111\u1ec3 ti\u1ebfn h\u00e0nh gi\u1ea3i n\u00e9n b\u1ed9 c\u00e0i.<\/span><\/span><\/p>\n

    \"\"<\/span><\/p>\n

    Sau khi gi\u1ea3i n\u00e9n th\u00e0nh c\u00f4ng s\u1ebd xu\u1ea5t hi\u1ec7n th\u01b0 m\u1ee5c CUKCUK Setup.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    Ti\u1ebfp theo, m\u1edf th\u01b0 m\u1ee5c: ISSetupPrerequisites\/ SQL Server 2017.\u00a0<\/strong><\/span>Sau khi m\u1edf s\u1ebd th\u1ea5y file SQLEXPR_x63_ENU.exe. Nh\u1ea5n <\/span>chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Run as Administrator<\/strong>. Ch\u1ecdn Yes<\/strong>.<\/span><\/span><\/p>\n

    \"\"<\/span><\/p>\n

    Sau \u0111\u00f3 s\u1ebd xu\u1ea5t hi\u1ec7n h\u1ed9p tho\u1ea1i Choose Directory For Extracted Files<\/strong>.\u00a0<\/span>Ch\u1ecdn\u00a0OK.<\/strong><\/span><\/span><\/p>\n

    \"\" <\/span><\/p>\n

    T\u1ea1i h\u1ed9p tho\u1ea1i SQL Server Installation Center, c<\/span>h\u1ecdn\u00a0New SQL Server stand-alone installation or add features to an existing installation.<\/strong><\/span><\/span><\/p>\n

    \"\"<\/span><\/p>\n

    \u0110\u1ee3i 1 l\u00e1t s\u1ebd xu\u1ea5t hi\u1ec7n SQL Server 2017 Setup. Nh\u1ea5n Next<\/strong>.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    V\u00e0 nh\u1ea5n Next<\/strong> ti\u1ebfp.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    T\u00edch ch\u1ecdn Perform a new installation of SQL Server 2017. <\/strong><\/span>Nh\u1ea5n Next<\/strong>.\"\"<\/span><\/span><\/p>\n

    T\u00edch ch\u1ecdn I accept the license terms<\/strong>. Nh\u1ea5n Next<\/strong>.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    Nh\u1ea5n Next<\/strong> ti\u1ebfp.<\/span><\/p>\n

    \"\"<\/span><\/p>\n

    \u0110i\u1ec1n c\u00e1c th\u00f4ng tin sau:<\/span><\/p>\n

      \n
    • Named instance: MISACUKCUKVN<\/span><\/li>\n
    • Instance ID: MISACUKCUKVN<\/span><\/li>\n<\/ul>\n

      L\u01b0u \u00fd: N\u1ebfu kh\u00f4ng \u0111i\u1ec1n \u0111\u00fang th\u00f4ng tin tr\u00ean, CUKCUK s\u1ebd kh\u00f4ng th\u1ec3 k\u1ebft n\u1ed1i \u0111\u1ebfn SQL Server \u0111\u01b0\u1ee3c.<\/span><\/p>\n

      Nh\u1ea5n Next<\/strong>.<\/span><\/p>\n

      \"\"<\/span><\/p>\n

      Nh\u1ea5n Next<\/strong>.<\/span><\/p>\n

      \"\"<\/span><\/p>\n

      T\u00edch ch\u1ecdn\u00a0 Mixed Mode (SQL Server authentication and Windows authentication). <\/strong><\/span>Nh\u1eadp c\u00e1c th\u00f4ng tin sau:<\/span><\/span><\/p>\n

        \n
      • Enter password:\u00a0abcABC123<\/span><\/li>\n
      • Confirm password:\u00a0abcABC123<\/span><\/li>\n<\/ul>\n

        Nh\u1ea5n Next<\/strong>.<\/span><\/p>\n

        \"\"<\/span><\/p>\n

        Ch\u1edd c\u00e0i \u0111\u1eb7t xong.\u00a0<\/span>Nh\u1ea5n Close \u0111\u1ec3 ho\u00e0n t\u1ea5t c\u00e0i \u0111\u1eb7t.<\/span><\/span><\/p>\n

        \"\"<\/span><\/p>\n

        Qu\u00e1 tr\u00ecnh c\u00e0i \u0111\u1eb7t SQL Server 2017 \u0111\u00e3 th\u00e0nh c\u00f4ng.<\/span><\/p>\n

        <\/div><\/span>
        \n
        <\/span>C\u00e1ch 2: C\u00e0i \u0111\u1eb7t tr\u1ef1c ti\u1ebfp t\u1eeb b\u1ed9 c\u00e0i<\/div>
        <\/div><\/div><\/span><\/p>\n

        Tr\u01b0\u1edbc ti\u00ean, g\u1ee1 phi\u00ean b\u1ea3n CUKCUK \u0111ang s\u1eed d\u1ee5ng. Ti\u1ebfp theo,<\/span> c\u00e0i \u0111\u1eb7t b\u1ea3n CUKCUK v\u1eeba download. <\/span>Sau khi c\u00e0i \u0111\u1eb7t xong, kh\u00f4ng \u0111\u0103ng nh\u1eadp ngay m\u00e0 th\u1ef1c hi\u1ec7n kh\u00f4i ph\u1ee5c d\u1eef li\u1ec7u.<\/span><\/span><\/p>\n

        D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc kh\u00f4i ph\u1ee5c d\u1eef li\u1ec7u:<\/strong><\/span><\/p>\n

        M\u1edf Microsoft SQL Server Studio Management.\u00a0<\/strong><\/span>Nh\u1eadp c\u00e1c th\u00f4ng tin sau:<\/span><\/span><\/p>\n

          \n
        • ServerName: .\\MISACUKCUKVN<\/span><\/li>\n
        • Authentication: SQL Server Authentication<\/span><\/li>\n
        • Login: sa<\/span><\/li>\n
        • Password: abcABC123<\/span><\/li>\n<\/ul>\n

          Nh\u1ea5n Connect<\/strong>.<\/span><\/p>\n

          \"\"<\/span><\/p>\n

          T\u1ea1i th\u01b0 m\u1ee5c Database, nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Restore Database.<\/span><\/span><\/p>\n

          \"\"<\/span><\/p>\n

          T\u1ea1i \u00f4\u00a0Device,\u00a0<\/strong>nh\u1ea5n v\u00e0o d\u1ea5u ...<\/span><\/p>\n

          \"\"<\/span><\/p>\n

          Ch\u1ecdn Add<\/strong>.<\/span><\/p>\n

          \"\"<\/span><\/p>\n

          T\u00ecm \u0111\u1ebfn \u0111\u01b0\u1eddng d\u1eabn l\u01b0u file .mbk backup d\u1eef li\u1ec7u \u0111\u00e3 backup.\u00a0<\/span>Thay \u0111\u1ed5i l\u1ef1a ch\u1ecdn combobox th\u00e0nh All Files (*) s\u1ebd th\u1ea5y file backup. Nh\u1ea5n\u00a0OK.<\/strong><\/span><\/span><\/p>\n

          \"\"<\/span><\/p>\n

          Nh\u1ea5n\u00a0OK.<\/strong><\/span><\/p>\n

          \"\"<\/span><\/p>\n

          Nh\u1ea5n\u00a0OK.<\/strong><\/span><\/p>\n

          \"\"<\/span><\/p>\n

          Ch\u1edd ch\u1ea1y xong s\u1ebd c\u00f3 th\u00f4ng b\u00e1o th\u00e0nh c\u00f4ng<\/span><\/p>\n

          \"\"<\/span><\/p>\n

          Nh\u1ea5n\u00a0OK.\u00a0<\/strong><\/span><\/span>Nh\u01b0 v\u1eady, vi\u1ec7c n\u00e2ng c\u1ea5p \u0111\u00e3 th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng.<\/span><\/p>\n

          <\/div><\/div><\/span><\/p>\n

          <\/div><\/span><\/p>\n

          Ch\u00fac Anh\/Ch\u1ecb th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/strong><\/em><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc n\u00e2ng c\u1ea5p t\u1eeb SQL Server 2005 Express l\u00ean SQL Server 2017 Express Ch\u00fac Anh\/Ch\u1ecb th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/p>\n","protected":false},"author":113,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[3599],"ht-kb-tag":[],"class_list":["post-29891","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cac-thiet-lap-khac-2-huong-dan-nghiep-vu-su-dung-thi-truong-duc_eu"],"_links":{"self":[{"href":"\/vi\/wp-json\/wp\/v2\/ht-kb\/29891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"\/vi\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"\/vi\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"\/vi\/wp-json\/wp\/v2\/users\/113"}],"replies":[{"embeddable":true,"href":"\/vi\/wp-json\/wp\/v2\/comments?post=29891"}],"version-history":[{"count":5,"href":"\/vi\/wp-json\/wp\/v2\/ht-kb\/29891\/revisions"}],"predecessor-version":[{"id":30075,"href":"\/vi\/wp-json\/wp\/v2\/ht-kb\/29891\/revisions\/30075"}],"wp:attachment":[{"href":"\/vi\/wp-json\/wp\/v2\/media?parent=29891"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"\/vi\/wp-json\/wp\/v2\/ht-kb-category?post=29891"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"\/vi\/wp-json\/wp\/v2\/ht-kb-tag?post=29891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}