Problem Installing SQL Server 2005 on Windows Vista with IIS 7.0
I had such a hard time installing SQL Server 2005 on my Windows Vista Enterprise Edition machine running IIS 7.0 this afternoon. In fact, during the setup of SQL Server 2005, I received the following warning message next to the IIS Feature Requirement item on the System Configuration Check page, as shown in the following screenshot.
After Googling for a while, I found out that this situation was already documented by Microsoft as Knowledge Base #920201 in their Help and Support page.
The root cause for this problem is that not all of the IIS 7.0 components essential to SQL Server have been installed. The solution to this problem is (as you may have guessed it) to install those IIS components. To access the IIS configuration page on Vista, you need to go to Start->Control Panel->Programs and Features, then click on “Turn Windows features on or off” on the left pane of the window.
The following table shows you which components (there are 10) to enable with their corresponding folder. The screenshot below the table is a visual representation of the IIS components you should have enabled by ticking the checkbox next to the component.
Following this procedure, you can launch the setup for SQL Server 2005 again, and this time you should see the following results:
If you’re looking for more information on how to install/configure IIS 7.0 on Vista, I highly recommend you to read the following page: http://learn.iis.net/page.aspx/28/installing-iis7-on-vista/. If you’re looking for the same information, but for Windows Server 2008, this link will be more appropriate for you: http://learn.iis.net/page.aspx/29/installing-iis7-on-windows-server-2008/.
Similar posts you might be interested in reading:
- Post #100!
- How to retrieve your ISP credentials from a DLink DIR-615 router (or any other router for that matter)
- Installing Linux Ubuntu as a Windows Application with Wubi
- Part II: Setting Up Our Build Server With TeamCity
- Microsoft releases .NET 3.5 SP1, SQL Server 2008 RTM and Entity Framework/Data Services
- Microsoft’s DreamSpark: free access to .NET development tools for students
- Part I: Beginning the CI Journey with Subversion
Thankful User:
Hi,
Thanks a lot for elaborating this… it was really helpful.. I was breaking my head till i found your page
Thanks again…
June 25, 2008, 7:17 pmBrian Di Croce:
You’re very welcome Thankful User
June 25, 2008, 8:48 pmMohammad Irfan:
Hi,
This is really helpful article; I would like to appreciate your all efforts.
Thank you very much for all your hard work.
Regards,
August 4, 2008, 2:00 pmIrfan
Challenged:
This was a great article - terrific help.
August 29, 2008, 7:08 amThanks
arnel:
Yeah this great article.
August 31, 2008, 9:15 amThanks
Charlie Bruno:
I just received my laptop that runs Vista Home. The above procedure and steps do not work.
September 2, 2008, 8:39 amHowever, on my home desktop pc that runs Vista Small Business(I think that is the version), the above works fine.
hardhitter:
Thanks for your great help boss…….
September 2, 2008, 7:56 pmregards
khan
Mohit:
Hi
September 14, 2008, 6:20 ami have the same problem .
i have vista home premium . i m trying ti install sql server 2005 dev edition.
Showing iis problem .but on iis 7.0 i have checked all componenets but it doesnot have
windows authentication in security tab .
help me out .
thanks in advanced