Pre-requisites for installing of SQL Server 2008 on Windows Server 2008 R2

In order for you to begin installing SQL Server 2008 on Windows Server 2008 R2, you will need to add required Server Roles and Features.

First, add the .NET Framework v3.5.1 that SQL Server 2008 requires. Go to the Server Manager –> Features and select add features.

Select .NET Framework 3.5.1 Features in the Add Features dialog

Put a check in the .NET Framework 3.5.1. Features.”. That will pop up a new dialog that says that it will also install some additional roles and features, such as the Web Server (IIS). That is fine, since you will need them anyway.

Add the Required Role Services

Click “Add Required Role Services”.

.NET Framework 3.5.1 Features selected.

Click Next.

Introduction to Web Server (IIS)

Click Next.

Put a check in the Box Common HTTP Features, which will select :

  • Static Content
  • Default Document
  • Directory Browsing
  • HTTP Errors
  • HTTP Redirection

In the Application Development check the  following:

  • .NET Extensibility
  • ISAPI Extensions
  • ISAPI Filters

In the Security, check these:

  • Basic Authentication (Optional)
  • Windows Authentication
  • Client Certificate Mapping Authentication (Optional)
  • IIS Client Certificate Mapping Authentication (Optional)
  • Request Filtering

In the Performance, check these:

  • Static Content Compression (Optional)
  • Dynamic Content Compression (Optional)

In the Management Tools, check the following:

  • IIS Management Console
  • IIS 6 Management Compatibility (Optional)
  • IIS 6 Metabase Compatibility (Optional)
  • IIS 6 WMI Compatibility
  • IIS 6 Scripting Tools
  • IIS 6 Management Console

Web Server services part 1

Web Server services part 2

Click Next.

Confirm Installation screen

Click Install.

When finished

Installation Results screen

Click Close.

This post is licensed under CC BY 4.0 by the author.