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

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

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.

Click “Add Required Role Services”.

Click Next.

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:

• ASP.NET
• .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

Click Next.

Click Install.

When finished

Click Close.