Installing SQL Server 2005 on Windows Server 2008

Installing SQL Server 2005 on Windows Server 2008

  • Comments 9
  • Likes

I am in the process of installing SQL Server 2005 on a new Windows 2008 Server, and ran into the following warning about missing some required components of IIS:

- IIS Feature Requirement (Warning)
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features.  Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.



Fortunately, I was able to find the solution here:

The solution is simply to enable the following role services of IIS 7 (right click on Web Server (IIS) in Server Manager, and choose Add Role Services).  Then add the role services from the following table:

Component Folder
Static Content Common HTTP Features
Default Document Common HTTP Features
HTTP Redirection Common HTTP Features
Directory Browsing Common HTTP Features
ASP.Net Application Development
ISAPI Extension Application Development
ISAPI Filters Application Development
Windows Authentication Security
IIS Metabase Management Tools
IIS 6 WMI Management Tools


Problem solved!



  • PingBack from

  • Just a reference to my me as I have forgotten it too many times ;-)

  • Thanks!!  Windows Authentication... got it.

  • yes it's work great.

    thanks this is what we looking for. it solve our problem in mimutes we tring to figure out since 1 days.


  • Thanks. "Windows Authentication" is the solution...

  • how to install sql server 2008 r2 . it can support already sql server 2005 working system...

    pls reply me to my id if anybody found the same problem ...

  • This was perfect.  Thank you so much for posting this!

  • Thank you so much

  • clear IIS but remaining ASP not clear message.. any advice??

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment