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:
- TeamCity 3.1 Released
- Mapping a domain name to an IP address in the HOSTS file to bypass a DNS resolver.
- Installing NVIDIA drivers on Windows 7
- Installing Linux Ubuntu as a Windows Application with Wubi
- How to retrieve your ISP credentials from a DLink DIR-615 router (or any other router for that matter)
- Microsoft releases .NET 3.5 SP1, SQL Server 2008 RTM and Entity Framework/Data Services
- TweetDeck not showing up in primary monitor
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
ashish:
i can’t find or have an option of windows authentication under security…..any alternative of this if there pls tel me…
October 20, 2008, 1:25 amtk:
Thnx alot! God bless you! =p
November 3, 2008, 2:36 amCharlie Bruno:
Mohit, Vista Home Premium will not allow installation of Report Server because some components of IIS are not available on Vista Home. Thus, you cannot connect to http://localhost/Reports.
Ashish, Check the properties page for the server and look for the property that determines authentication.
December 4, 2008, 4:48 pmJDP:
Thanks lots. Very helpful. Cheers.
March 17, 2009, 3:15 pmSQL Tutorials:
Does anyone know if there is another language or set of commands beside SQL for talking with databases?
I’m working on a project and am doing some research thanks
April 30, 2009, 9:47 pmnataly:
thanks but i ave many problem yet.i turned all of windows features on,but i can not install sql server2005 on my vista yet
June 22, 2009, 8:22 ami think that sql is made only for windows XP & windows 2000( not for vista).
please help me.
thanks.