Page Comparison

...

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\Sonar
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 ModifiedImage 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}

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

...

• Re-Encrypt web.config

...

  </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_
...
Image Removed  
  
Step 3 - Add Handler Mapping to the iQSonar Web Application
...
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
...
Image Removed
...
" 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"
Image Added  
  
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.
  
...