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