I need advice regarding my plans for a Linux/Windows web development project.

My employers have 2 windows servers - one hosts their non-drupal CMS and the other hosts the website database. My job is to transition their website to Drupal - that's the easy part. So, I will be shutting down the server hosting the current website.

The hard part is using two separate servers for the site and the database - something I've never done before.

I plan on using a Linux server for the Drupal development but I need to know how to do the following:

  • use a remote database
  • use SQL Server on a Windows IIS machine

1 Answer 1


Remote database

To use a remote database, you just have to supply the IP/URL of your remote server instead of 'localhost' during install or in sites/default/settings.php file.

SQL Server

There's a module for SQL Server : Drupal 7 driver for SQL Server and SQL Azure.

And installation instructions are available on the module page.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.