Shortcuts

When I try to install Drupal using Web Platform Installer 3.0 I get I get the following message: "Problems installing Microsoft SQL Driver v2.0 for PHP v5.3 in IIS Express This product did not install successfully.

I followed the directions that came with the drivers and added the appropriate extenstions in php.ini. The directions were for IIS 7. Are there different installtion requirements and/or drivers for IIS7.5 express, or how do I get rid of this installation
error?

I installed the drivers as directed SQLServerDriverForPHP.chm. I did not use the %_pdo_% drivers as the PHP site indicated as %_pdo_% may no longer be supporded. The configuration wizard from PHP On Windows Training Kit says they are installed. PHPInfo.php
says they not installed. I have seen functions that need to be run to install the drivers, but I can't find them. PHP search claims they are not a PHP functions.

Sorry if I missed it above - have you tried install the SQL driver for PHP in WebPI? I also didn't see any reference to an install failure ... if you are having issue installing it outside of WebPI, it might be worth trying the install using WebPI

Hi Chris, It turns out the drivers were properly installed for PHP 5.2, just not enabled. For PHP 5.3 which I had on my desktop they had to be in the format [PHP_PDO_SQLSRV] extension=php_pdo_sqlsrv_53_nts_vc9.dll [PHP_SQLSRV] extension=php_sqlsrv_53_nts_vc9.dll.
Which I discovered by trial and error.

Hi Martin, I thought I read IIS 7.5 Express was stand alone and FastCGI installed. I had not installed II7 and did not realize the IIS 7 services in "Turn windows features on and off" panel still had to have a check mark in CGI. By the way the configuration
wizard on my laptop claimed fastcgi was enabled, but PHP wouldn't run because it wasn't. Fortunately, while rooting though "inetmanager" to fix the FastCGI problem I discovered the sql drivers were installed, but not enabled. So I guess the Configuration Wizard
was right. They were installed. After I enabled the drivers, they showed up PHPInfo.php. (PHP 5.2 from Microsoft site) The windows live installer would not/cound not seem to see MySQL I had on the machine. I had to uninstall MySQL so the installer could install
and older version.Then I could load and run Drupal. On my desktop, which runs Windows 7 x64. The configuration wizard claims FastCgi is not enabled. Inetmgr says it is enabled. PHPInfo.php runs so I guess it is. Http://learn.iis.net/page.aspx/246/using-fastcgi-to-host-php-applications-on-iis-7/
from the configuration wizard references several add-ons, which web installer, say are not compatible. The configuration wizard also has a "fix" link in this area. It brings up a command prompt full of red ink. It doesn't stay around long enough to read. With
PHP 5.3 (from Microsoft site) the format is [PHP_PDO_SQLSRV] extension=php_pdo_sqlsrv_53_nts_vc9.dll [PHP_SQLSRV] extension=php_sqlsrv_53_nts_vc9.dll. These drivers don't need to be enabled. Why doesn't the chm file that comes with the drivers cover this,
or mention the drivers need to be enabled? Now I have only one problem left and is is common to both machines. I have Microsoft SQL server 8000r2, and Microsoft SQL server 8000r2 Express on both machines and both are all loaded with adventure works. Yet I
get the following message from configuration wizard: Msg 911, Level 16, State 1, Server DAGON7\SQLEXPRESS, Line 1 Could not locate entry in sysdatabases for database 'AdventureWorks2008R2'. No entry found with that name. Make sure that the name is entered
correctly. Something I found rather stupid is the response from the windows live installer when trying to install Drupal. "The install fails because Microsoft SQL Driver v2.0 for PHP v5.3 in IIS Express. This product did not install successfully." The install
of the v2.0 drivers is a manual operation. Besides PHPInfo.php says the drivers are installed. Using windows matrix I didn’t have this problem. The goal for all this was to establish a local development server on both my desktop and laptop. As such I do not
or want remote facing servers. I think the only reason MySQL was not recognized by Windows Matrix or Windows live is they are not set up for remote service. So why can't I have local databases without having to uninstall MySQL and let the installer, install
a older version. I did get Drupal up and running on the laptop without much more trouble. How effort would I have if I wanted "dotNukem"? With my desktop running Windows X64 I had a new set of problems. Windows Matrix doesn't set up the user name/password
properly when it installs Drupal. In fact it screws up the settings file to the point where Drupal would not run. It was something about the Windows Matrix forgetting to tell Drupal there was a database out there. One of the blogs I looked at said that you
may have to reset IIS. To do that click on start and type in iisreset. Maybe that works for you guys running Windows 8000. For those of us running Vista desktop you have to right click on a terminal window and open it as an administrator, then type in iisreset.
One last item. If the document folder is where I am supposed to put all my documents, how come it is now getting populated with source code? Where do I put my documents to keep them unpolluted? Here ends the rant. Charles