Purpose

Complete install When installing iQSonar 2.14.x on Windows 2012

Pre-req:

the install will complete but report that 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

View file

name	win2012iis.zip
height	250

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):

ASP.NET
.NET Extensibility
ASP
ASAPI 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

...

Image Added

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
Advance settings: Highlight the IQSonar Application pool and select Advance settings from the menu on the right and set Enable 32-bit-applications

...

to True.

Image Added Image Added

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

...

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

Request Restrictions

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

Image Removed

...

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\SonarRight
Click on OK to complete the application additon.
Exapand the IQSonar folder then right Click on the API folder subfolder and select "Convert to Application"

...
- the application pool should be iQSonar - click on OK.

Image Added

Image AddedImage Added

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>      <connectionStrings>
        <add name        <add name="databaseConnection" connectionString="factory=System.Data.SqlClient;server=SERVER\INSTANCE;database=CMS_DB;uid=USER;pwd=PASSWORD;" />
      <      </connectionStrings>
{code}

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

...

Image Removed

Re-Encryption

...

 </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:

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

Image RemovedImage Added

...

Step 4 - Change permissions

Change permissions C:\Program Files (x86)\iQuate\iQSonar\Sonar to allow chaching to be created correctlySonar to allow cache files 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 RemovedImage Added
Check security tab
Image RemovedImage Added
Press Edit
Image RemovedImage Added
Press Add
Image RemovedImage Added
Make sure the Location has the hostname of the VM and type the group
Image RemovedImage Added
Press ok and Make sure you give the group Full control
Image Removed