ModX on Linux + remote Microsoft SQL Server ? love

So I had to make such stack:

Linux (Debian) + Apache + PHP + ModX revolution with remote MS SQL Server

After several hours of googling I found out that this stack has no future for couple of reasons:

  1. Since ModX 2.1 uses Microsoft SQL driver (sqlsrv_* functions) which was released only for Windows platform.
  2. It’s possible to use workaround as FreeTDS, but all functions like “mssql_*” have to be mapped to”sqlsrv_*” functions. Some people tried this trick to run Drupal on Linux with external MSSQL, but it was quite unstable.

Good thing customer agreed to host application on Windows Azure, which offers IIS + MSSQL stack and modx works fine on it.