Drupal on Windows

Working group discussing best practices for Drupal development and deployment on Microsoft Windows.

Since there are so many combinations of web server and database server be sure to clarify in your posts whether you are talking about IIS, Apache, SQL Server, or MySQL.

Topics of interest are:

Microsoft Internet Information Server (IIS)
Microsoft Windows
Microsoft SQL Server
WAMP tools (WampServer, XAMPP, etc)
Development environments (Visual Studio, Komodo, Eclipse, NetBeans, etc)
PHP
Integration with enterprise servers

Document on building Drupal on Windows 2008

Posted by mgifford on November 5, 2013 at 4:14pm

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.

Boot time

Posted by stongo on July 11, 2013 at 6:27pm

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

Technical Query - Domain Access and Windows IIS7.5

Posted by BigChief on June 14, 2013 at 8:08am

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...

Update WAMP and Drupal on Windows server

Posted by jlanaux on June 10, 2013 at 5:17pm

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

drupal 7 slow on windows server 2008, iis 7

Posted by bpopp on May 29, 2013 at 7:22am

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?

Running Drupal on Windows 2012 and SQL Server 2012

Posted by terri8502 on May 13, 2013 at 3:33pm

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

How work's Drupal developments using SQLSrv driver?

Posted by daneelcm on February 22, 2013 at 10:21pm

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.

Anti Virus setup

Posted by drupac_shakur on February 19, 2013 at 7:09pm

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.

clean url problem with Korean/Chinese Characters (Unicodes)

Posted by HappyJiyoung on January 29, 2013 at 8:18am

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!!

SQLSrv Driver + Organic Subgroup Creation = Rollback to Savepoint error

Posted by katannshaw on November 30, 2012 at 9:52pm

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.

db_select - WITH (NOLOCK)

Posted by daneelcm on November 7, 2012 at 11:13pm

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.

How do Modules work with Windows? Are there as many?

Posted by terri8502 on September 12, 2012 at 12:16pm

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

How to Set Up "sites/default/files" Permissions Properly on Windows

Posted by katannshaw on September 4, 2012 at 9:34pm

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.

Import legacy MSSQL data to Drupal on MSSQL

Posted by Al_McK on August 29, 2012 at 4:26pm

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.

Why is Drupal 7 driver for SQL Server issue being ignored?

Posted by katannshaw on August 21, 2012 at 4:33pm

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)

hook_query_alter???

Posted by daneelcm on July 18, 2012 at 4:27pm

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

Baseline Drupal performance expectations

Posted by rogerrogers on July 12, 2012 at 1:55pm

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).

Mail Not Sending from Windows Server 2008

Posted by TyrelDenison on July 5, 2012 at 4:27pm

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:

[mail function]
; For Win32 only.
; http://php.net/smtp
SMTP = localhost
; http://php.net/smtp-port
smtp_port = 25

Thanks.

MSSQL 2005???

Posted by daneelcm on July 2, 2012 at 6:35pm

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

High-profile sites running Drupal on Windows

Posted by jtherkel on June 27, 2012 at 3:10pm

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

Subscribe with RSS