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.

...

IIS was not found on the system and was not configured even when IIS is installed properly.   This can be resolved by adding the iQSonar Web Application manually as detailed below or by downloading the attached script that will streamline the procedure.

Image Added

Solution 1 - Script file to add the iQSonar Web Aplication:

Download the Win2012iis.rar file and follow the instructions in the readme.txt file - this will automate the steps detailed below via a batch file.

http://iquate.com/downloads/iQSonar/win2012iis.zip

Solution 2 - Manually add the iQSonar Web Application:

Pre-requisites:

IQSonar installed.

IIS Role installed and configured with features enabled per documentation. The following features must be enabled in IIS (from IQSonar Scan Prerequisites): 

...

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

Image Added

Step 1 - Create the iQSonar Application Pool

Add an iQSonar Pool with the following settings:

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

Step 2

...

Image Removed
 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>
4. Click on Request Restrictions
5. Uncheck Invoke handler only if request is mapped to:
6. Confirm Verbs = ALL

 
 
Image RemovedImage Removed
 

...

– Add the iQSonar Application to the Default Web Site

1. Create a new application by right clicking on the Default Website and select 'Add Application'
2. Alias = iQSonar
3. Application Pool = iQSonar
4. Physical Path = C:\Program Files (x86)\iQuate\iQSonar\SonarRight
5. Click on OK to complete the application additon.
6. Exapand the IQSonar folder then right Click on the API subfolder and select "Convert to Application" - the application pool should be iQSonar - click on OK.

Image Modified

Image AddedImage Modified

...

Step 3 : Edit Web.config to add the database location and credentials and the handler mappings

• 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
  

...

Add the following lines near the bottom of the file (between </iquate.dal> and </configuration>)

  </iquate.dal>

    <system.webServer>
        <handlers>
            <add name="SHT" path="*.sht" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="RPT" path="*.rpt" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="XML" path="*.xml" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="PNG" path="*.png" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="JS" path="*.js" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
            <add name="CSS" path="*.css" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll" resourceType="Unspecified" preCondition="classicMode,runtimeVersionv2.0,bitness32" />
        </handlers>
    </system.webServer>
</configuration>

Sample Web.config file (Click to download)

Re-encrypt Web.config:

1. Open Command Prompt as Administrator
2. cd to .NET Framework directory - %windir%\Microsoft.NET\Framework\v2.0.50727\
3. Run aspnet_regiis -pe "connectionStrings" -app "/iQSonar"

Step

...

4 - Change permissions 

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

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

• Page:

V4 installation error message: missing table - t_Artifact missing error

...