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.
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”.
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