Problem with iis in windows 7 while installing sql server 2005

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.

Answer 1

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

Answer 2

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.

Answer 3

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.

Answer 4

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.

Answer 5

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

Answer 6

I owe you a beer.

Answer 7

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

 

Answer 8

Windows 7 Home Premium does not support Windows Authentication of IIS

Answer 9

Thanks Alberto.

Answer 10

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