Links to interesting websites:

• SQL Server 2005 Driver for PHP (http://www.microsoft.com/sql/technologies/php/default.mspx)
• SQL Server 2005 Driver for PHP Team Blog (http://blogs.msdn.com/sqlphp/)
  
• PHP on IIS (http://www.iis.net/php)
• PHP Community (http://forums.iis.net/1102.aspx)
• Microsoft SQL Server Native Client (http://msdn2.microsoft.com/en-us/data/aa937733.aspx)
• CodePlex. Open Source Project Community (http://www.codeplex.com/)
  

How to install and configure PHP 5.2.5 to run with Internet Information Services 6.0 on Windows Server 2003 Enterprise Edition SP2

#1. Install the Application Server role onto your Windows Server 2003 Enterprise Edition operating system (Start -> Manage Your Server -> Add or remove a role).

NOTE: During the server role installation process, you may be asked to insert your Windows Server 2003 Enterprise Edition Compact Disk.

#2. Download the latest version of PHP - 5.2.5 (PHP 5.2.5 zip package - php-5.2.5-Win32.zip) from PHP: Downloads website and unzip it somewhere on your hard disk. I generally install PHP 5.2.5 into a folder called PHP5 on C: drive.

NOTE: Do NOT download the Windows Installer (PHP 5.2.5 installer - php-5.2.5-win32-installer.msi)! It does not contain some key files that you will need during configuration IIS6 and PHP!

#3. Configure PHP.

There are a three steps that need to be taken to get PHP working under Windows Server 2003 Enterprise Edition with Internet Information Services 6.0:

• Copy the configuration file php.ini-recommended from C:\PHP5 folder into C:\WINDOWS folder and rename to php.ini ([Win+R] -> cmd /C rename C:\WINDOWS\php.ini-recommended php.ini).
• Open up the C:\WINDOWS\php.ini file in a Notepad text editor ([Win+R] -> notepad C:\WINDOWS\php.ini).
• Search for the line that looks like this... doc_root=  and change this line to... doc_root="C:\Inetpub\wwwroot" .
  

#4. Configure Internet Information Services 6.0.

NOTE: You can run PHP in one of two ways with Internet Information Services 6.0: using ISAPI or CGI extension.

To get started, you need:

• to add the PHP5 ISAPI extension to Internet Information Services 6.0 (IIS 6.0) on Windows Server 2003 Enterprise Edition SP2. Open up the IIS 6.0 manager:
  

Go to Start -> Administrative Tools -> Internet Information Services (IIS) Manager (alternative method: [Win+R] -> inetmgr).
Select Server_name -> Web Service Extension.
From the right pane, click Add a new Web service extension... option.
In the Extension name field enter PHP5 ISAPI.
Click the Add button.
Click the Browse button.
Browse to the C:\PHP5\php5isapi.dll file.
Click the Open and OK button.
Check the Set extension status to Allowed checkbox.
Click the OK button.

• to add new extension (.php) to Internet Information Services 6.0 (IIS 6.0) on Windows Server 2003 Enterprise Edition SP2:

From the left pane, right-click Web Sites and, from the resulting shortcut menu, choose Properties.
On the Properties page, choose the Home Directory tab.
Click the Configuration... button.
Click the Add button.
On the Add/Edit Application Extension Mapping window, next to the Executable field, click the Browse button.
Browse to the C:\PHP5\php5isapi.dll file.
In the Extension field, enter .php.
Click OK button twice.

• to set the permissions for your site so that you can execute scripts:
  

In the Application settings, change the Execute permissions option Scripts only.
Click the OK button.
Click the Select All button.
Click the OK button.

• to add a default PHP page, such as index.php:
  

From the left pane, right-click Web Sites and, from the resulting shortcut menu, choose Properties.
On the Properties page, choose the Documents tab.
Click the Add button.
On the Add content page window, type index.php.
Click the OK button.
Click the Select All button.
Click the OK button.

#5. Test PHP.

In your Internet Information Service 6.0 wwwroot (default C:\Intepub\wwwroot), create a file named test.php. Into this file, paste a three lines of text:

<?php
   phpinfo();
?>

NOTE: phpinfo() - Outputs lots of PHP information. For more information visit: http://pl2.php.net/manual/pl/function.phpinfo.php.

Now, you can open the Internet Explorer browser and visit http://localhost/test.php or http://127.0.0.1/test.php.

I'm glad to join the Polish SQL Server User Group (PLSSUG) because I'm interested in SQL Server platform.

The PLSSUG is a community of Microsoft SQL Server geeks/professionals/users who want to share their experience and knowledge on SQL Server and has been founded by Pawel Potasinski.

Join the Polish SQL Server User Group! Visit our website http://www.plssug.org.pl.

* Paperback: 312 pages.
* Publisher: Helion.
* Language: Polish.

I’m going to Warsaw for Microsoft Security Summit & Developer Days 2007 conference!
Event details:
Microsoft Security Summit & Developer Days 2007
April 25-26, 2007
Warsaw, Poland

Two days full of new technologies from Microsoft:
- Windows Server Code Name "Longhorn",
- Windows Vista,
- Forefront Client Security,
- System Center Operations Manager 2007,
- System Center Essentials 2007 and more…

Home Page: http://www.microsoft.com/poland/technet/seminar/mss2007.mspx.

See you there :-)