Installing Windows Server 8 & SQL Server 2012

Microsoft recently released Windows Server "8" Beta for download. When you launch setup you'll be asked if you want to install Server Core or Server with a GUI:

 

While I will definitely be leaning toward Server Core for production, I chose the GUI installation for now just to feel my way around for a bit on a local VM. Also because it would be tough to demo all of SQL Server 2012's features from a Server Core VM.

Next during setup you will be asked if you want to upgrade or create a new installation. The upgrade is pre-selected, so be careful about pressing Enter here since – if you are installing on a VM – there is unlikely to be a pre-existing version of Windows on the VHD you just finished allocating:

 

From there installation itself was pretty simple, a lot like previous versions of Windows. The slowest part was "Expanding files" – I'm on SSD so I can't even imagine how slow this is going to seem for you platter folks. Just a little warning. Though I did experience a snafu when installing VMWare Tools (I run VMWare Fusion) – the VM froze up. I've also heard about some issues with the VMWare Tools for VMWare Workstation. So, depending on your virtualization platform, your mileage may vary.

Two things needed to be changed immediately. One was the resolution – the default is 1024 x 768 and this is horribly unusable. Once I was up to 1680×1050 (right-click the desktop and choose "Screen Resolution"), I wanted my Start Menu back. So I ran the following command provided in Mikael Nystrom's blog post (there is also a PowerShell version):

reg.exe add HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer /v RPEnabled /d 0 /t REG_DWORD /f

Sadly, these tricks were written for the Consumer Preview, but they do not seem to work for server. If you've enbled the Start Menu on server, please let me know how you did it and I will update this post (and my VM).

One other thing I wanted to change was file extensions. I tried to create a .ps1 script on my desktop and it was actually called .ps1.text. This is one of those "let's cater to dummies" features that I've always hated, and lack of disciplined extensions is actually one of the things I like less about Mac OS. Anyway Windows Explorer now has a ribbon, and some of these settings are much easier to get to compared to the old Tools / Folder Options path:

 

Once Windows Server 8 was up and running (almost) the way I like, it was time to install SQL Server 2012 RC0. Remembering my trials with an earlier preview of Windows 8, and after reading Allan Hirt's blog post, I knew that I would have to manually install .NET Framework 3.5 in order to install SQL Server 2012. Allan outlines how to do this with the command line:

dism /online /enable-feature /featurename:NetFx3 /source:d:\sources\sxs\

I did this, and it reported success:

 

However, after restarting the system, when I went into the Server Roles and Features wizard, the .NET 3.5 feature was still not enabled. So I stepped through the wizard to add the feature, and rebooted again.

 

 

 

 

 

 

 

 

 

Once I rebooted, I validated that .NET 3.5 was correctly installed according to Server Manager. I went through the SQL Server setup and, once I had made all of my feature and other configuration selections, it took about 12 minutes to install SQL Server. When it was finished, it had placed a whole slew of tiles onto the Metro start page:

 

So, a lot of cleanup necessary here. But I have SQL Server, Management Studio and I can start to play:


 

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

12 Responses

  1. DutchHarry says:

    All worked out allright, except
    Master Data Services throws an error, even after putting in all the required IIS role services and chnagi framework verion to 2 in IIS and correcting for the missing .svc handler
    It still says Static Content Compression is not installed (while it is!).
    Any clues?

  2. Seapre says:

    I had installed SQL Server 2012 on Server 8 Beta, and figured out the VMware Tools issue.
    Nice to see your share.

  3. Zoltán Horváth says:

    Unfortunately I wasn't aware of this post. Shame on me. However if someone tries with SQL 2012 RTM on Windows 8 Consumer Preview, my 2 cents are here:
    http://addictivemeasures.blogspot.com/2012/03/how-to-install-sql-2012-on-windows-8.html
    Regards,
    Zoli

  4. HarshB says:

    Hi Aaron,
    Nice post. Installed Windows 8. Now I am downloading SQL 2012 RTM and VS 11 beta as we speak.
    About the Start Button… I am actually getting used to what is available out of the box.  Here is my thought…
    http://www.biznique.com/library/2012/03/08/windows-server-8-start-button/
    Maybe – we don't need any custom code… just a matter of getting used to…?

  5. mark blakey says:

    feeling left out that i dont have a laptop with ssd.

  6. IL says:

    Aaron, may be Windows Server 8 "Do not show the Start Menu when the user logs in" group policy setting under "under User Configuration > Policies > Administrative Templates > Start Menu and Taskbar" let you bypass Metro Start menu
    http://www.grouppolicy.biz/2012/03/the-must-have-windows-8-start-menu-group-policy-setting/

  7. Jason says:

    I didn't mean to come across as directly questioning you, just wanted to share that it didn't seem too bad for us slow spinners 😉

  8. Aaron Bertrand says:

    James I will confess I didn't time it. I'm just basing it on log times, as I had switched away to other tasks. I should go look closer at the log.

  9. Jason says:

    Thanks for the write up.  Regarding the SSDs and install speed, I've got a lowly old dual core AMD and 8GB of RAM.  I installed in a VM in HyperV with 2 vcpus and 4GB of RAM, and it didn't seem to take but 5 minutes.  I've got a dedicated spinning drive (7200 RPM SataII) for my VM's.

  10. AaronBertrand says:

    Found an answer for the start menu (or at least something that gets us close):
    http://www.askvg.com/manual-method-get-classic-start-menu-back-in-windows-7-without-using-3rd-party-software/

  11. AaronBertrand says:

    Thanks Glenn! I added a second SSD earlier this year and I had a 128GB partition waiting exactly for this.

  12. Glenn Berry says:

    Good post, Aaron. Impressed that you had the disk space and VM setup to do this so quickly while you were at the MVP Summit