locked
Problem with iis in windows 7 while installing sql server 2005 RRS feed

  • Question

  • I tried to install sql server 2005 on windows 7 OS.i enabled IIS and checked all necessary needs but ididn't find windows authentication in iis.

    Reporting services are not installed in windows 7.What is the reason?

    Thanks,
    Ron.
    Sunday, December 13, 2009 2:34 PM

Answers

  • Alberto,

    Thanks for your reply.All the things are enabled.but in windows 7 under security i didn't see the Windows authentication(Secuirty->Windows authentication).i didn't see that one.

    Thanks,
    Ron.
    • Marked as answer by ronsql Friday, April 20, 2012 1:48 PM
    Tuesday, December 15, 2009 1:24 PM

All replies

  • Hello,

    Turn on the following features on Windows 7 using Control Panel -> Programs -> Programs and Features:

    ·         IIS 6 WMI Compatibility

    ·         IIS Metabase and IIS 6 configuration compatibility

    ·         IIS Management Console

    ·         .NET Extensibility

    ·         ASP .NET

    ·         ISAPI Extensions

    ·         ISAPI Filters

    ·         All Common Http Features (except  WebDAV Publishing).

    ·         Security -> Windows Authentication.

    Once you turned on these features, try to install reporting services again.

    Please, install SP3 at the end.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Proposed as answer by Simon Warde Saturday, April 14, 2012 3:25 PM
    Monday, December 14, 2009 6:21 PM
  • Alberto,

    Thanks for your reply.All the things are enabled.but in windows 7 under security i didn't see the Windows authentication(Secuirty->Windows authentication).i didn't see that one.

    Thanks,
    Ron.
    • Marked as answer by ronsql Friday, April 20, 2012 1:48 PM
    Tuesday, December 15, 2009 1:24 PM
  • Hi,

    Reply from Feroz inanother thread in the forum
    ------------------------------------------------------
    The Prerequisites to install SSRS 2005 on IIS 7 are listed in the KB article http://support.microsoft.com/kb/938245. One of the prerequisites involves selecting Windows Authentication. However this feature is not available in IIS 7 of Windows Vista Home Preimum edition as per the document http://technet.microsoft.com/en-us/library/cc753473(WS.10).aspx. So i believe you cannot install SSRS since the perequisites are not meet.

    IIS Feature Requirement (Warning): http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/616244a3-9d7c-454a-9c57-b722f1ab200c

    Hope this helps.
    Chunsong Feng
    Microsoft Online Community Support

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Tuesday, December 22, 2009 6:01 AM
  • Hello,

    I also have a problem installing  SQL server 2005 on my machine.
    I've reinstalled my system few days ago. Now I have Windows 7.
    I've read all the information's about compatibility issues , but I have problem activating iis.
    It has been said that I should turn on features in Control Panel>Programs>Program and Features>Turn Windows features on or off.....but when I try to do that, Windows features window asks me to wait....and after some time nothing appears in side the window?! It's all empty!

    What should I do? Does this means that something went wrong in my OS instalation?

    Thanks much in advance,
    Tina.

    Monday, February 1, 2010 9:48 AM
  • Hi Ron

    Make sure you have installed below components in "Turn Windows features on or off" before installing reporting service:

    -Internet Information Services
    - -Web Management Tools
    - - -IIS 6 Management Compatibility
    - - - -IIS 6 WMI Compatibility
    - - - -IIS Metabase and IIS 6 configuration compatibility
    - -World WIde Web Services
    - - -Application Development Features
    - - - -ASP.NET
    - - - -ISAPI Extensions
    - - - -ISAPI Filters
    - - -Common Http Features
    - - - -Default Document
    - - - -Directory Browsing
    - - - -HTTP Redirection
    - - - -Static Content
    - - -Security
    - - - -Windows Authentication


    Once these are installed you should be able to install SQL Server 2005 with Reporting Services (and all other add ons as well). Make sure you install SQL Server SP2 once the installation is complete.

    Thanks
    Vishal

    Monday, February 1, 2010 11:46 AM
  • I owe you a beer.
    Sunday, November 7, 2010 8:54 PM
  • Alberto

               I am also having the same issue. I too dont see Security-->Windows Authentication.

    I am using Windows 7 Home Premium 32 bit.

    Help me

    Thanks in advance

    Prabhakaran

     

    Tuesday, March 8, 2011 2:19 PM
  • Windows 7 Home Premium does not support Windows Authentication of IIS
    Thursday, March 10, 2011 7:07 AM
  • Thanks Alberto.
    Saturday, April 14, 2012 3:15 PM
  • If you are running Home basic version, its impossible to enable this IIS feature for development, try to install it on higher version like professional or ultimate

    Wednesday, March 19, 2014 7:46 PM