IBM Support

Automate the configuration of Microsoft's Internet Information Service to support IBM Cognos Analytics

News


Abstract

This tool automates the configuration steps based on the IBM Knowledge Center article – Configuring IIS with Cognos Analytics (https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html) and is provided "AS-IS"

Content

NOTE: This batch file uses Microsoft's Internet Information Service's appcmd command line tool to perform the configuration and needs to run with administrator privileges. If there are any concerns on using this command or privilege level, then stop now and follow the manual steps to configure IIS.


The batch file below automates the steps in creating the application pool, alias, SSO, server farm and rewrite rules in IIS needed for Cognos Analytics.   Pre-requisites before running this tool:

• IBM Cognos Analytics (CA) 11.0.4 gateway or higher installed
• Supported version of Microsoft Internet Information Services (IIS) installed with the following features:
- World Wide Web Services > Application Development Features > ISAPI Extentions and Isapi Filters
- World Wide Web Services > Security > Request Filtering and Windows Authentication
• Application Request Routing for IIS installed


Supported IIS versions, for CA, can be found on the IBM Cognos Analytics 11.0.0 supported software Environment page.

Application Request Routing can be found at: https://www.iis.net/downloads/microsoft/application-request-routing

Setting Variables

Before running the tool, you must enter the location of the CA gateway, alias name you want to use, etc.


1. Download the CA_IIS_config.zip file to your Cognos Analytics Gateway Server.
2. Extract the CA_IIS_config.bat file to a folder.
3. Open CA_IIS_config.bat in a text editor.
4. The variables, that are to modified, are located at the top of the file.

Only modify the variables mentioned in the table below.

Variable Name Description Default Setting
set web_site
set web_protocol
This is the pre-existing web site name, where your alias will be created.
This is to notify if the webserver is SSL enabled or not
Default Web Site
http or https
set app_pool Name of the Application Pool that Cognos Analytics will use. ICAPool
set alias

This is the alias name in which Cognos Analytics will be accessed from.

NOTE: Setting an alias name that already exists in IIS will overwrite the existing entries in that alias with the new settings. It is suggested to use a alias name that does not already exists.

ibmcognos
set ca_path Sets the location of the Cognos Analytics gateway folder.

The tool will perform a quick validation to see if Cognos Analytics has been installed in the location specified. It will also check to see if the gateway tier has been installed.

NOTE: The script will still execute even if there is an error.

C:\Program Files\ibm\cognos\analytics
set ca_disp This section is where all application dispatcher(s) in entered.
(Do not list Content Manager only servers).
  • set set disp[1].protocol - where you you set if the webserver is set for SSL.
    ex. set disp[1].protocol=http or https
  • set disp[x].name is where you would put the fully qualified dispatcher name
    ex. set disp[1].name=server1.mycompany.com
  • set disp[x].port is where you would put the dispatcher port number.
    ex. set disp[1].port=9300
For Example:

set disp[1].protocol=http
set disp[1].name=server1_name
set disp[1].port=9300
set disp[1].protocol=http
set disp[2].name=server2_name
set disp[2].port=9400
set disp[1].protocol=http
set disp[3].name=server3_name
set disp[3].port=9500
set enable_SSO

To enable single sign-on capabilities in IIS, set this to True. False to disable.

NOTE: This setting only performs the configuration based on the steps in Configuring IIS with Cognos Analytics. You will still have to perform the steps in the Enable single signon between Active Directory Server and IBM Cognos components section to fully enable SSO.

False
set web_farm_name If there are two or more dispatchers listed in the set ca_disp variable. You can leave the name as is or type in a new one. If only 1 dispatcher is listed, then just leave the name as is as it will not be used. ca_servers

Backing up IIS before running the configuration tool

Before running this tool, you should consider backing up your current IIS configuration. Refer to Microsoft's IIS documentation on how to do this.

Some information on this topic can be found at:

Running the configuration tool

  1. Execute CA_IIS.config.bat by:
  2. - Command prompt with administration privileges
    - Windows explorer with Run as Administrator selected
  3. A command windows will open with the list of variables that you have configured. If they are incorrect then exit and reopen the bat file to correct the issue. If everything is correct, then press 'y' to continue.

Configuration is now complete. To verify, open IIS manager and check under your web site for the alias name you used in the tool.


Enabling SSO after disabling it in the tool

If SSO was disabled while running the tool, you can enable it again in IIS Manager. During the execution of the tool, SSO is configured but is then disabled. To enable it, perform the following:

1. Open IIS Manager.
2. Expand the web site and alias that was created.
3. Single click on the bi folder.
4. Click on URL Rewrite.
5. Find SSO Login, should be greyed out. Single click on it and on the right hand action pane, click on Enable Rule.
6. Find Legacy SSO, should be greyed out. Single click on it and on the right hand action pane, click on Enable Rule.


Script last tested against Cognos Analytics r10


Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos Analytics

Document information

More support for: Cognos Analytics
Administration and Configuration v11x

Software version: 11.0

Operating system(s): Windows

Software edition: All Editions

Reference #: 2000097

Modified date: 30 April 2018


Translate this page: