Joomla! 3.2.3 on IIS 8.5 with MSSQL 2008R2 Sp1

[skuami]

I could install joomla without any problems. If I try to open den Joomla front-end or back-end I get some SQL errors.

I'm using a windows server 2012 R2 with IIS 8.5.9600.16384 and MSSQL 2008 R2 SP1 (10.50.2500.0). The version of PHP is 5.4.24.

Front-end error:

Code: Select all

Error displaying the error page: Application Instantiation Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'WHERE'.SQL=SELECT * FROM ( SELECT [session_id] , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM [mwi13_session]) _myResults WHERE RowNumber BETWEEN 1 AND 1 WHERE [session_id] = 'e6147t7nk1sttupg3fi5sb8e81'

Back-end error:

Code: Select all

Error displaying the error page: Application Instantiation Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ','.SQL=SELECT * FROM ( DELETE , ROW_NUMBER() OVER (ORDER BY (select 0)) AS RowNumber FROM [mwi13_session] WHERE [time] < '1395067805') _myResults WHERE RowNumber BETWEEN 1 AND 0

Any suggestions?

[akourou]

I have the same issue with

Server 2008 R2 SP1
joomla 3.2.3
php 5.4.26
iis 7.5 and
Sql Server 2008 R2 10.50.4000

any solution?