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 This is the pre-existing web site name, where your alias will be created. Default Web Site
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 disp[x].name=server_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

When adding more than one server to the listing, increase disp[x] by 1 for every server instance. Always start at 1.

For Example:


set disp[1].name=server1_name
set disp[1].port=9300
set disp[2].name=server2_name
set disp[2].port=9400
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:
https://support.microsoft.com/en-us/help/954872/how-to-create-and-manage-configuration-backups-in-internet-information-services-7.0 https://www.iis.net/learn/get-started/getting-started-with-iis/getting-started-with-appcmdexe


Running the configuration tool

1. Execute CA_IIS.config.bat by:


- Command prompt with administration privileges
- Windows explorer with Run as Administrator selected


2. 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.


Post Script Considerations


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.



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: 02 November 2017


Translate this page: