Installing SQL Server 2005 on Windows Server 2008


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)
Messages
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.

image

image

Fortunately, I was able to find the solution here: http://support.microsoft.com/kb/920201

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

image

Problem solved!

image

 

Comments (10)

  1. CoreyKaye.com says:

    Thanks!!  Windows Authentication… got it.

  2. Exony PS Team says:

    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.

    cheers

  3. Srinvias says:

    Thanks. "Windows Authentication" is the solution…

  4. Arul says:

    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 … adminarul@gmail.com

  5. Dave C says:

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

  6. Uttapan says:

    Thank you so much

  7. bkr says:

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