Drupal on Windows

We certainly don't recommend using Windows as a web server, but some organizations just don't have any other option for a server environment.

In looking for a best practice for implementing Drupal 7 on IIS, we wrote up the following guide:
http://openconcept.ca/installing-drupal-windows-2008

We don't pretend to be Windows Server Admins, but found existing guides inadequate. We would like to have more collaboration around this document, so if you are interested in contributing, please let us know.

Hopefully this is able to help more organizations adopt Drupal 7.

I'm fairly competent at setting up and tuning LAMP stack to run Drupal, but have a client that requires a Drupal site to be on a Windows 2008 Server.
I installed Nginx, PHP 5.3.3 and Mysql and it was dreadfully slow. Running a memory script from http://2bits.com/apache/memory-usage-revisited-when-open-buffet-not-blam...
the initial results were horrifying

Before boot 0.12MB Boot time 2,828.1 ms After Boot 15.52MB Boot Peak 16.25MB Module count 125 After fetch 15.52MB Fetch Peak 16.25MB

I hope someone has tried this before....

I have a working Drupal installation on Windows Server 2008R2, using IIS7.5 and MySQL (and PHP of course!). I am looking at implementing the Domain Access Modules to allow a single user to sign on to more than one domain, on essentially the same site. Different themes, some content and roles between the two domains.

The installations and management of Domain Access is clearly details for Apache and Linux servers - does anyone have any tips on deploying Domain Access for Windows IIS?

Thanks in advance...

Our library website is currently running Drupal 6 on WAMP server 2.0 with php version 5.2.6 and mysql 5.1. We are now ready to replace the old site with one built in Drupal 7. Is it ok to also upgrade to WAMP 2.2? If so, what configuration files would I need to copy to make sure the public can access our site after the update?

Thanks.

Juanita

I have a d7 site up and running on windows server 2008 r2 with iis 7 and it's running extremely slow. I have been reading about the different caching alternatives and am wondering if anyone here has suggestions about which work best for this configuration. I have both authenticated and anonymous users and the entire site is SSL. I am looking at using authcache (http://drupal.org/project/authcache). I have a couple of questions:
1. Is authcache (with memcache as the handler - http://drupal.org/project/memcache) the best way to go for my set up?

Hi All,

We are getting ready to receive new servers for our website. I am currently running Drupal 7 on IIS 7.5 and SQL Server 2008R2. The OS on both servers is Windows 2008R2. Is anyone running Windows and SQLServer 2012? I'd like the newest versions on the incoming servers but not sure if it is compatible or not.

Any insight is appreciated.

terri

I have some questions about this scenario:

1 - If I distribute a development in drupal using MSSQL as Database Server (http://drupal.org/projects/sqlsrv) that is not under GPL licence, the functions and/or procedures stored in that database can be encrypted? Notice that in this case I didn't encrypt the drupal code.
2 - If I use Drupal to interact with data generated and managed from a propietary software (which can't be redistributed), can I via contract or other negate the possibility of a redistribution.

Hello.

We are running Drupal 6 on IIS7 on Windows Server 2008 in Production.
There is some concern that our McAfee Enterprise AV setup is causing problems, though I cannot find hard evidence of this.

Was wondering what others used as their AV setup -- general tips or specific to McAfee.
Right now it does full scans at 3 AM locally (we're not a particularly global site).
This causes near 100% CPU usage during that time, but it's a low traffic period for us.

Our bigger concern is that On-Access scanning causes the site to choke periodically.

For SEO and multilingual site, I want to use Korean or non-alphabetical characters in the url strings.

But I get crash/errors on the url with Korean characters in it.

Other rewrite is working fine-clean url.

Is there a way to configure web.config or something to make this work?
People always tell me to stop using IIS and change to linux, apache...etc.

Thank you for your advice and help!!

I just tried to create a sub-group using the Organic Groups module, and I received the same error that I received several months ago when I replied to an issue report on drupal.org. I found another related issue report referencing a possible fix, but the patch didn't work for me.

Hello:

Somebody know how to get a db_select() "WITH (NOLOCK)", otherwise how do I make a Tablesort with a pager from a db_query()?

Thanks for your answers.

We are preparing to implement Drupal 7 for our content management, and are considering both WAMP and full Windows (I don't know what that is called). Are there as many extra modules if you use the full windows with SQL Server modules? Do you just use the same modules and change them somehow to work with SQL? Any insite is appreciated.

thanks
terri

Thanks for any help. I thought this would be the perfect place to ask my question.

My setup: Drupal 7.15 / IIS 7.5 / PHP5.3 / SQL Server 2008

I started receiving these crazy "Permission denied in drupal_unlink()" errors after an update from 7.13 to 7.14 (and then 7.15). At first, I focused on the permissions for the tmp directory. But after getting some assistance from Drupal's issue queue, I was able to pinpoint the problem as being related to the "sites/default/files" directory.

Hi,

I have Drupal 7 running on Server 2008 R2 with IIS 7.5 and MSSQL 2008.

I am wanting to use drupal to replace a legacy application that runs on an Oracle Database.

I have copied over a specific table from Oracle to another database on the same MSSQL server as Drupal is connected to.

I now want/need to move circa 320,000 articles from that table and create them as nodes within Drupal.

I'm not trying to stir the pot so-to-speak; I'm just trying to figure out why nothing's happening with what many see as an important issue with the SQL Server driver for Drupal 7. This driver is maintained by the Commerce Guys.

There has been a major issue with the update from Drupal 7.12 to 7.14 and 7.15 for several months that was noted on these two reported issues:

http://drupal.org/node/1526404 (created on April 10, 2012 at 5:22pm)
http://drupal.org/node/1561396 (created on May 4, 2012 at 11:11am)
http://drupal.org/node/1567380 (created on May 8, 2012 at 10:05am)

Anybody knows how did I can change the target database via hook_query_alter or other hook launched before the execution of a query?

UPDATE: Make sure that your Drupal settings.php connection string uses the IP address of your MySQL server (e.g. 127.0.0.1 for your local Windows machine), not 'localhost'. This change brought the execution time of a barebones Drupal install down from ~800-900ms to ~60-90ms.

Original post follows -----------------------

Fairly new to Drupal, trying to determine what kind of performance we should expect from a stock Drupal install, with the optional modules (not the barebones option).

I cannot get my server to send emails with PHP. This is true within my Drupal install as well as with a simple PHP mail script. I am new to server management, so any assistance would be greatly appreciated. I am running IIS 7.5 on a Windows Server 2008 R2. The mail function in my PHP.ini is as follows:

Thanks.

Is there a possibility to connect a Drupal 7 site in MSSQL 2005, using SQLSRV?

Can anyone provide a list of high-profile sites that run Drupal on Windows in production? I have not seen a good list, despite searching http://groups.drupal.org/drupal-windows and http://groups.drupal.org/microsoft-servers