Recently I tried to install SQL Server 2005 on Windows Vista and I have received a warning message for IIS Feature requirement on the System Configuration Check page of the SQL Server 2005 Setup program. This means that you won’t be able to install SQL Server components, requiring IIS, such as Reporting Services. The problems occurs because IIS 7.0 is much more customizable and has much more components, so some of the components required for RS installation are missing from the default IIS 7.0 install. Here is the list of the IIS components required for Reporting Services:
|
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 |
For instructions on how to install missing IIS components in Windows Vista, go to: http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957 (http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957).
For instructions on how to install missing IIS components in a Server Core installation of Windows Server 2008, go to: http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=956
The solution is also explained in Microsoft KB920201.