Drupal 7 Sql Server Preview

Fair warning: this alpha version has not received the amount of tests you'll find in the final versions of Drupal 7. I would advise you to only install on test machines, as this version is not production-ready.

What the installation does

  • Clean-up by dropping any previous installation of Drupal for SQL Server you might have,
  • Create a new database,
  • Copy the Drupal 7 installation files in c:\inetpub\wwwroot\drupal and sets permissions,
  • Launches http://localhost/drupal/install.php in your default browser.

Prerequisites

This package should work on Windows XP SP3 (pro or better, you need IIS), and has been tested against French and English OSes.

You should have already installed the following:

  • IIS
  • FastCGI
  • Sql Server Express
  • PHP 5.3.2 (NTS VC9 version)

You can install those by following the instructions on http://www.microsoft.com/web/drupal

Download

You can download the package at:

http://www.commerceguys.com/files/drupal-7.x-sqlsrv-bundle-alpha1.zip

Damien's picture
Damien Tournoud

Damien is the technology leader at Commerce Guys. He is one of the top architects and contributors to Drupal 7 and the architect behind Drupal Commerce. He also leads the Drupal community in France. Graduated Engineer from L'Ecole des Mines de Paris, Damien started as an IT strategy consultant in 2003 and joined af83 in 2008.

Comments

Thanks for your work on this

Submitted by Justin (not verified) on Sun, 10/10/2010 - 06:53.

Thanks for your work on this but its not working for me. There is no option to install on a mssql database in the install.php installation process. Also the php_pdo_sqlsrv.dll file you refer to in the instructions does not exist anywhere on the internets. What does exist are 2 versions from Microsoft:
1.1
http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&Family...

2.0
http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&Family...

I will test PHP's connectivity with SQLserver now.

Any ideas?

-Justin

Extension=php_pdo_sqlsrv_52_n

Submitted by Justin (not verified) on Sun, 10/10/2010 - 07:33.

Extension=php_pdo_sqlsrv_52_nts_vc6.dll

I got it working! I am running php on a linux machine but want to use MSSQL as the DB so the quest is not 100% over but the correct dll for me to use on IIS was the 2.0 pdo driver: php_pdo_sqlsrv_52_nts_vc6.dll

thanks!

-Justin

Thank you very much for this

Submitted by Chris (not verified) on Thu, 01/20/2011 - 05:57.

Thank you very much for this package.

Are you going to update it with the 7.0 release?

I have tried to install the regular 7.0 release on Windows with IIS 7, pdo sql drivers, wincache, and added the sqlsrv from drupal.org, but this ends in tears with SQL Query errors. I have tried with SQL Server 2005 and 2008. Only your package works flawless. :-) As we might want to use it for a corporate intranet, I'm concerned about the alpha state and would like to start of with the 7.0 release.

Chris

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote>
  • Lines and paragraphs break automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.