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


mayur.pimple's picture

External Test server Login


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'


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



Read more
erg-web's picture

Install using existing SQL Server 2012


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:

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?



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

Running Drupal on Windows 2012 and SQL Server 2012

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.


ashwin tripathi's picture

Drupal/PHP Developer | worldwide technical services

Employment type: 
Not allowed

Require experienced Drupal developer to work alongside our online production
team, which includes designers, information architects, and content developers. Responsibilities for this position include custom programming and web
application development, troubleshooting of existing client sites, contributing ideas and efforts
toward internal projects and working as part of a team to find solutions to various problems (i.e.
development platforms, documentation etc.). The ideal candidate should enjoy working in a
creative, challenging, and fast-paced team environment.

Read more
daneelcm's picture

How work's Drupal developments using SQLSrv driver?

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.

Read more
drupac_shakur's picture

Anti Virus setup


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.

Read more
HappyJiyoung's picture

clean url problem with Korean/Chinese Characters (Unicodes)

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

jayhawkfan75's picture

SQLSrv Driver + Organic Subgroup Creation = Rollback to Savepoint error

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.

Read more
daneelcm's picture

db_select - WITH (NOLOCK)


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.

terri8502's picture

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

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.


jayhawkfan75's picture

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

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.

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