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

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

Add Handler Mapping to (Default Web Site)

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

...

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

Request Restrictions

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

Add Application

1. Alias = iQSonar
2. Application Pool = iQSonar
3. Physical Path = C:\Program Files (x86)\iQuate\iQSonar\Sonar
4. 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. 1) Open Command Prompt as Administrator
2. 2) cd to .NET Framework directory
3. 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.

...

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

Related articles

...