Open Public Distribution on IIS 8.0 and SQL Server 2012 R2 I am having some issues on installing Open Public distribution (openpublic 7.x-1.2) on IIS 8.0 and SQL Server 2012 R2 without Web PI.
Have any one tried it before in such way ? Is it possible ?
I can install "standard" distribution on IIS 8.0 and SQL Server 2012 R2 without Web PI, without any major issue.

This is the issue I am experiencing during installation of Open Public distribution:

An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging information follows. 
Path: http://endri.net/install.php?profile=openpublic&amp;locale=en&amp;id=1&amp;op=do 
StatusText: OK 
ResponseText: Home | Drupal @import url("http://endri.net/modules/system/system.theme.css?0"); .... Home Installation tasksChoose profile(done)Choose language(done)Verify requirements(done)Set up database(done)Install profile(active)Configure siteVerify Apps supportInstall AppsFinished Status message You can now configure the CAPTCHA module for your site. SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Procedure or function dbo.CONCAT has too many arguments specified. 


and

Warning: file_put_contents(temporary:///.htaccess): failed to open stream: "DrupalTemporaryStreamWrapper::stream_open" call failed in file_create_htaccess() (line 494 of C:\inetpub\wwwroot\includes\file.inc).
I have solved, the issue is at this file on this location:

C:\inetpub\wwwroot\profiles\openpublic\modules\contrib\comment_notify\comment_notify.install


the statement on line 24 

$comments_select-&gt;addExpression("MD5(CONCAT(:salt,c.mail,COALESCE(u.mail, u.init), c.uid,c.name,c.nid,c.hostname, c.cid))", 'notify_hash', array(':salt' =&gt; $salt));


should be replaced with

$comments_select-&gt;addExpression("MD5(CONCAT(CONCAT( CONCAT(:salt, c.mail) , CONCAT(COALESCE(u.mail, u.init), c.uid) ),CONCAT( CONCAT(c.name, c.nid) , CONCAT(c.hostname, c.cid) )))", 'notify_hash', array(':salt' =&gt; $salt));


because "Drupal 7 driver for SQL Server and SQL Azure" drops the SQL Server stored procedure CONCAT and creates a new one with only 2 parameters.