Installation of SQL Server 2005 in Windows Vista - warning message on IIS feature requirement during System Configuration Check

During the installation of SQL Server 2005 in Windows Vista, the following warning message may appear during System Configuration Check (IIS feature requirement), indicating that IIS is not configured properly.

 

===== Warning message =====

 

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.

 

===== Solution =====

 

1. Log-on with a user having administrative privileges, or invoke applications explicitly as the built-in Administrator using the command ‘runas /user:administrator cmd.exe’.

 

2. Install IIS 7 on Vista

--> Start

   --> Control Panel

      --> Programs

         --> Programs and Features

            --> Turn Windows features on or off

               --> Enable <Internet Information services>

 

3. Enable various features of IIS

--> Web management tools

   --> IIS 6 Management Compatibility

      --> IIS 6 WMI Compatibility

      --> IIS Metabase and IIS 6 configuration compatibility

--> World Wide Web Services

   --> Application Development Features

      --> ASP.NET

      --> ISAPI Extensions

      --> ISAPI Filters

   --> Common Http Features

      --> Default Document

      --> Directory Browsing

      --> HTTP Redirection

      --> Static Content

   --> Security

      --> Windows Authentication

 

4. Install SQL Server 2005.

 

5. Be reminded to apply SQL Server 2005 service pack 2. 

 

===== For more information ===== 

 

- You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista Beta 2 or a Server Core installation of Windows Server Longhorn　http://support.microsoft.com/kb/920201 

 

- How to install IIS7 in Windows Vista Beta 2

http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957

 

- SQL Server 2005 SP2 is now available　http://msmvps.com/blogs/martinpoon/archive/2007/02/20/sql-server-2005-sp2-is-now-available.aspx

 

- Installing SQL Server 2005 tools on an Windows Vista workstation

http://strobe.uwaterloo.ca/~twiki/bin/view/ISTCSS/SqlServer2005Vista

Published Fri, Dec 8 2006 12:30 by Martin Poon
Filed under: , , , , ,

Comments

# Microsoft » Blog Archives » Martin Poon - Microsoft MVP blog [SQL Server] : Installation of SQL said on 24 April, 2007 04:34 AM

PingBack from http://chaespot.com/mssql/2007/04/24/martin-poon-microsoft-mvp-blog-sql-server-installation-of-sql/

# Alberto said on 07 June, 2007 05:23 PM

You're da man!

# Rajasekhar said on 11 June, 2007 09:24 AM

thanks for help

# Naresh Palan said on 30 June, 2007 08:17 AM

I am attempting to installing SQL 2005 Reporting Services on Vista Home premium.

But when on installation Reporting Services checkbox is disabled not allowing me to select Reporting Services to be installed.

Can you pls. advice solution

# bonehead said on 20 July, 2007 03:22 AM

I still get this message even after I have followed these instructions, can anyone help

# home monitoring security said on 22 July, 2007 12:22 AM

Occasionally, you will become overcome by the colossal quantity of home security system stories at your disposal.

# Thanks said on 09 August, 2007 01:06 PM

Thanks..... these instructions fixed my problem (as descibed in article).

# Microsoft » Blog Archives » SQL Server 7.0 and SQL Server 2000 FAQ’s said on 13 August, 2007 07:03 AM

Pingback from  Microsoft  &raquo; Blog Archives   &raquo; SQL Server 7.0 and SQL Server 2000 FAQ&#8217;s

# jchen said on 27 September, 2007 05:28 PM

I installed sql server 2005 Dev Edition in vista failed.

Can you help?

# SENOUCI said on 25 December, 2007 02:50 AM

I have the same problem, I just can't install Microsoft SQL 2005 on vista Home, I already tried the IIS, SP2 but I am still facing the same error each time

# SENOUCI said on 25 December, 2007 02:50 AM

I have the same problem, I just can't install Microsoft SQL 2005 on vista Home, I already tried the IIS, SP2 but I am still facing the same error each time

# Ade said on 16 November, 2008 01:03 PM

Thanks. At last I found the solution to my problem with the directions above.

# Michael said on 11 June, 2009 08:03 PM

I have the same problem after following all these steps. It won't work for 64-bit machine.

# Abhijt said on 10 July, 2009 08:55 AM

Cant try