V3 Install iQSonar 2.14.x on Windows 2012

Purpose

Complete install 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

Make sure .ASP is installed

Image Removed

...

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

Image Removed
Image Added Image Added

Step 2 - Add Handler Mapping to

...

the Default Web Site

...

Image Added
For For each: css, js, png, xml, rpt, sht
Image Removed

Path = *.<extension> (This is case sensitive)
Executable = %windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll
Name: = <EXTENSION>

Image Removed
Click on Request Restrictions
Uncheck Invoke handler only if request is mapped to:
Confirm Verbs = ALL
Image Removed
...

Image AddedImage Added

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 folder subfolder and select "Convert to Application"

Image Added

Image RemovedImage Added      Image Added
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}

Image Removed

Image Added

Re-

...

Encrypt web.config

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

Image RemovedImage Added

# Change permissions

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

Right Click on the folder and click properties
Image Removed Image Added
Check security tab Image AddedImage Removed
Press Edit
Image Removed Image Added
Press Add Image AddedImage Removed
Make sure the Location has the hostname of the VM and type the group
Image Removed Image Added
Press ok and Make sure you give the group Full control Image AddedImage Removed