Module Forena is another alternative to consider. It can be used to query (not update) any MS SQL database. For more details about Forena, 2 types of documentation are available:
The newest 7.x-4.x version also includes an amazing (I think) UI for either creating your reports (the WYSIWYG report editor) and/or for creating your SQL queries (the Query Builder).
Here are some variations of the MS SQL database part in the questions:
- Using a SQLite instead of MySQL database: the Forena samples actually get shipped including a (Tiny) SQLite database. Go check it out in the demo site: the data shown there are data contained in the sampledb, which is in SQLite format.
- Forena comes with a full suite of Supported database connections ... such as MySQL, MS SQL, Oracle, Postgress or any PDO compliant variation.
Enough reasons for considering giving Forena a try? While doing so, use it's issue queue for any type of support/docu requests you may have.
Be aware: I'm a co-maintainer of Forena.