Purpose

Complete install iQSonar 2.14.x on Windows 2012

Pre-req:

Installing DotNet 3 on Windows 8 /Server 2012

Make sure .ASP is installed

Adding the Application Pool

Add an iQSonar Pool
Net CLR Version = v2.0.50727
Managed Pipeline mode = Classic
Check the: Start Pool Immediately
Advance settings: Enable 32-bit-applications

Add Handler Mapping to (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>

Request Restrictions

Uncheck Invoke handler only if request is mapped to:
Confirm Verbs = ALL

Add Application

Alias = iQSonar
Application Pool = iQSonar
Physical Path = C:\Program Files (x86)\iQuate\iQSonar\Sonar
Right Click on the API folder and select "Convert to Application"

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-Encryption

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 chaching to be created correctly.

IIS_IUSRS local group can be added.

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

V3 Install iQSonar 2.14.x on Windows 2012