Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Installing SQL Server Express 2008 & Studio on Windows 8 Expand / Collapse
Posted Tuesday, April 30, 2013 6:46 AM


Group: General Forum Members
Last Login: Friday, March 13, 2015 2:34 PM
Points: 100, Visits: 243
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!

Post #1447994
Posted Tuesday, May 7, 2013 4:42 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 5:40 AM
Points: 3,052, Visits: 3,771
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: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 29 Aug 2016: now over 38,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "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
Post #1450051
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse