{"id":195,"date":"2010-03-30T13:54:21","date_gmt":"2010-03-30T17:54:21","guid":{"rendered":"http:\/\/ryepup.unwashedmeme.com\/blog\/?p=195"},"modified":"2010-03-30T13:54:21","modified_gmt":"2010-03-30T17:54:21","slug":"installing-vs-2008-and-sql-2008-express-on-windows-7","status":"publish","type":"post","link":"http:\/\/ryepup.unwashedmeme.com\/blog\/2010\/03\/30\/installing-vs-2008-and-sql-2008-express-on-windows-7\/","title":{"rendered":"Installing VS 2008 and SQL 2008 Express on Windows 7"},"content":{"rendered":"

A new decade means time for a fresh windows install at work.\u00c2\u00a0 I ran into some trouble with windows 7, visual studio 2008, and SQL 2008 Express.\u00c2\u00a0 Here’s how I resolved them.\u00c2\u00a0 Contrary to most things I found on the web, I’m not using betas or release candidates.<\/p>\n

First off, installing SQL 2008 Express.\u00c2\u00a0 I only wanted the management tools, and this was a little hard to come by.\u00c2\u00a0 I downloaded various EXE files from MSDN, but none of them worked (they would error out, bring up an seemingly unrelated installer, or any other confusing behavior that may have led you here).\u00c2\u00a0 Here’s what worked for me:<\/p>\n

    \n
  1. Be sure any previous installation attempts have been purged via Add \/ Remove Programs<\/li>\n
  2. Go to the “other install options” page for SQL express: http:\/\/www.microsoft.com\/express\/Database\/default.aspx#Installation_Options<\/a><\/li>\n
  3. Click the “Management Tools” install button (for me that’s: http:\/\/www.microsoft.com\/web\/gallery\/install.aspx?appsxml=www.microsoft.com%2Fweb%2Fwebpi%2F2.0%2FWebProductList.xml%3Bwww.microsoft.com%2Fweb%2Fwebpi%2F2.0%2FWebProductList.xml&appid=134%3B135<\/a>)<\/li>\n
  4. Install the “Microsoft Web Platform Installer” (MWPI) if it asks you to<\/li>\n
  5. Should be straightforward from here on<\/li>\n<\/ol>\n

    The funny thing here is the MWPI seems to download an installer that looks a lot like the one at\u00c2\u00a0Microsoft\u00c2\u00ae SQL Server\u00c2\u00ae 2008 Management Studio Express<\/a> that didn’t work for me.<\/p>\n

    Next up, Visual Studio 2008 (VS2008).\u00c2\u00a0 My company has an MSDN subscription, so we downloaded an ISO (named en_visual_studio_2008_professional_x86_x64wow_dvd_X14-26326.iso) and I used freeware MagicISO<\/a> to mount it, then ran “setup.exe”.\u00c2\u00a0 The install failed on the “Microsoft Visual Studio Web Authoring Component” (MVSWAC).\u00c2\u00a0 Here’s what worked for me:<\/p>\n

      \n
    1. IF YOU WANT SQL2008, DO THAT FIRST<\/li>\n
    2. Be sure any previous installation attempts have been purged via Add \/ Remove Programs<\/li>\n
    3. Download WebDesignerCore.EXE<\/a> from microsoft<\/li>\n
    4. Run it<\/li>\n
    5. Install VS2008 from disc\/iso as normal.<\/li>\n<\/ol>\n

      Digging into the ISO using 7zip<\/a>, the problem is \/WCU\/WebDesignerCore\/WebDesignerCore.EXE is corrupt.\u00c2\u00a0 To get VS2008 to install cleanly, first we need to install MVSWAC, at which point the VS2008 installer will happily skip past the corrupt file.\u00c2\u00a0 I ran across several blog\/forum posts with horror stories about VS2008 installing SQL2005, and needing to uninstall half the planet to get things working right.<\/p>\n

      As always, be sure to hit up windows update, and change your update settings so you get fixes for VS2008 and SQL2008.<\/p>\n

      \n

      Microsoft\u00c2\u00ae SQL Server\u00c2\u00ae 2008 Management Studio Express<\/h1>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      A new decade means time for a fresh windows install at work.\u00c2\u00a0 I ran into some trouble with windows 7, visual studio 2008, and SQL 2008 Express.\u00c2\u00a0 Here’s how I resolved them.\u00c2\u00a0 Contrary to most things I found on the web, I’m not using betas or release candidates. First off, installing SQL 2008 Express.\u00c2\u00a0 I […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,20,42,6],"tags":[],"class_list":["post-195","post","type-post","status-publish","format-standard","hentry","category-annoying","category-mssql","category-visual-studio","category-windows"],"_links":{"self":[{"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/posts\/195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/comments?post=195"}],"version-history":[{"count":3,"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/posts\/195\/revisions"}],"predecessor-version":[{"id":198,"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/posts\/195\/revisions\/198"}],"wp:attachment":[{"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/media?parent=195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/categories?post=195"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/ryepup.unwashedmeme.com\/blog\/wp-json\/wp\/v2\/tags?post=195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}