V3 Install iQSonar 2.14.x on Windows 2012

Purpose

When installing iQSonar 2.14.x on Windows 2012 the install will complete but report that the web site was unable to be deployed.

Pre-req:

IQSonar installed. IIS Role installed and configured with features enabled per documentation. The following features must be enabled in IIS (from IQSonar Scan Prerequisites):
·         ASP.NET
·         .NET Extensibility
·         ASP
·         ISAPI Extensions
·         ISAPI Filters
·         Server-Side Includes
·         Default Document
·         Directory Browsing
·         HTTP Errors
·         HTTP Redirection
·         Static Content
·         Request Filtering
·         WindowsAuthentication
Tip – add the IIS Role and .NET runtime before running any Windows updates for easy install.   For issues installing .NET see Installing DotNet 3 on Windows 8 /Server 2012

Step 1 - Create the iQSonar Application Pool

Add an iQSonar Pool with the following settings:

Name = IQSonar
Net CLR Version = v2.0.50727
Managed Pipeline mode = Classic
Check the: Start Pool Immediately and click OK
Highlight the IQSonar Application pool and select Advance settings from the menu on the right and Enable 32-bit-applications

Step 2 - Add Handler Mapping to the Default Web Site

For each: css, js, png, xml, rpt, sht

Path = *.<extension> (This is case sensitive)
Executable = %windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Name: = <EXTENSION>
Click on Request Restrictions
Uncheck Invoke handler only if request is mapped to:
Confirm Verbs = ALL

Step 4 – Add the iQSonar Application to the Default Web Site

Create a new application by right clicking on the Default Website and select 'Add Application'
Alias = iQSonar
Application Pool = iQSonar
Physical Path = C:\Program Files (x86)\iQuate\iQSonar\Sonar
Right Click on the API subfolder and select "Convert to Application"

Edit Web.config to add the database location and credentials
Edit C:\Program Files (x86)\iQuate\iQSonar\Sonar\web.config         Modify  connectionString with details in clear text {code:xml}       <connectionStrings>         <add name="databaseConnection" connectionString="factory=System.Data.SqlClient;server=SERVER\INSTANCE;database=CMS_DB;uid=USER;pwd=PASSWORD;" />       </connectionStrings> {code}

Re-Encrypt web.config

1) Open Command Prompt as Administrator
2) cd to .NET Framework directory
3) aspnet_regiis -pe "connectionStrings" -app "/iQSonar"

# Change permissions

Change permissions C:\Program Files (x86)\iQuate\iQSonar\Sonar to allow caching to be created correctly.
Add the IIS_IUSRS local group to the Sonar Directory.