JDatabaseQuery classes has a group by function that allows malformed SQL to be included in the GROUP BY statement. This leads to numerous problems with Joomla and MS SQL server, including looking at the included template manager.

The error I'm receiving when navigating to /administrator/index.php?option=com_templates and then clicking on protostar - Default to see the template details:

**Error**
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Column 'jos_menu.alias' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.SQL=SELECT a.id AS value, a.title AS text, a.alias, a.level, a.menutype, a.type, a.template_style_id, a.checked_out FROM jos_menu AS a LEFT JOIN [jos_menu] AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE a.published != -2 GROUP BY a.id, a.title, a.level, a.menutype, a.type, a.template_style_id, a.checked_out, a.lft ORDER BY a.lft ASC

According to this SO article, "In standard SQL (but not MySQL), when you use GROUP BY, you must list all the result columns that are not aggregates in the GROUP BY clause."

The current JDatabaseQuerySqlsrv class does not implement any sort of group function, and this needs to be remedied in order to consider any sort of MS SQL 'supported'.