Install SQL Server 2008 R2 on Server 2012 R2

Reading Time: 6 minutes

How to install and configure Microsoft SQL Server 2008 R2 on Windows Server 2012 R2, including Microsoft SQL Server Studio.

I was recently asked to install SQL server 2008 R2 on a freelance project for a client. Its been a very long time since I have used such an old version of SQL. But the process is still very straight forward and best of all, SQL 2008 R2 is still under support from Microsoft (at the time of writing)

How to install SQL Server 2008 R2 on Windows Server 2012 R2

This is a step-by-step guide to installing SQL Server 2008. You will need:

  • copy of Microsoft Windows Server 2012 Standard R2 (64bit edition) – SQL Server Download
  • copy of Microsoft SQL Server 2008 Standard R2 (64bit edition)
  • a valid license for SQL & Windows

Step 1 – Prepare Windows Server for the installation of SQL 2008

For Windows Server 2012 R2 builds there is a requirement to install .NET framework 3.5. This feature is not installed by default in 2012 R2 Builds as this has been superseded by new versions of .net.

If you do not follow this step you will get an error like:

"error installing microsoft net framework 3.5 sql server"

From Server Manager, select Manage and then Add Roles and Features Wizard.

Select Role-based or feature-based installation.

SQL

On the Select Destination, Server screen choose the local server from the server pool

SQL

Skip to Select features and choose .NET Framework 3.5 Features

SQL

Next, insert the Windows Server 2012 R2 media into the Server.

On the Confirm installation selects select specify an alternative source path

SQL

The source path is usually Z:\Sources\SXS

(whichever Drive letter you have mapped the DVD Drive to).

(For the example below the source DVD was the D:)

SQL

Click OK and Install

SQL

This completes the installation of the .NET 3.5 Framework. The installation will take several minutes, no reboot is required.

Note: If you do not point the source files of .NET 3.5 to the Windows Server 2012 media, the installation will fail, and SQL Server will also fail to install.

Step 2 – Install SQL ServerSQL

Insert SQL Server 2008 R2 Media into the server.

Run Setup from DVD.

Select Installation then select New installation to add features to an existing installation.

SQL, Install SQL Server 2008 R2 on Server 2012 R2

A pre-installation server test will now run.

Click next after the pre-test completes.

Enter product key provided by Customer (or see project manager).

SQL

Accept the Licence terms and conditions.

SQL

Click install to set up support files.

SQL

Click Next and then select SQL Server Feature Installation

SQL

Select ALL instance features (This has been requested in advance by the customer).

Ensure Shared Feature Directories are pointing to the D:\ Drive.

Click next

SQL

On Instance Configuration, leave as the Default instance, click next

SQL

On the Server configuration screen, change the account Name to NT AUTHORITY\SYSTEM. No Password is required. This will be changed by the customer after handover

SQL

Important :

On Database Engine Configuration ensure you select

Mixed Mode (SQL Server authentication and Windows authentication).

Input the pre-defined password (this is for the SA account).

It is also advised to add the local administrator as a SQL Admin in the Specify SQL Server administrators section.

SQL

Under the Data Directories tab ensure you chose:

S:\ for Database files

L:\ for Logs

SQL

On the Analysis Services configuration, add the Current User

(This can be changed by the customer later in SQL Server Management Studio)

SQL

Under Reporting Services Configuration select “install, but do not configure the report server” – (This can be changed by the customer later in SQL Server Management Studio)

SQL

On the next screen, Error Reporting, ensure the tick box is blank and click next

SQL

Click Next to bring up the final screen “Ready to install” and chose INSTALL

SQL
SQL

The installation will take about 15 minutes to complete.

Once completed, open SQL Server Management Studio and log in with the Mixed Mode SA account you created earlier.

SQL

Log in with SA account or Administrator

SQL

Expand the column on left, if you have a green “play” button SQL is running

 

SQL

Upon completion, it is recommended that you update SQL using Windows Update.

If you want to install the latest version of Microsoft SQL Server Management Studio, I have created this handy procedure: Link to SQL server management studio installation.

If you prefer MySQL or MariaDB, check out this guide for all your Linux sysadmin needs.

Can SQL 2008 r2 run on windows server 2012?

You will be glad to know that Microsoft SQL Server 2008 R2 edition will happily run on Windows Server 2012 Standard Edition. It’s important to know that Microsoft officially ended support for SQL 2008 R2 on 19th July 2019. That was quite a while ago, but I can see from the amount of traffic this page gets that it is still a commonly used database system around the world.

Just so you are aware there is a workaround if your business is still heavily reliant on SQL Server 2008 R2. Microsoft will provide free security updates if you migrate your server to Microsoft Azure. Alternatively, you can purchase the updates directly from Microsoft, but be aware it isn’t cheap.

This is what Microsoft has to say on the issue:

Can SQL 2008 r2 run on windows server 2012?

You will be glad to know that Microsoft SQL Server 2008 R2 edition will happily run on Windows Server 2012 Standard Edition. It’s important to know that Microsoft officially ended support for SQL 2008 R2 on 19th July 2019. That was quite a while ago, but I can see from the amount of traffic this page gets that it is still a commonly used database system around the world.

Just so you are aware there is a workaround if your business is still heavily reliant on SQL Server 2008 R2. Microsoft will provide free security updates if you migrate your server to Microsoft Azure. Alternatively, you can purchase the updates directly from Microsoft, but be aware it isn’t cheap.

This is what Microsoft has to say on the issue:

In Azure: Customers running 2008 or 2008 R2 versions of SQL Server and Windows Server in Azure virtual machines will get Extended Security Updates for free.

On-premises: Customers with active Software Assurance or subscription licenses can purchase Extended Security Updates annually for 75 percent of the full license cost of the latest version of SQL Server or Windows Server. Customers pay for only the servers they need to cover, so they can reduce costs each year as they upgrade parts of their environment.

https://azure.microsoft.com/en-us/blog/announcing-new-options-for-sql-server-2008-and-windows-server-2008-end-of-support/

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *