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.