Install SQL Server 2012 in Windows Server 2012 R2MustBeGeek

Spread the love

SQL Server 2012 is available in 32-bit and 64-bit. Installation of SQL Server 2012 is fairly easy. The installation wizard provides easy interface to install components of SQL server. In this post, I will show steps to install SQL Server 2012 in Windows Server 2012 R2.

Install SQL Server 2012 in Windows Server 2012 R2

Don’t forget to checkout minimum hardware and software requirements before you install SQL Server 2012. Insert the SQL Server 2012 installation DVD. Before you start to install the SQL server, install the NetFx3 feature, otherwise you will get error while the installation is in progress. To install the NEtFx3, type the following command in command prompt as shown in the snapshot below. Make sure you have inserted the installation media.

c:\> dism /online /enable-feature /featurename:netfx3 /all /source:d:\sources\sxs

To start the SQL server installation, click the first option after selecting installation tab from the installation center as shown below. Since this is going to be new SQL server installation select the first option.

The installation will then check all the pre-requisites that are required to install the SQL server. If everything is fine, you will see green checks as shown below. Click OK.

Enter the product key and click Next. Or choose evaluation edition and click Next.

Accept the license terms and click Next.

Check to include SQL server product updates and click Next.

The installation will now download the setup files as shown below.

The installation does the pre-requisite checks once again as you can see below.

On the Setup Role page, choose SQL server feature installation and click Next.

Select the required SQL features and click Next.

After the rules are checked as shown below, click Next.

Under Instance Configuration, choose Default instance. You can also define custom instance name. Similarly, you have the option to choose the location where the instance will be stored. I will leave the defaults and click Next button.

Under Disk Space Requirements, the installation will show the disk spaces as shown below.

Under Server Configuration, review the Service Accounts, I will leave the defaults. Here, you can also use Active Directory user for various SQL services.

Under Database Engine Configuration, choose Windows authentication mode. You also have option to choose both windows authentication and SQL server authentication. Then, add the users who will be managing this SQL server and click Next.

Under Error Reporting, review the information and click Next. Likewise, under Installation and Configuration Rules as shown below, verify whether all the rules are passed and click Next.