...
Purpose
When installing iQSonar 2.14.x on Windows 2012 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.
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 | ||||
|---|---|---|---|---|
|
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
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 set Enable 32-bit-applications
to True.
Step 2 – 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
- Click on OK to complete the application additon.
- 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.
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}
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:
- Open Command Prompt as Administrator
- cd to .NET Framework directory - %windir%\Microsoft.NET\Framework\v2.0.50727\
- Run aspnet_regiis -pe "connectionStrings" -app "/iQSonar"
Step 4 - Change permissions
Change permissions C:\Program Files (x86)\iQuate\iQSonar\Sonar to allow cache files to be created correctly.
Add the IIS_IUSRS local group to the Sonar Directory.
- 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
iQuate support has automated the above process and created a package that will allow you complete above steps in an automated fashion.
Purpose
=======
During the install iQSonar may not recognize that IIS is installed and will not configure the web based front end automatically.
This script will perform the following actions:
- setup the iQSonar Application Pool in IIS
- Add the iQSonar Web Application to IIS
- set permissions on the Sonar folder to allow IIS to manage the cache files in the web application
- set the File Handler mappings for IIS in the web.config file
- setup the connection to the iQSonar CMS Database in the web.config file
- encrypt the web.config file to obfuscate the credentials needed to access the iQSonar CMS Database.
A KB Article is also available detailing how to perform these steps manually.
Instructions
============
Extract the web.txt file and the fixiis.bat file into C:\Program Files(x86)\iQuate
NOTE: If your iQSonar installation is not in the default c:\Program Files(x86) modify the fixiis.bat file to reflect the proper drive and folder structure.
Edit Web.txt to add the location of your iQSonar CMS Database as configured during installation.
Modify the following line with details in clear text with the information for your environment:
<connectionStrings>
<add name="databaseConnection" connectionString="factory=System.Data.SqlClient;server=SERVER\INSTANCE;database=CMS_DB;uid=USER;pwd=PASSWORD;" />
</connectionStrings>
Run fixiis.bat - you will be prompted to update the permissions, IIS and to encrypt the file. Answer yes on each step to properly create the iQSonar web application.
After the file has run you can now open the iQSonar web application in Internet Explorer by going to http:\\localhost\iQSonar from the iQSonar server.
...
...
Related articles
- Page:
V4 installation error message: missing table - t_Artifact missing error
...