Category: 2903

Microsoft Web Platform Installer (Web PI) is a free tool that makes getting the latest components of the Microsoft Web Platform easy. This includes the latest Visual Web Developer 2010 Express, ASP.NET 4, and ASP.NET MVC2.

Web PI can also be used to download open source projects which works on PHP and MySQL. Web PI will guide you throughout the process of downloading, installing, and configuring all software that are required. Following are some screen captures, showing how easy it will be to download and install the popular publishing platform [ WordPress ] with just a few clicks!

Firstly, you will need to logon to your Windows operating system using an administrative account. This could be Windows 7, Windows Vista, Windows XP SP2+, Windows Server 2003 SP1+, Windows Server 2008, and Windows Server 2008 R2.

Then, download and execute Web PI that can be found at http://www.Microsoft.com/web/downloads/platform.aspx
Here’s how Web Platform Installer v2.0 looks like.

 

Choose [WordPress], and press [Install]. Web PI will proceed to detect 3rd-party applications that need to be downloaded (PHP, MySQL, WordPress), and the Microsoft products and components that need to be installed and configured (IIS).

As MySQL will need to be installed in order to support WordPress, Web PI will prompt for the root password of MySQL.

Press [Continue], and the installation starts. Web PI will download, install, and configure all of the software for you!

Web PI will then prompt for the site information for setting up an IIS web site.
(You will need to grant appropriate permission for IIS to access the folder as specified in the ‘physical path’.)
(Your should absolutely have a different Web site setting!)

And the next step is MySQL database settings.

 

It’s that easy! Go, and give it a try!

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

~ Microsoft Web Platform Installer 2.0
http://www.microsoft.com/web/downloads/platform.aspx

~ Microsoft Web Platform Installer: The Official Microsoft IIS Site
http://www.iis.net/webpi

~ WordPress
http://wordpress.org

 

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