July 17, 2014

How to Install SQL Server 2012 on Windows Server 2012 R2

Now I have gotten SQL Server 2012 Enterprise version, but how can I install it on computer or server?
First, let’s see which Windows system SQL Server 2012 installation requires. And install SQL Server 2012 on that Windows system. Besides, we have to pay attention to the preparation needed for SQL Server 2012 installation.

1. Windows system requirement


From the description of Microsoft support, we know that SQL Server 2012 Enterprise, not only 32-bit, but also 64-bit, has to be installed on Windows Server 2012 Essentials 64-bit.

And now I have to install Windows Server 2012 Essentials 64-bit on VMware. Let’s take a try with following introductions.

2. Steps to install SQL Server 2012 on Windows Server 2012 R2


Because what we get is SQL Server 2012 ISO file, so we have to add it to virtual disk on Virtual Machine first. And then open SQL Server 2012 ISO file in virtual disk, so we could run SQL Server setup program.

Step 1: SQL Server Installation Center runs.
enter SQL Server installation center

Step 2: Select “Installation” option and click “New SQL Server- stand-alone installation or add features to an existing installation”.

Step 3: Wait a minute when Microsoft SQL Server 2012 Setup processes the current operation.
wait for SQL Server 2012 setup process

Step 4: SQL Server 2012 Setup Support Rules identity problems that might occur when you install SQL Server Setup support files. Failures must be corrected before Setup can continue. Click “OK”.
SQL Server 2012 setup support files

Step 5: Specify a free edition or “Enter the product key” for SQL Server 2012.
enter SQL Server 2012 product key

Step 6: Accept the license terms and click “Next”.
accept SQL Server 2012 license terms

Step 7: Click Next after Product Updates.
SQL Server 2012 product updates

Step 8: Install Setup Files.
install SQL Server setup files

Step 9: Setup Support Rules again and their status is listed.
SQL Server setup support files identify problems

Tips: If the warning is not so important to influence SQL Server 2012 installation, we can ignore it and click “Next”. If it would make SQL Server installation failure on feature you need to install, solve the problem first and then begin to install SQL Server 2012.

For example, .Net Framework 3.5 would make SQL Server manage tools installation failed, so we have to make sure it has been installed successfully in Windows system or turned on. But unfortunately, .Net Framework 3.5 could not been turned on like other Windows features in Windows Server 2012 (R2) or Windows 8/8.1. So if you have any question on .Net Framework 3.5 installation, please turn to Microsoft support: http://support.microsoft.com/kb/2734782

Or get details here to install it when you have Windows Server 2012 R2 installation disc:

Step 10: Select “SQL Server Feature Installation” in “Setup Role” and click “Next”.
choose SQL Server feature installation

Step 11: Select the SQL Server Enterprise features to install.
select SQL Server features to install

Step 12: Run rules to determine if the installation process will be blocked. Click Next.
SQL Server Setup runs rules

Step 13: Specify the name and instance ID of the instance of SQL Server.
Instance ID becomes the part of the installation path.

Step 14: Server Configuration. Specify the service accounts and collation configuration. Click “Next”.
specify server and SQL Server services account

Step 15: Specify Database Engine authentication security mode, administrators and data directories. Click Next.
configure SQL Server Database Engine

Step 16: Specify Analysis Services server modes, administrators, and data directories. Click Next.
configure SQL Server analysis services

Step 17: Specify the corresponding controller and data directories for Distributed Replay Client, including Working Directory and Result Directory. Click Next.
configure SQL Server directory locations

Step 18: Verify the SQL Server 2012 features and click “Install” to install them on Windows Server 2012 R2.
verify and install SQL Server features

Step 19: And then you would get a message which SQL Server features you selected has been installed successfully. Click “Close” and then run SQL Server 2012 on Windows Server 2012 R2.
complete SQL Server 2012 installation

3. Something in installation we should pay attention:


.Net Framework 3.5 is needed in SQL Server 2012 installation, but it could not be added into Windows system just by turning on such Windows features. The easiest way is to specify source file when you try to install it in Windows system. 

Related Articles:

No comments:

Post a Comment