Install SQL Server 2008 R2 on Server 2012 R2

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

This guide provides a step-by-step procedure for installing SQL Server 2008 R2 on Windows Server 2012 R2, including the Microsoft SQL Server Studio. Despite being an older version, SQL 2008 R2 remains a popular choice and is still supported by Microsoft (as of the time of writing).

Prerequisites:

  1. A copy of Microsoft Windows Server 2012 Standard R2 (64-bit edition).
  2. A copy of Microsoft SQL Server 2008 Standard R2 (64-bit edition).
  3. Valid licences for both SQL and Windows.

Step 1: Preparing Windows Server for SQL 2008 Installation

  1. Install .NET Framework 3.5, as it’s a prerequisite for Windows Server 2012 R2.
    • Open Server Manager > Manage > Add Roles and Features Wizard.
    • Choose Role-based or feature-based installation.
    • Select the local server from the server pool.
    • Navigate to Select Features and choose .NET Framework 3.5 Features.
    • Insert the Windows Server 2012 R2 media.
    • On the Confirm installation, select “specify an alternative source path”.
    • Input the source path, typically Z:\Sources\SXS (adjust based on your DVD Drive letter).
    • Click OK and Install.

Note: Ensure you point to the .NET 3.5 source files on the Windows Server 2012 media to avoid installation failure.

"error installing microsoft net framework 3.5 sql server"

Details:

  • From Server Manager, select Manage and then Add Roles and Features Wizard.
  • Select Role-based or feature-based installation.
How to SQL Server
  • On the Select Destination, Server screen choose the local server from the server pool
How to  SQL Server
  • Skip to Select features and choose .NET Framework 3.5 Features
How to Install SQL Server
  • Next, insert the Windows Server 2012 R2 media into the Server.
  • On the Confirm installation selects select specify an alternative source path
How to Install SQL Server
  • 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:)
How to Install SQL Server
  • Click OK and Install
How to Install SQL Server

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 the SQL Server will also fail to install.

Step 2 – Installing SQL Server

  1. Insert the SQL Server 2008 R2 Media.
  2. Run Setup from the DVD.
  3. Select Installation > New installation or add features to an existing installation.
  4. Follow the on-screen prompts, enter the product key and accept the licence terms.
  5. Choose SQL Server Feature Installation and select all instance features.
  6. Configure directories, instances, servers, and other settings as detailed in your original procedure.
  7. Complete the installation.

Details:

  • 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.
  • A pre-installation server test will now run.
  • Click next after the pre-test completes.
  • Enter product key.
How to Install SQL Server
  • Accept the Licence terms and conditions.
How to Install SQL Server

Click install to set up support files.

How to Install SQL Server
  • Click Next and then select SQL Server Feature Installation
How to Install SQL Server
  • 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
How to Install SQL Server
  • On Instance Configuration, leave as the Default instance, click next
How to Install SQL Server
  • 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
How to Install SQL Server

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.
How to Install SQL Server
  • Under the Data Directories tab ensure you chose:
  • S:\ for Database files
  • L:\ for Logs
How to Install SQL Server
  • On the Analysis Services configuration, add the Current User
  • (This can be changed by the customer later in SQL Server Management Studio)
How to Install SQL Server
  • 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)
How to Install SQL Server
  • On the next screen, Error Reporting, ensure the tick box is blank and click next
How to Install SQL Server
  • Click Next to bring up the final screen “Ready to install” and chose INSTALL
How to Install SQL Server
How to Install SQL Server
  • 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.
How to Install SQL Server

Post-Installation:

Accessing and Updating SQL Server Management Studio (SSMS):

  1. Logging In:
    • Launch SQL Server Management Studio (SSMS).
    • Log in using either the ‘SA’ account or ‘Administrator’ credentials.
  2. Verifying SQL Server Status:
    • Confirm that SQL Server is operational by locating a green “play” icon.
  3. Security Updates:
    • To ensure your SQL Server is secure and up-to-date, apply the latest patches using Windows Update.

Details:

  • Log in with SA account or Administrator
How to Install SQL Server
  • Expand the column on left, if you have a green “play” button SQL is running

 

How to Install SQL Server
  • Upon completion, it is recommended that you update SQL using Windows Update.

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?

Yes, Microsoft SQL Server 2008 R2 can run on Windows Server 2012 Standard Edition. However, it’s crucial to note that Microsoft officially terminated support for SQL 2008 R2 on 19th July 2019. Despite this, the continued high traffic to related pages indicates its widespread use globally.

For businesses that continue to rely heavily on SQL Server 2008 R2, Microsoft offers a solution:

  • Migrate your server to Microsoft Azure to receive free security updates.
  • If migration isn’t an option, you can directly purchase these updates from Microsoft, though it might be a costly affair.

For more details on this topic, refer to Microsoft’s official statements and guidelines.

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/
Elsewhere On TurboGeek:  WinRM for Windows Server Nano: Common Issues & Fixes

Richard.Bailey

Richard Bailey, a seasoned tech enthusiast, combines a passion for innovation with a knack for simplifying complex concepts. With over a decade in the industry, he's pioneered transformative solutions, blending creativity with technical prowess. An avid writer, Richard's articles resonate with readers, offering insightful perspectives that bridge the gap between technology and everyday life. His commitment to excellence and tireless pursuit of knowledge continues to inspire and shape the tech landscape.

You may also like...

Leave a Reply

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

Translate »