Installing SQL Server Express 2008 & Studio on Windows 8

  • Hello all. My first post here. My question probably will seem amateur as I'm sure I is. I've been hired for a job based on my very old, rusty SQL Server skills. I have quiet a bit of experience using and developing with SQL Server 2000. Yep. 13 years ago.

    I'm trying to brush up on my skills and hit the books hard. I've purchased a new laptop running Windows 8 (ugggh...don't like it!!) and my intention was to install SQL Server 2008 Express and SQL Server Management Studio 2008 on this laptop so I can practice along with the chapters I'm reading. I'm using 2008 since that's what the project I'll soon be working on uses.

    Last night I was able to install SQL Server Express on this laptop (SP3 I think) but had no luck installing SQL Server 2008 Management Studio.

    Has anyone been able to use these two products on Windows 8?

    Or would you recommend I go to the SQL Server 2012 products?

    Thanks for helping out an old dog learn new tricks!

    🙂

  • You need to install .Net 3.5 SP1 on Windows 8 before you can install any version of SQL Server. You need the special install media for Windows 8 found in the \SXS folder, and use the command below to do the install. Apart from that SQL Server 2008 does install OK.

    Dism.exe /online /enable-feature /featurename:NetFX3 /All /Source:"full path to \sxs" /LimitAccess

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply