Application Instantiation Error: Server 2012 R2/SQL 2008 - Joomla! Forum - community, help and support

hello,

i able install joomla 3.2 on server 2012 r2/iis 8 sql server 2008 r2 sp2 on end. php installed via webmatrix, installs 5.3.5 believe. created database beforehand , granted dbo access sql authenticated user used connection owner in joomla. installer created database tables fine, , completed installer ok, asking me delete installation folder, did. however, when try go root site, get:

error displaying error page: application instantiation error: [microsoft][sql server native client 11.0][sql server]incorrect syntax near ','.sql=select * ( delete , row_number() on (order (select 0)) rownumber [joom_session] [time] < '1399575891') _myresults rownumber between 1 , 0

(there no sessions in dbo.joom_session table)

when try go \administrator, get:

error displaying error page: application instantiation error: [microsoft][sql server native client 11.0][sql server]incorrect syntax near keyword 'where'.sql=select * ( select [session_id] , row_number() on (order (select 0)) rownumber [joom_session]) _myresults rownumber between 1 , 1 [session_id] = 'i5nunlcko4arsktq13s9j5j8g5'

anyone know change these syntax errors, and/or possibly other things might wary change going forward?

thanks!

i'm having same exact issue, has found solution yet?
i'm using iis7 , sql server 2008