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.

7 thoughts to “Pre-requisites for installing of SQL Server 2008 on Windows Server 2008 R2”

  1. I would wish that you also had a miniguide for how to install these features in Powershell. 🙂

    otherwise great article.

  2. Thank you. Thank you. Your guide saved me twice. I am not a SQL guy, and I got a 2008 install dumped in my lap. Your guide made it possible for me to confidently and effectively install the server. Then a few days later I had to do a SQL Express 2008 R2 64 bit install. I have done several of these and they are usually click click click done. This one puked and I could not get through the install successfully. I went back to your guide and did all the pre-reqs you outline, re-tried the install again and it worked!

Leave a Reply

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