Wednesday, October 7, 2009

IIS Feature Requirements (Warning) Windows 7 and Vista

I had installed SQL Server 2005 on Windows 7 and applied SP3. Everything was working fine till today when i decided to install Reporting Services (SSRS). I installed IIS from Control Panel -> Programs and Features -> Turn Windows Features On or Off. Then i ran SQL Server steup and got to the point of System Configuration Checker. It gave me the IIS Feature Requirements (Warning) and when i tried to continue i saw Reporting Services Cehckbox disabled. Upon searching through the internet i found a very useful link which was the only one that fixed my problem. Thanks to Martin Poon Microsoft MVP whose blog helped me. The link to his blog is:
http://msmvps.com/blogs/martinpoon/default.aspx

and the link to his article is:
http://msmvps.com/blogs/martinpoon/archive/2006/12/08/installation-of-sql-server-2005-in-windows-vista-warning-message-on-iis-feature-requirement-during-system-configuration-check.aspx

I am rewriting this article for my own reference and for others who need help in this scenario and becauase the background and text color of Martin's blog for this article made it very difficult to read so i had to select all the text and then read it properly.

When you run the SQL Server install the system configuration checker displays the following message:
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.

Steps to Resolve the Issue:

Applies to Windows 7 and Vista:
  1. Start
    1. Control Panel
    2. Programs and Features
    3. Turn Windows features on or off
    4. Enable
  2. Enable various features of IIS
    1. Web management tools
    2. IIS 6 Management Compatibility
      1. IIS 6 WMI Compatibility
        1. IIS Metabase and IIS 6 configuration compatibility
      2. World Wide Web Services
        1. Application Development Features
          1. ASP.NET
          2. ISAPI Extensions
          3. ISAPI Filters
        2. Common Http Features
          1. Default Document
          2. Directory Browsing
          3. HTTP Redirection
          4. Static Content
        3. Security
          1. Windows Authentication
  3. Now run the SQL Server 2005 Setup again

Hope this would be helpful.

53 comments:

  1. Hi,

    I'm still having a problem to install reporting services eventho I've already follow ur steps.

    then how?

    ReplyDelete
  2. Hi sorry for the delayed response. Can you please let me know what OS version you are using. I mean xp, vista home premium or ultimate etc.
    There is an issue with Vista home premium as it is client OS and lacks the Server features that is required by SQL Server Reporting Services. You can verify this and check that "windows authentication" is not present under security settings in IIS components selection.

    ReplyDelete
  3. When you run the SQL Server install the system configuration checker displays the following message:
    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.

    i have tried the above solution...but it doesnt work.what can i do to solve this problem.iam using windows 7.

    ReplyDelete
  4. Hi,
    I just saw your comment and did a test installation on Windows 7 Ultimate (Evaluation Build 7100). I followed the exact same steps I mentioned on my blog above and evertying went well. Let me tell you
    1. If you are using 7 Professional or Ultimate the above steps would work without any issue.
    2. If you have windows 7 home you won't be able to install SQL Server 2005 with reporting services selected.
    3. If you still want to install SQL2005 on Windows 7 or vista home premium then DO NOT Select Reporting Services during installation.

    Last thing I would like to tell you that the Reporting Services require Server components which are only available in Professional or Ultimate Editions of Windows 7 and Vista even in XP Professional.

    ReplyDelete
  5. Hi

    The given solution worked like a charm on Win7 Professional. I already played with the IIS from CP but was failing to find the right setting. Anyways thanks.

    ReplyDelete
  6. Can you detail why this will not work on Win 7 Home Premium?

    Thanks

    ReplyDelete
  7. I have windows 7 professional x64. I installed SQL Server 2005 x64 but SP3 will not apply to Reporting Services. I have uninstalled SQL 3 times, gone through the registry to make sure there were no lingering entries from past installations, but (at this point I downloaded the 64 bit SP to run manually) when I run the update it comes to a screen where you can choose which components to apply SP3 to, and SSRS is not checked and cannot be checked. I'm at my wit's end with this. I can't believe installing software from Microsoft, on "the best Windows yet", has to be so flippin' frustrating and a PITA. Also after installing VS2005 and VS2008, VS2005 would not launch due to an "application folder could not be created for Visual studio" error.
    I had to start a cmd prompt as admin and run this: "%programfiles%\Microsoft Visual Studio 8\Common7\IDE\devenv.exe" /setup

    ReplyDelete
  8. Hi friend, for the first comment, I would like to tell you that Windows 7 Home premium is a client operating system to be used for home entertainment. It lacks the Server features required by IIS and SQL Reporting Services Components hence you won't be able to run SSRS on this OS Edition.

    ReplyDelete
  9. Dear Friend as for Windows 7 X64, I haven't tried it on 64bit architecture. I was travelling to Africa so apologize for the delayed response. I will try to test it on X64 and will let you know my findings.

    Best Regards

    ReplyDelete
  10. Hi,

    I just followed the step by step procedure that you advice. But still the Reporting Services is still inactive during my installation of MSSQL2005 server.

    I'm using windows7 Professional. I hope you can help me on this matter. Thanks

    Best Regards.

    ReplyDelete
  11. Did you verify your IIS installation after following the steps? check if IIS is running properly. http://localhost
    If you can't see the IIS default webpage then it means you haven't set it up yet. Repeat the steps above and try SQL install again.

    ReplyDelete
  12. Works like charm with windows seven ultimate x86 and sql server 2005 dev edition.

    Thank you.

    ReplyDelete
  13. I use windows 7 professional, and I got this warning when installing SQL Server 2005 Developer Editon. Your post is very helpful. Thank you very much!

    ReplyDelete
  14. Hi, I use Windows 7 Home Premium, and I got this warning message when installing SQL Server 2005 Enterprise Edition. I followed all the steps. But I can't to be. anybody have idea about this.

    ReplyDelete
  15. I need to add all of the IIS 6.0 components before it would work. I am running x64 Windows 7

    ReplyDelete
  16. Hi,I use Windows 7 Ultimate 32 bit operating system.I have followed the given steps above to install IIS.But still i'm getting the same warning during the installation of MS SQL 2005.The Warning is as follows:
    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.
    Could you help me in solving the warning? Waiting for you response...

    ReplyDelete
  17. I have verified the IIS after the installation by giving: http://localhost in my browser.IIS is running properly. And i can see the IIS default webpage.But still i get the same IIS warning during the installation of SQL.

    ReplyDelete
  18. Hi guys, I just did a test installation after reading your comments. Nithya you are right even IIS is running fine and you follow the above steps SQL installation still gives the IIS warning. What you need to do is select ASP and ASP.Net both for this to work.
    Blacky i am uploading the screen shot of exact configuration inside the article for both of you to be able to see the exact selections required.

    ReplyDelete
  19. Thanks for nice information, i has tried and it's working properly, i use Windows 7 Enterprise Edition 64 Bit and use SQL Server 2005 Developer Edition. and sorry for bad english ^_^

    ReplyDelete
  20. Hi,Thank you soo much for your help.I have followed the steps given by you.And the screen shot which you attached is helped me to solve the Warning exactly.And it is working now.Thanks a lot.

    ReplyDelete
  21. Steps rock - thanks a bunch!

    ReplyDelete
  22. Thanks everyone a lot, you give me the way out of my terrible problems...

    ReplyDelete
  23. I have Win 7 Home premium I am trying to install Sql Sever 2005 it's giving IIS warning, Please help me what to to? I have already put on all IIS service from control panel and IIS Default screen is displaying with url: http://localhost.

    Please helop me .Thanks in advance.

    ReplyDelete
  24. I have heard about another way of check if pdf is damaged. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.

    ReplyDelete
  25. Many thanks to author! This SQL drove me to distraction! You saved my nerve cells!!!!!!

    ReplyDelete
  26. Hi I am using vista home premium i dont have an option "windows authentication " under secuirty so how can solve this problem.

    ReplyDelete
  27. Will this fix work on Win Server 2008 32bit OS?

    ReplyDelete
  28. Thanks very much it really worked 4 me.

    ReplyDelete
  29. i am trying to install sql server 2005 with sp3 on windows 07.

    i gives me error with some services..
    unable to start services

    smething in relation with online servers,etc

    ReplyDelete
  30. i have a have windows 07 hope premium...
    unable to install sql server 2005

    any way in which i could install sql server 2005

    ReplyDelete
  31. i knw that its not compatible with windows 07 hp

    any sugestions

    ReplyDelete
  32. Didn't try it with Win2008 though it should work.

    Sylvan can you please let me know what error message you are getting when trying to install sql server 2005? You should be able to install sql2k5 on windows 7 home premium however the reporting services will not work.
    Let me know as much details as you can so that I can help you with your installation.

    Problems with services is mostly with user accounts and permissions, I would recommend to add a normal user account (without admin privilege) before installing sql server 2005. And during installation select this account, provide password and then select all services to run with this user account. This should resolve any problems with "unable to start service" issue.

    ReplyDelete
  33. This is a nice article..
    Its very easy to understand ..
    And this article is using to learn something about it..

    c#, dot.net, php tutorial

    Thanks a lot..!

    ReplyDelete
  34. Work like a charm,thanks.

    One little side note, if you are not asked to reboot after you update IIS then you are not doing something right.

    ReplyDelete
  35. I am trying to install sql server 2005 developer edition and I am using Windows 7 home permium..while installing it is giving warning for "IIS Feature Requirement" and when I move forward it says "setup can not find the required files. Check your connection to the network or CD-ROM drive"

    Any idea why this might be happening..I have verified that IIS is installed correctly by checkign http://localhost

    ReplyDelete
  36. i have window 7 ultimate 32 bit....i had perfomed all da steps but facing the same problem plz help
    i have acer aspire 5410(intel celeron)

    ReplyDelete
  37. Hi
    i am using windows 7..already i enable the iis.but while installing sql server 2005 i am getting a warning as iis is disable..

    ReplyDelete
  38. Adeel, Great post, One thing to update change this part:
    2) IIS 6 Management Compatibility
    1) IIS 6 WMI Compatibility
    1)IIS Metabase and IIS 6 configuration compatibility
    to be:
    2) IIS 6 Management Compatibility
    a) IIS 6 WMI Compatibility
    b) IIS Metabase and IIS 6 configuration compatibility
    I missed this until I compared the MVP page and yours and spotted this minor difference! I made this setting change and now it's installing fine on Win7 Enterprise 32 bit.

    thanks for the good post!

    ReplyDelete
  39. I am using windows 7 64 bit professional. I am trying to install sql server 2005 32 bit standard edition and the option reporting services is greyed out. I have checked all the options for IIS that you have mentioned in this article. can you help me in this please.

    ReplyDelete
  40. Hi, I am having the exact same problem as Anonymous on September 22nd. Has anyone found what causes this issue? Thanks, Mike.

    ReplyDelete
  41. Hi, I am using windows 7 ultimate (32 bits) n any time i try to install sql server 2005 there is always an error of IIS but when i do http://localhost i am able to see IIS 7.0 but still the error persist
    and i would also like to tell that when i go into my windows turn on/off programs then there is no child node under IIS Management Console
    pls help me out
    m really screwed up
    pls reply on ma emial id ganesh_deshwini@yahoo.com

    ReplyDelete
  42. thanks for solving ma problem(IIS Feature requirement) sir...:)
    happyy...:)

    ReplyDelete
  43. I had the same problem with Reporting services greyed out. Installing IIS the first time did not do the trick so I uninstalled it again. Did some searching and found your article on the net and followed it too the T. Wonderful, it worked for me. Just for completeness I am running Windows 7 Enterprise

    Thank you

    ReplyDelete
  44. Great ! I am happy .. IIS installed :)

    ReplyDelete
  45. recently i'm using windows 8. As i already installed iis 7.5, there is no change in message. IS Same problem are shown. Is IIS version not compatible???So there's any solution for this.

    ReplyDelete
  46. before installing install latest .net framework and then enable IIS features it will work.

    ReplyDelete
  47. hey how i can make cannot with iis and sql server 2005?

    ReplyDelete
  48. Thanks for help me. It works great for me...

    ReplyDelete
  49. IIS is either not installed or not configured for a server component installation error in windows 7

    While installing Sqlserver 2000 reporting service in windows 7 giving the above error. IIS has been succesffully installed but i am facing the error.

    ReplyDelete

There was an error in this gadget