Sunday, April 4, 2010

IIS Feature Requirement for SQL Server 2005 Setup on Windows7/Vista

I was always having trouble remembering the IIS Requirements for SQL Server 2005. I am working with Reporting Services, and due to the IIS Requirement failure, I was unable to completely configure my Reporting Service.I was unable to get Report Manager and so could not deploy my reports on local host.

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."

Here is the solution for successful configuration of IIS.
On Windows 7:
Go to Control Panel -> Programs -> Programs and Features -> Turn Windows Features ON or OFF -> Internet Information Services.

ComponentFolder
Static ContentWorld Wide Web Services/Common HTTP Features
Default DocumentWorld Wide Web Services/Common HTTP Features
HTTP RedirectionWorld Wide Web Services/Common HTTP Features
Directory BrowsingWorld Wide Web Services/Common HTTP Features
ASP.NetWorld Wide Web Services/Application Development Features
ISAPI ExtensionWorld Wide Web Services/Application Development Features
ISAPI FiltersWorld Wide Web Services/Application Development Features
Windows AuthenticationWorld Wide Web Services/Security
IIS MetabaseWeb Management Tools/IIS 6 Management Compatibility
IIS 6 WMIWeb Management Tools/IIS 6 Management Compatibility

3 comments:

  1. Inspite turning on the iis feature, it's still showing the same warning message.
    Sir please help!

    ReplyDelete
  2. Any trick installing SQL server on Windows-7 Home basic because IIS is not present !!

    ReplyDelete
  3. Thanks a lot for sharing this with all folks you really recognise what you are talking about! In this complex environment business need to present there company data in meaningful way.Sqiar (http://www.sqiar.com/consultancy/tableau/) which is in UK,provide services like Tableau and Data Warehousing etc .In these services sqiar experts convert company data into meaningful way.

    ReplyDelete