Install SQL Server 2012 on Windows Server 2008 R2 Service Pack 1
April 01, 2012
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.
"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.
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.
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.
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.
Click on Next Page to continue reading rest of the article…
Continue Free Learning...