©2015 - 2022 Chad’s Technoworks. Disclaimer and Terms of Use

Chad’s TechnoWorks My Journal On Technology

Information Technology

Installing SQL Server 2008 R2 In Windows Server 2012 R2

Installing SQL Server on a higher version of Windows Server can be problematic at times.

I am sharing this installation steps on how to overcome the hurdles. At the initial phase of the install, you’ll see a warning dialog of compatibility issues with SQL Server 2008 R2. Only SQL Server 2008 R2 Service Pack 2 (SP2) is certified to run on Windows Server 2012 R2. Since the base install doesn’t come with the service update, I’ll have to go through the installation process with the occasional bumps and later on apply the service pack.

 

Table Of Contents

Create a Windows User Account For SQL Server

Install SQL Server 2008 R2

I.   Setup Support Rules

II.  Setup Role

III. Installation Rules

IV.  Instance Configuration

V.   Disk Space Requirements

VI.  Server Configuration

VII. Database Engine Configuration

VIII. Analysis Services Configuration

IX.  Reporting Services Configuration

X.   Error Reporting

XI.  Installation Configuration Rules

XII. Ready To Install

XIII. Installation Progress

XIV. Complete


Post Installation Tasks

Install SQL SERVER 2008 R2 SP2

Verify The Version And Service Pack Installed


Things To Consider

Changing Server Authentication Mode



Create a Windows User Account For SQL Server

Launch the Windows Server Dashboard and select add user.

In my case I created SQLuser account as my main user for all SQL server services. And I had also set administrator role since this is just a lab installation and I do not wish to switch between accounts to do admin tasks.

During a Setup Support Rules check, a warning on installing on Domain Controller occurred.

It says -

" Rule "Computer domain controller" generating a warning.

Installing SQL Server 2008 R2 on a domain controller is not recommended. "


More details about this warning is found at - http://support.microsoft.com/kb/2032911


Another warning is about the enabled firewall of windows server.

It says - "... make sure the appropriate ports are open to enable remote access."

To enable SQL Server remote access, read the support notes: http://msdn.microsoft.com/en-us/library/cc646023.aspx

1 2 3 4 >Next

You can also check other alternatives in creating a user -

How to add Active Directory user group as login in SQL Server

How to create SQL Server login for a domain account

Microsoft Support: Configure Windows Service Accounts and Permissions



INSTALL SQL SERVER 2008 R2


Run the SQL Server 2008 R2 installer. You will be prompted with a product key to enter.

Select New installation or add features to an existing installation.

I. Setup Support Rules


When installing the SQL Server 2008 R2, it gave an error dialog window about .NET Framework 3.5 needing to be installed as a prerequisite.

It says -

" The following feature couldn’t be installed:

.NET Framework 3.5 (includes .NET 2.0 and 3.0)


Windows Server roles and features cannot be automatically installed or uninstalled via the Windows Features Control Panel.


To install Windows Server roles and features, start Server Manager, or use the Server Manager cmdlets for Windows PowerShell.

For more information, see: Server Manager Help. "


The steps posted by Jason Hamilton - Windows Server 2012 .NET 3.5 install - is helpful to install the required framework.

Once 3.5 .NET install is done, proceed to SQL Server installation.

In my case, since this is just a lab, I just turned off the firewall. DO NOT do this in production!! You should configure advanced firewall setup for all the ports of the services required as mentioned in the support notes above.

To set, go to: Control Panel -> System and Security -> Windows Firewall


Now, click [Re-run] button of Setup Support Rules. You should see the firewall warning as "Passed".

You may ignore for now the warning on domain controller since the concerns are focused only on performance which in our case may not be true since this is not a production instance.

II. Setup Role


Select SQL Server Feature Installation