The ice_messaging drupal module is used to access the MS SQL database containing the received ICE messages.

Some of the drupal 7 documentation still refers to the old syntax for database queries, even while demonstrating the drupal database abstraction layer. The best and most consistent documentation for building database queries is ​http://drupal.org/node/310075

ice_messaging uses the datatables module to provide fancy presentation. The datatables modules requires manual installation of the DataTables jQuery plugin, and this is very fussy about directory names. Just be careful.

Within drupal, switching to the alternative database is done using:

  db_set_active('YourDatabaseKey');

  // execute queries here

  db_set_active(); // without the paramater means set back to the default for the site

Connecting to a MS SQL Server is supposedly possible from a LAMP machine running drupal, but I don't think it will be easy. See:

​http://davejamesmiller.com/blog/web-development/connecting-php-to-sql-server-on-debian-ubuntu

The sqlsrv project provides a SQL server driver, but it only works on Windows servers. There's a fork of sqlsrv which is supposed to work on linux: ​http://drupal.org/sandbox/rgeorgy/1775970

Possibly an ODBC approach would work...

​https://secure.kitserve.org.uk/content/accessing-microsoft-sql-server-php-ubuntu-using-pdo-odbc-and-freetds