March 1, 2012 | SQL Server, SQL Server 2012

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:


 

12 comments on this post

    • Glenn Berry - March 2, 2012, 1:25 AM

      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

    • AaronBertrand - March 2, 2012, 1:30 AM

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

    • AaronBertrand - March 2, 2012, 1:57 AM

      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/

    • Jason - March 2, 2012, 5:34 AM

      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.

    • Aaron Bertrand - March 2, 2012, 5:38 AM

      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.

    • Jason - March 2, 2012, 3:13 PM

      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 😉

    • IL - March 5, 2012, 3:16 PM

      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/

    • mark blakey - March 6, 2012, 8:26 PM

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

    • HarshB - March 9, 2012, 12:43 AM

      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…?

    • Zoltán Horváth - March 13, 2012, 6:34 PM

      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

    • Seapre - March 18, 2012, 9:32 AM

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

    • DutchHarry - April 21, 2012, 2:02 AM

      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?

Comments are closed.