I already know that Windows support is pretty squeaky new, but thought it was time to take advantage of all our production level systems and move some v 6 sites to Windows. I was already succesful running drupal 6 with mysql on windows with all of our modules so I think this is plausible. Now to move to Sql server and V7.
Step one was just to see a vanilla new Drupal 7 site running well on Windows and Sql Server before going through the more painful upgrade of the v6 sites. I can get to the point where it is adding tables to my sql server 2008 R2 database, but then it fails after 15 or tables are added. The website install error is:
SQLSTATE[IMSSP]: An error occurred substituting the named parameters.
OK, that isn't very helpful so I installed Drush and tried to install from there. Got more detailed information. Looks like a bug, but can't be sure as use of savepoints is something we generally avoid in Sql Server land:
C:\ProgramData\Propeople\Drush\commands\sql\sql.drush.inc).
Starting Drupal installation. This takes a few seconds ... [ok]
WD registry: PDOException: SQLSTATE[IMSSP]: An error occurred [error]
substituting the named parameters.: RELEASE SAVEPOINT savepoint_1;
Array
(
)
in _registry_parse_file() (line 179 of
C:\_code\PAi\ExternalWeb\DEV\drupal7\includes\registry.inc).