Joomla 3.6.4 with MS SQL 2014 sql syntax errors

[twhite8154]

Installed Joomla 3.6.4 on IIS 7 with a MS SQL Server 2014 database. Whenever I attempt to actually do anything from the control panel (create a new user, create an article, create a menu, etc.) I get this error:

[Microsoft][SQL Server Native Client 11.0][SQL Server]No column name was specified for column 1 of 'A'. SQL=SELECT * FROM ( SELECT count(id) , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM #__usergroups) A WHERE A.RowNumber BETWEEN 1 AND 1

I am logged in as the superuser.

[sovainfo]

Suspect it to want count(id) AS count_id, ROW_NUMBER...

When that works you need to find the statement that =>select('count(id)..... and add the alias for the count function.

[twhite8154]

I know what the correct syntax for the SQL statement is. My question is, does Joomla have a fix for it?

[sovainfo]

Both were not clear from your orignal post!

Haven't found anything on github, doubt that there will be something done about it considering the poor support for MSSQL within the Joomla project. Despite the fact this a generic issue, not MSSQL specific. But you never know, everything starts with an issue on issues.joomla.org.