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
taquil's picture

File_Put_Contents error?

I have an ongoing struggle to migrate Drupal from a Linux box to a Windows box. My current situation is that I have Drupal 7.38 installed and I deleted all the tables from the database. I have just migrated my database over from the live site, without touching the codebase. I don't really expect this to work, but at least I'm getting a different result this time.

When I try to bring up any page, I get something like this:

Read more
taquil's picture

Migrating from Windows

Trying to migrate a Drupal site from a Unix (Ubuntu) server to Windows. New server has Windows Server 2012 R2, IIS 8.5, PHP 5.6.0, Mysql 5.5.42, all recently installed on a newly-created VM.

Read more
David Dubya's picture

Drupal 7.x on IIS 8.5 and SQL Server 2012 R2

Does anyone have experience configuring Drupal 7.x on IIS 8.5? We're moved the site from an older server (IIS 7.x).

Drupal site comes up, we can browse all content, but can't edit or add.

Admin user can open Admin Overlay pages, but cannot save any changes (save button just re-writes the overlay page). Edit content opens edit Overlay page, but has not content.

We're not getting any errors in either php or application logs.

Also, how do you handle the URL re-write, it does not seem to be available in IIS 8.5, we had to remove that "bit" from the site's web.config file.

Samuellai's picture

Poor performance for 10 concurrent users on Win2008+IIS7.5+FastCGI

Hi Experts,

We created a new website using Drupal 7, IIS7.5, PHP5.3, WIN2008, MSSQL2008, and FastCgi, 4 CPUs, 16GB ram, Wincache.

It works fine when only 1 visitor browsing the homepage, it takes around 2-3 second to load it. But when I try to conduct a stress test by simulating 10 concurrent users, the loading time for homepage turned into 5-6 seconds and the CPU usage is almost 100%.

Could you please advise how to improve such situation?

Looking forward to hear from you.

Best regards,
Samuel

erg-web's picture

Migrate SQL Server database to MySQL

Hi,

We have a current Drupal 7 site using SQL Server 2012 but need to export the database and import into MySQL.

SQL server has worked ok but due to the lack of module support we need to change the database to MySQL.

Are there any steps to do this online specifically for a Drupal website?

mgifford's picture

Setting up a Windows Server

We went through the process last year of documenting how to set up Drupal on Windows:
https://github.com/OpenConceptConsulting/drupal-windows-server

There are lots of pieces of documentation, but as a long time LAMP user I couldn't find anything to consolidate it.

This needs some help from Windows System Admins, but should hopefully help some folks take the next step.

Please fork and suggest pull requests to update the documentation.

iBducky's picture

How to Create a Subdirectory of a Larger Domain?

We are currently developing a Drupal community site and want to make it a subdirectory of our corporate website. We are running IIS 7.5/MS SQL Server.

Does anyone have any experience on how to make this work?

vfranklyn's picture

MSSQL or MySQL

Hi there. We're going with Windows 8/IIS/PHP and are wondering which is the better solution: MSSQL or MySQL? We currently have a WAMP box running Drupal 6 and will need to migrate data from the current MySQL db to whatever we decide to use on this new build. Thoughts?

vfranklyn's picture

What's the best setup for a Windows machine using Drupal 7?

Hi there. We're moving from a WAMP machine with Drupal 6 to a Windows machine with Drupal 7. Here's what I'm wondering:

  1. Does Windows 2012 with 64bit work okay with Drupal 7?
  2. What's a better setup, WAMP or IIS? If IIS is the answer, will migrating from a WAMP machine be more difficult?

Thanks for your time.

chrisvanderwall's picture

uc_paypal: cannot find local certificate?

All -

I've never worked on a Windows server before, and am more the site operator/design than server guy, but I'm on my own on this project. I have an SSL certificate installed on the server, but Drupal 7 with Ubercart is logging the following error:

SSL certificate problem: unable to get local issuer certificate

I'm at a loss, and have been working on this and researching for about a week now. Thanks for whatever help you can offer!

Chris

mayur.pimple's picture

External Test server Login

Hi

In many time We follow the process for site deployment.

First we upload in local then test .
after completing test site then we upload in live site.

but test site URL display in google.

Many User visit the test site and register.

I want to stop access for visitor to visit test site.

any module is there to access test login and visit test site.

erg-web's picture

Windows install - Invalid object 'watchdog'

Hi

After installing Drupal on Windows 2008 r2, IIS7 and SQL Server 2012, we get errors whenever accessing any of the log pages e.g. under /admin/reports/dblog

gives this error:

PDOException: SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'watchdog'.: SELECT DISTINCT(type) FROM {watchdog} ORDER BY type; Array ( ) in _dblog_get_message_types() (line 133 of C:\inetpub\wwwroot****\modules\dblog\dblog.module).

and under

/admin/reports/access-denied

gives

Read more
erg-web's picture

Install using existing SQL Server 2012

Hi

Is there a direct download link for Drupal 7 for Windows?

Using web platform installer forces you to install a SQL Express instance which is not needed as we have a SQL Server 2012 database already in place and having both will cause problems.

Web PI wont let you install without a database selection or give you option to use existing SQL Server?

jasonluttrell's picture

Drupal 7 on a Windows production server?

I work in a .Net shop and so, although I am tasked to produce a website for the company in Drupal, I am told that the server has to have a Windows operating system in order to take advantage of in-house knowledge for supporting the server. Windows and Drupal (i.e., PHP and MySQL) are the only given technical criteria; I can dictate what kind of Windows server it will be, and any necessary configurations.

Read more
stongo's picture

Upgrade to Windows Server 2012 Now!

Just wanted to report, that after migrating from a Windows Server 2008 - a WNMP stack that was plagued by problems and instability (most notable php-cgi.exe kept hanging) - to Windows Server 2012, it seems not only has stability improved, but the performance is superior to my local MNMP stack (I can't believe I'm saying this).

Here's the results of running mem.php script from 2bits.com

mac: Before boot     0.22MB Boot time     45.5 ms After Boot     5.02MB Boot Peak 5.06MB Module count     128 After fetch     5.02MB Fetch Peak 5.06MB

Read more
mgifford's picture

Document on building Drupal on Windows 2008

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.

stongo's picture

Boot time

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

Read more
BigChief's picture

Technical Query - Domain Access and Windows IIS7.5

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

jlanaux's picture

Update WAMP and Drupal on Windows server

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

bpopp's picture

drupal 7 slow on windows server 2008, iis 7

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?

Read more
Subscribe with RSS Syndicate content

Drupal on Windows

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds:

Hot content this week