DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 920201 - Last Review: June 20, 2014 - Revision: 4.0

Symptoms

Consider the following scenario. You install Microsoft SQL Server 2005 or Microsoft SQL Server 2005 Express Edition with Advanced Services on a computer that is running one of the following operating systems:
  • Windows 7
  • Windows Server 2008 R2
  • Windows Server 2008
  • Windows Vista
In this scenario, you receive the following warning message for the IIS Feature Requirement item on the System Configuration Check page in the SQL Server 2005 Setup program:
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.

Cause

This problem occurs because not all the IIS 7.0 components that SQL Server depends on are installed on the computer. The following table lists the affected components.
Collapse this tableExpand this table
ComponentFolder
Static ContentCommon HTTP Features
Default DocumentCommon HTTP Features
HTTP RedirectionCommon HTTP Features
Directory BrowsingCommon HTTP Features
ASP.NetApplication Development
ISAPI ExtensionApplication Development
ISAPI FiltersApplication Development
Windows AuthenticationSecurity
IIS MetabaseManagement Tools
IIS 6 WMIManagement Tools
Note The Folder column in the table lists the folder under which the component resides. You encounter these folders when you run the IIS 7.0 Setup program.

Workaround

To work around this problem, install the IIS 7.0 components that are not installed on the computer.

Note You cannot install IIS 7.0 by using the Add or Remove Programs item in Control Panel on a computer that is running one of the operating systems that are listed in the "Symptoms" section.

To install IIS 7.0 or the IIS 7.0 components on Windows 7 or on Windows Vista, visit the following IIS Web site:
http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957 (http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957)
To install IIS 7.0 or the IIS 7.0 components in a Server Core installation of Windows Server 2008 R2 or of Windows Server 2008, visit the following IIS Web site:
http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=956 (http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=956)

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Applies to
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
Keywords: 
kbsqlsetup kbsql2005express kbexpertiseadvanced kbtshoot kbprb KB920201
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support