{"id":408,"date":"2016-02-22T15:21:56","date_gmt":"2016-02-22T20:21:56","guid":{"rendered":"http:\/\/www.lazytrap.com\/trapped\/?p=408"},"modified":"2018-05-21T15:30:15","modified_gmt":"2018-05-21T20:30:15","slug":"installing-2008-sql-on-windows-server-2012","status":"publish","type":"post","link":"http:\/\/www.lazytrap.com\/trapped\/?p=408","title":{"rendered":"Installing 2008 SQL on Windows Server 2012"},"content":{"rendered":"

Keeping this short and sweet.<\/p>\n

Problem: SQL Server Full 2008 Server installation media fails on Windows Server 2012. It is however a supported platform, so there has to be a way.<\/p>\n

Solution: Update installer package and slipstream updates from SP1 prior to setup.<\/p>\n

    \n
  1. Copy DVD\/.ISO Installer medium from original 2008 SQL Full to a directory on C:\\, such as C:\\SQLServer<\/li>\n
  2. Download SP1 packs from Microsoft\n
      \n
    1. Download all versions (x86, x64, ia64) to keep things simple<\/li>\n
    2. Currently it can be found\u00a0@\u00a0https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=20302<\/a><\/li>\n<\/ol>\n<\/li>\n
    3. Extract service packs to PCU directory\n
        \n
      1. examples:\n
          \n
        1. SQLServer2008SP1-KB968369-IA64-ENU.exe \/x:c:\\SQLServer\\PCU
          \nSQLServer2008SP1-KB968369-x86-ENU.exe \/x:c:\\SQLServer\\PCU
          \nSQLServer2008SP1-KB968369-x64-ENU.exe \/x:c:\\SQLServer\\PCU<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
        2. Replace original Setup.exe and Setup.rll with those from the service packs.\n
            \n
          1. copy C:\\SQLServer\\PCU c:\\SQLServer Setup.exe
            \ncopy C:\\SQLServer\\PCU c:\\SQLServer Setup.rll<\/li>\n<\/ol>\n<\/li>\n
          2. Update\u00a0original setup\u2019s architecture files (x64, etc.) with those from SP1;\u00a0excluding\u00a0Microsoft.SQL.Chainer.PackageData.dll\u00a0<\/strong>(thanks petersad)\n
              \n
            1. robocopy C:\\SQLServer\\pcu\\x86 C:\\SQLServer\\x86 \/XF Microsoft.SQL.Chainer.PackageData.dll
              \nrobocopy C:\\SQLServer\\pcu\\x64 C:\\SQLServer\\x64 \/XF Microsoft.SQL.Chainer.PackageData.dll
              \nrobocopy C:\\SQLServer\\pcu\\ia64 C:\\SQLServer\\ia64 \/XF Microsoft.SQL.Chainer.PackageData.dll<\/li>\n<\/ol>\n<\/li>\n
            2. Run SQL Server 2008 setup specifying PCU source\n
                \n
              1. Setup.exe \/PCUSource=C:\\SQLServer\\PCU<\/li>\n<\/ol>\n<\/li>\n
              2. Follow the rest of the prompts as usual<\/li>\n
              3. After finished, reboot, then install SP2\/SP3\/whatever.<\/li>\n<\/ol>\n

                I still came across some compatibility errors at the begining when running the setup, but when ignoring them (\u201crun anyways\u201d) the installer moved forward without issue. People will have mixed results with these steps as I had mixed results from other peoples\u2019 solutions myself and these were my final steps. If you have further problems, you might check out the links below as alternatives.<\/p>\n

                http:\/\/blogs.msdn.com\/b\/petersad\/archive\/2009\/06\/17\/creating-a-merged-slipstreamed-drop-containing-sql-server-2008-rtm-service-pack-1.aspx<\/a>
                \n                http:\/\/blogs.msdn.com\/b\/petersad\/archive\/2009\/03\/02\/sql-server-2008-basic-slipstream-steps.aspx<\/a><\/p>\n

                 <\/p>\n","protected":false},"excerpt":{"rendered":"

                Keeping this short and sweet. Problem: SQL Server Full 2008 Server installation media fails on Windows Server 2012. It is however a supported platform, so there has to be a way. Solution: Update installer package and slipstream updates from SP1 prior to setup. Copy DVD\/.ISO Installer medium from original 2008 SQL Full to a directory\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87,88],"tags":[134,132,137,136,131,135,133,89],"jetpack_featured_media_url":"http:\/\/www.lazytrap.com\/trapped\/wp-content\/uploads\/2018\/05\/windows.png","_links":{"self":[{"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=\/wp\/v2\/posts\/408"}],"collection":[{"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=408"}],"version-history":[{"count":2,"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions"}],"predecessor-version":[{"id":417,"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions\/417"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=\/wp\/v2\/media\/363"}],"wp:attachment":[{"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=408"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.lazytrap.com\/trapped\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}