By albertc on

Hi everybody

I have a site that is running on the usual Linux/Apache/MySQL/PHP platform, but the actual users now want it to run on their current Windows-based (IIS/MSSQL) system. Is such a setup supported and/or are there any patches available? What are the requirements?

Thanks in advance and kind regards
--
Albert

⋅ Categories: Drupal 4.6.x

Comments

platypus media’s picture

platypus media commented

MS SQL is not supported by Drupal. I don't think using IIS is too much of a problem, as long as you have MySQL installed properly. One issue that you might run into later, is that of support. Most of us, I feel safe in assuming, use some flavor of Apache as the web server. Occasionally, you're going to run into errors that are Apache errors, and not Drupal. You're probably going to run into similar issues with IIS. Problem is, is that not many of us use IIS with Drupal, and won't be able to be of any help.

Mike
http://www.ixlr8.org

gabriella’s picture

gabriella commented

Take a look at the System requirements > http://drupal.org/node/270

I dont think that there is any support for MSSQL at all. But there are people using IIS I think..

heine’s picture

heine commented

Some people are working on MSSQL & Drupal. Two relatively recent threads:

http://drupal.org/node/43415
http://drupal.org/node/46950

Alas, I've no idea what the status of their work is.
--
Tips for posting to the forums.
When your problem is solved, please post a follow-up to the thread you started.

nevets’s picture

nevets commented

I have a box running Windows XP and use it for developing Drupal sites. But there are things I have never managed to get working on the windows box (and never worrry about since the final host has always been Linux based). These include clean URLS and images (I can not seem to get the GD library installed correctly)

sepeck’s picture

sepeck commented

GD is a pain, you need to make sure you have the php_gd2.dll in the extensions folder and it uncommented in the php.ini. It works fine for me.

Clean URL's are a little more problematic. Steven gave a hint on the existing code but I haven't had time to go try and make it work.

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide -|- Black Mountain

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

screener’s picture

screener commented

worked a charm, thx

JHeffner’s picture

JHeffner commented

I got it working under IIS on windows. I have everything working, but I would not suggest MSSQL. I still use MySQL.

For clean urls you will want to use isapirewrite. I would suggest using fastcgi as opposed to the sapi module from php.net. There are still problems with the sapi module that I don't think will ever be completely fixed.

somemathguy’s picture

somemathguy commented

Can you explain how you set this up? I just moved an existing drupal site to a new web host running only IIS servers...everything else seems to be working fine except for clean URL's. Because most of the links in the content have been hard-coded by users assuming clean URL's, none of them work anymore.

JHeffner’s picture

JHeffner commented

This might help you with isapi rewrite. Also I would recomend running php under fastcgi if possible.

[ISAPI_Rewrite]

RFStyle New

# http://www.isapirewrite.com/
RepeatLimit 32
# Block external access to the httpd.ini and httpd.parse.errors files
RewriteRule /httpd(?:\.ini|\.parse\.errors).* / [F,I,O]
# Block external access to the Helper ISAPI Extension
RewriteRule .*\.isrwhlp / [F,I,O]

# Rewrite protolive to fully qualified url
RewriteCond Host: www
RewriteRule (.*) http\://your.fqdn.for.com$1 [I,R]
# Accept a url with a period and pass it through unchanged.
#RewriteRule (.*\..*) $1 [I,L]
# Accept a url with the following extension and pass it through unchanged.
RewriteRule (.*\.htc) $1 [I,L]
RewriteRule (.*\.ico) $1 [I,L]
RewriteRule (.*\.css) $1 [I,L]
RewriteRule (.*\.js) $1 [I,L]

RewriteRule (/themes/.*) $0 [I,L]
RewriteRule (/misc/.*) $0 [I,L]
RewriteRule (/modules/.*) $0 [I,L]

# Accept a url with /cron.php and pass it through unchanged.
RewriteRule (/cron.php) $0 [I,L]
RewriteRule (/update.php.*) $0 [I,L]
RewriteRule (/xmlrpc.php.*) $0 [I,L]
RewriteRule /index.php.* $0 [I,L]
RewriteRule /(.*)\?(.*) /index.php\?q=$1&$2 [I,L]
RewriteRule /(.*) /index.php\?q=$1 [I,L]

You should also configure your mime types and *.module, etc to return 404 errors within IIS.