THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

Installing SQL Server 2012 on Windows 2012 Server

In Want to Learn SQL Server 2012? I wrote about obtaining a fully-featured version of SQL Server 2012 (Developer Edition).

This post represents one way to install SQL Server 2012 Developer Edition on a Hyper-V virtual machine running the Windows 2012 Server Standard Edition operating system. This is by no means exhaustive. My goal in writing this is to help you get a default instance of SQL Server 2012 up and running. I do not cover setting up the Hyper-V virtual machine. I begin after loading the SQL Server 2012 Developer Edition ISO file into the VM’s CD/DVD drive.

Navigate to the installation drive folder. Right-click setup.exe and click “Run as administrator” as shown in Figure 1:

Figure 1

This starts the SQL Server Installation Center. Click the Installation page from the list on the left side, and then click the top link (“New SQL Server stand-alone installation or add features to an existing installation”):

Figure 2

Setup conducts eight checks for things that could interfere with a successful installation of SQL Server:

Figure 3

Next, enter the product key. If you are installing SQL Server 2012 Developer Edition, the value appears for you on the screen shown in Figure 4:

Figure 4

The next screen prompts you to accept the license terms. You can also opt to send anonymous feature usage data to Microsoft. I do this and recommend you do too. Why? Microsoft actually uses this data to qualify and prioritize future development efforts.

Figure 5

Setup checks for conditions that may interfere with the installation of setup support files:

Figure 6

You next select the setup role in the installation process. I like the option “All Features With Defaults,” as shown in Figure 7:

Figure 7

When you select the “All Features With Defaults” option, the next screen – Feature Selection – is prepopulated, as shown in Figure 8:

Figure 8

Setup next checks installation rules:

Figure 9

Figure 10 shows the next step in the process, SQL Server instance configuration:

Figure 10

Disk space calculations are next…

Figure 11

… followed by service account configuration:

Figure 12

Database engine configuration includes Authentication Mode and SQL Server Administrators. You can accept the defaults if you want. I use Mixed Mode Authentication (combined with very strong passwords) for my installations. Clicking the Add Current User button adds me to the SQL Server administrators, as shown in Figure 13:

Figure 13

Analysis Services setup is next. Although Figure 14 does not show it, I mostly work with Tabular Model these days. As before, I click the Add Current User button to add this account to the Administrators:

Figure 14

Accept the defaults for Reporting Services configuration as shown in Figure 15:

Figure 15

I haven’t used the Distributed Replay Client (DRC) yet, but it is on my list of SQL Server 2012 stuff to learn. I click the Add Current User button:

Figure 16

Give the DRC a name similar to the server name, as shown in Figure 17:

Figure 17

Select Error Reporting options as shown in Figure 18:

Figure 18

Installation configuration rules are checked for consistency and readiness, shown in Figure 19:

Figure 19

Figure 20 confirms the installation is ready to begin:

Figure 20

When the installation is complete, the Complete window displays as shown in Figure 21:

Figure 21

A bunch of new cool tiles appear on your Windows 2012 Server start page, as shown in Figure 22:

Figure 22

And you are done! Installation is complete and you are ready to begin exploring SQL Server 2012!


Published Sunday, October 28, 2012 2:00 PM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Jim said:

If nothing else the final shows why the "interface formerly known as Metro" doesn't suit a server O/S.

October 28, 2012 6:11 PM

Greg Low said:

Hey Andy,

Would love to hear your thoughts on the desktop tiles on servers. Thumbs up or down?

October 28, 2012 6:47 PM

andyleonard said:

Hi Greg and Jim,

  I don't know yet about the Metro-style tiles. All I can say for now is "They are different." I haven't yet formed an opinion about their usefulness, but I haven't really had time, yet.


October 28, 2012 9:39 PM

Chris R. Chapman said:

Having just done a production installation of SQL2012 on a Win2012 server, I can wholeheartedly concur with the annoyance of the Metro UI. It's going to cause some pain for infrastructure folks for some time - we're all going to need to get used to hitting the Windows logo key and typing what we're looking for and hoping it appears.

October 29, 2012 10:22 AM

Steve R said:

Quick find over the weekend, right click tile, e.g. SSMS tile and select/click on bottom the "Open File location" and it will take you to what you would see "as shortcuts" in the old start>-programs-> etc...

October 29, 2012 2:24 PM

pwehland said:

Distributed Replay seems to be a tool that came out of the test group and was put into the product late in the game without a lot of thought or testing.  The setup is incomplete and buggy, you need to spend hours debugging it until you understand that setup installs it wrong.  It needs more work and is NOT ready for the mainstream.

October 30, 2012 5:21 AM

Ian Yates said:

I've got a few Windwows Server 2012 VMs and physical boxes around the place now.  I reckon I've looked at the start screen maybe 5 times total - it just hasn't been a big deal.

The only server where I've used it was a terminal server I set up on which I deliberately turned on desktop experience, etc :)

My habits may not be like other users, but I've always hit the Win key on the keyboard and just typed to get what I want.  That, or I did Win+R and typed ssms, winword, devenv, cmd, http://www.*.com, etc  to get what I wanted.  Mousing around and pecking through the XP/Vista/7 start menu drives me nuts.  I have organised a few tiles on the "metro" start screen for desktop apps and it's working pretty well although it's effort to get right.

You can also run "Classic Shell" - it's free and brings back a version of the start menu.  I run it on Win 7 and disable all of its classic shell stuff except for bringing back the display of the security zone in Internet Explorer - it's nice to know if the site I'm looking at was correctly recognised as local intranet, internet or trusted.

My 2c :)

October 31, 2012 2:05 AM

Victor Brink said:

When I installed Sql Server 2012 on Server 2012 Standard (test VM), after checking .Net 4.5 was enabled, install failed - required NetFX 3 wsa missing, and setup rolled back.

Sergio Govoni posted the solution here:

Pity the dependency checker in Sql Server 2012 installer doesn't pickup the missing dependency ;)

September 15, 2014 5:44 PM

Yogendra Mehta said:

If you can help me.....

sql server 2008 r2 on Windows 7

Problem : Large number of Links report serious headaches

when trying to install

sql server 2008 r2

on Windows 7 ( say on a laptop )

almost NO good SQL Server book has this installation done on Windows 7

Book authors often do not indicate OS/platform they used for installation/screen shots

except one book ( SSRS 2008 by Jayaram Krishnaswamy  isbn - 978-81-8404-781-3 / see pg 14 )

has it on Windows XP

Also, DBAs prefer clean slate ( machine ) to begin with

then installation success chance is very high

my Request now :

if you can indicate if

sql server 2008 r2 developer edition ( 32-bit OR 64-bit )

can be installed problem free

on Windows 7 professional (32/64 bit)  

( it's CLEAN new laptop I am going to use )

could not find any link W/O problem

January 2, 2015 9:55 AM

Kazzachat Sheyin said:

Can you show screen shots of the report pages and or the errors please? it might be a combination of different issues.

February 26, 2016 10:38 AM

Olivelibre said:

Gracias NEXT....

March 24, 2017 4:38 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement