Drupal on Windows 2003?

Forgive the newbie questions, but in Drupal-land, I am new as can be. Are there any libraries who are successfully using Drupal, and all the associated components, as their CMS on a Windows 2003 IIS 6 server? Also, Drupal calls for MySQL; is fullblown SQL an option, or does it have to be MySQL?

We're in the beginning stages of totally redesigning our site from the ground up and want to use Drupal, but have concerns about the server we currently have access to. From scanning the blogs and forums, it seems that people have had some hiccups with Drupal on Windows, and we're concerned that we may be painting ourselves into a nasty corner if we choose to use a Windows server.

Any feedback or input is helpful.

Sarah Houghton, Information and Web Services Manager
San Mateo County Library

No IIS/SQL Server support apparent

It appears that in 2003 Drupal there was a MS SQL option for Drupal, but the current INSTALL.txt only mentions MySQL and PostgreSQL.

I have run Drupal on my Windows laptop (WinXP Home), using Apache and MySQL, but I've never tried Windows 2003 and IIS. Of course, this was in 'hacking' mode, not full-blown production mode.

My first option for you

My first option for you would be to setup a Linux server and get away from Windows. If that's not an option run a WAMP setup... windows, apache, mysql and php.
--------------------------
CommunityTraveler

Currently Using Drupal on IIS 5

We have a new server on the way, and we'll be running Apache on it (a WAMP configuration), but at current we're doing a multi-site installation of Drupal on Win2k and IIS 5 with MySQL, clean URLs, and no problems (other than Microsoft's occasional timestamp glitches).

It took a bit of doing. I've posted some about it on Drupal at http://drupal.org/node/27141.

I'd recommend running your site on Apache. I do all my testing and development on Apache, and prefer it. It's much easier to drupal in Apache. We've only been doing IIS because other unrelated services dictated it. I'm excited, though, that that'll be changing...

Drupal works just fine on

Drupal works just fine on Windows 2003 Server. The hardest part is getting PHP to run on IIS 6/2003, which requires a lot of tweaking. I highly recommend Peter Guy's documentation on this at http://www.peterguy.com/php/install_IIS6.html.

I won't touch fullblown SQL, other than to say that it would be s big undertaking to get Drupal to run with MS SQL, particularly if you were to use any database dependent modules. On the plus side, Drupal uses a database abstraction layer, so most of the work would be in writing the database.mssql file. If you did this, you would make the MS SQL folks on the Drupal site happy.

Cary Gordon
The Cherry Hill Company

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.