Freigeben über

Installing SQL Server 2005 on Windows Server 2008

  • Artikel

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: https://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

  • Anonymous
    January 01, 2003
    PingBack from http://lbsa71.net/2008/08/13/installing-microsoft-sql-server-2005-x64-on-microsoft-windows-server-2008-x64/

  • Anonymous
    January 01, 2003
    Just a reference to my me as I have forgotten it too many times ;-) http://blogs.technet.com/seanearp/archive/2008/07/01/installing-sql-server-2005-on-windows-server-2008.aspx

  • Anonymous
    February 01, 2011
    Thanks!!  Windows Authentication... got it.

  • Anonymous
    February 02, 2012
    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

  • Anonymous
    July 22, 2012
    Thanks. "Windows Authentication" is the solution...

  • Anonymous
    February 06, 2013
    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

  • Anonymous
    March 05, 2013
    This was perfect.  Thank you so much for posting this!

  • Anonymous
    June 23, 2014
    Thank you so much

  • Anonymous
    October 01, 2014
    clear IIS but remaining ASP not clear message.. any advice??