Installing SQL Server 2005 on Windows Server 2008

I am in the process of installing SQL Server 2005 on a new Windows 2008 Server, and ran into the following warning about missing some required components of IIS:

- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

image

image

Fortunately, I was able to find the solution here: https://support.microsoft.com/kb/920201

The solution is simply to enable the following role services of IIS 7 (right click on Web Server (IIS) in Server Manager, and choose Add Role Services).  Then add the role services from the following table:

Component Folder
Static Content Common HTTP Features
Default Document Common HTTP Features
HTTP Redirection Common HTTP Features
Directory Browsing Common HTTP Features
ASP.Net Application Development
ISAPI Extension Application Development
ISAPI Filters Application Development
Windows Authentication Security
IIS Metabase Management Tools
IIS 6 WMI Management Tools

image

Problem solved!

image