Install SQL Server 2012 on Windows Server 2008 R2 Service Pack 1

April 01, 2012
Page: 1/9


Microsoft SQL Server 2012 Release to Manufacturing (RTM) was released on 7th Mar 2012. There are different versions of SQL Server 2012 available such as Enterprise Edition, Business Intelligence Edition, Standard Edition, Web Edition, Developer Edition and SQL Server Express LocalDB a new lightweight deployment option for Express. You can download Microsoft SQL Server 2012 Evaluation Edition from the following link and you can download SQL Server 2012 Express Edition from the following link.

In this article we will take a look at how to install SQL Server 2012 on a Windows Server 2008 R2 Service Pack 1. However, the steps mentioned in this article can be followed while installing SQL Server 2012 on Windows Server 2008 Service Pack 2 or later.

If you are new to SQL Server 2012 then I would recommend you to read the following articles to know more about New Features in Microsoft SQL Server 2012.

New Features in SQL Server 2012 for Database Developers
New Features in SQL Server 2012 for Database Administrators
New Features in SQL Server 2012 Reporting Services for Developers

"This article has a total of 9 Pages including this page. Follow the links below to open all 9 Pages in a seperate window to learn how to Install SQL Server 2012. Page 1, Page 2, Page 3, Page 4, Page 5, Page 6, Page 7, Page 8, Page 9"

Prerequisites for SQL Server 2012

Microsoft SQL Server 2012 requires .Net Framework 3.5 Service Pack 1 and .Net Framework 4.0 to be installed on the server. If you install SQL Server 2012 on a computer with the Windows Vista SP2 or Windows Server 2008 SP2 operating system, you can get the required update from here and if required you can download Microsoft .Net Framework 3.5 Service Pack 1 from the following link.

Check the following link to know more about Hardware and Software Requirements for Installing SQL Server 2012.

The above link states that “SQL Server 2012 does not install or enable Windows PowerShell 2.0; however Windows PowerShell 2.0 is an installation prerequisite for Database Engine components and SQL Server Management Studio. If Setup reports that Windows PowerShell 2.0 is not present, you can install or enable it by following the instructions on the Windows Management Framework page.” Once you have installed the prerequisites you may be asked to restart the operating system.

Incase if you don’t meet the Prerequisites for Microsoft SQL Server 2012 you will receive the below mentioned error. Follow the link to meet the prerequisites before you install SQL Server 2012.

Minimum Requirements for SQL Server 2012

Install SQL Server 2012 on Windows Server 2008 R2 SP 1

1. Database Administrator should log on to the server with administrative privileges and then right click Setup.EXE file and choose Run as administrator option from the drop down list as shown in the below snippet.

Install SQL Server 2012 Using Setup.exe

2. Once Prerequisites are installed successfully the setup may ask you to restart the server. Once the server is up after the restart once again run the Setup.EXE file. Once the installation of all the prerequisites are completed successfully the SQL Server Installation Center will open up as shown in the snippet below. You need to navigate to the Options screen as shown in the snippet below to choose the appropriate Processor Type to specify the architecture of SQL Server 2012 to be installed.

Specify the Architecture of SQL Server 2012 to Install 

3. In SQL Server Installation Center’s Installation Screen you need to choose New SQL Server stand-alone installation or add features to an existing installation option as highlighted to install a standalone instance of SQL Server 2012.

New SQL Server Stand-alone Installation or Add Features to an existing installation

Click on Next Page to continue reading rest of the article…

Next Page.. How to Install SQL Server 2012 on Windows Server 2008 R2 SP1

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article

Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect your privacy and you can unsubscribe at any time."