May 4, 2009

IIS Feature Requirement Warning Message during SQL Server 2005 Setup on Windows server 2008.

First time I'm installing reporting service + sql on a windows 2008 server and already having some trouble. Here is the fist one.

If you receive a warning message for the IIS Feature Requirement item on the System Configuration Check page during the SQL Server 2005 installation on Windows Vista/Windows Server Longhorn, chances are you did not install all the IIS 7 role services that SQL Server depends on. Here is the list of IIS 7 role services that need to be installed:

  • Static Content
  • Default Document
  • HTTP Redirection
  • Directory Browsing
  • ASP.Net
  • ISAPI Extension
  • ISAPI Filters
  • Windows Authentication (Not available on Windows Vista Basic/Premium)
  • IIS Metabase
  • IIS 6 WMI

To add role services, open Server Manager, click on Go To Manage Role under the Role Summary tab, click on Add Role Serives under the Web Server (IIS) tab.