Brian On Software

Because there is so much MORE to software development than 1’s and 0’s…

Subscribe in a readerSubscribe in a reader Subscribe via emailSubscribe via email

Blessed be the God and Father of our Lord Jesus Christ! According to his great mercy, he has caused us to be born again to a living hope through the resurrection of Jesus Christ from the dead, to an inheritance that is imperishable, undefiled, and unfading, kept in heaven for you, who by God's power are being guarded through faith for a salvation ready to be revealed in the last time. (1 Peter 1:3-5, NIV)
« The Case for ReSharper in the Enterprise
Ten Principles for a Blessed Day! »
May
13
2008

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.


image

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/.

kick it on DotNetKicks.com

Similar posts you might be interested in reading:

Posted under How To..., SQL Server. RSS 2.0 feed Leave a response, or trackback.
This post has been viewed: 1001 times.
>> Email This Post To A Friend.

2 Responses to “Problem Installing SQL Server 2005 on Windows Vista with IIS 7.0”

  1. Thankful User Says:
    June 25th, 2008 at 7:17 pm

    Hi,

    Thanks a lot for elaborating this… it was really helpful.. I was breaking my head till i found your page :)

    Thanks again…

  2. Brian Di Croce Says:
    June 25th, 2008 at 8:48 pm

    You’re very welcome Thankful User :)

Leave a Reply