2. The Install paths will be populated with the paths to Reporting Server instances installed on the server. Select the instance which needs to be modified.
Following installation steps describes how to install IFS Provided SQL Server Reporting Services Extensions in SQL Server Reporting Services instance. This installation enables
This is an optional installation that should run in Reporting Services instance locally. Currently supported versions of SQL Server are
Note: Before the installation of these extensions, following hot fixes should be installed.
SQL Server 2008 R2
FIX: Forms-based authentication does not work in SQL Server 2008 R2 Reporting Services
IFS provides three SQL Server Reporting Services extensions.
This extension is responsible for authenticating the IFS Application users via the Extended Server. This extension is used together with Authorization extension when the IFS Application is configured to use Database or Simple LDAP authentication.
This extension is responsible for authorizing resource access for Reporting Services users. It is used together with Authentication extension when the IFS Application is configured to use Database or Simple LDAP authentication.
This extension is required to use IFS Applications as a custom data source in Reporting Services. This is supported by the following authentication mechanisms used by IFS Applications.
These extensions can be installed using the IFS BI – MS SQL Server Extensions Installer. The installer can be accessed from
<Build_Home>/Win32Server/SQL
Server Extensions/Install/IFSBISSExtInstaller.exe
Note: The installer will install/configure the required extensions based on the IFS Applications authentication method. It will not allow to select individual extensions. The installer should run by the same user as Logon User of the SQL Server Reporting Services service and it should run on the server machine which has reporting services installed.
1. Open the executable file IFSBISSExtInstaller.exe
2. The Install paths will be populated with the paths to Reporting Server
instances installed on the server. Select the instance which needs to be
modified.
3. Select the Authentication Method of IFS Applications. Based on the selection
some of the install steps will be disabled.
Note: In order to go ahead with the rest of the steps, it is required that the servers (E.g., Extended Server, Reporting Server etc.,) to be up and running. Else the validations will fail and will not proceed further.
a. Oracle Database Authentication
It is required to configure following parameters.
| Configuration Name | Description |
|---|---|
| Extended Server URL | The URL of the IFS Applications - Extended Server access point |
| SSRS Host | The host URL of SQL Server Reporting Services |
| SSRS Report Server | The URL SQL Server Reporting Services Report Server. This will be automatically suggested when SSRS Host is specified. |
| Web Service Descriptor | The URL of SQL Server Reporting Services web service (2010) access point. This will be automatically suggested when SSRS Host is specified. |
| Use SSL to transfer credentials to Report Server from login page | When this check box is selected, Secure Socket Layer (https) will be used while transferring credentials |
| SSRS Administrator | The administrator of SQL Server Reporting Services instance. This user will have all the rights in Report Server, should be a valid IFS Applications User. The value should be equal to the directory id of the Foundation user. |
| Username | Username for fetching DB, Domain User mappings for DB
Authentication. (Should be an IFS Applications user with minimum rights
to access the activity BrowseIfsbiSsrsUserMappings) |
| Password | Password for fetching DB, Domain User mappings for DB Authentication |
Note: Proper mappings should be done in Oracle and Domain User mappings for Reporting Services window.
b. LDAP Authentication
It is required to configure following parameters.
| Configuration Name | Description |
|---|---|
| Extended Server URL | The URL of the IFS Applications - Extended Server access point |
| SSRS Host | The host URL of SQL Server Reporting Services |
| SSRS Report Server | The URL SQL Server Reporting Services Report Server. This will be automatically suggested when SSRS Host is specified. |
| Web Service Descriptor | The URL of SQL Server Reporting Services web service (2010) access point. This will be automatically suggested when SSRS Host is specified. |
| Use SSL to transfer credentials to Report Server from login page | When this check box is selected, Secure Socket Layer (https) will be used while transferring credentials |
| SSRS Administrator | The administrator of SQL Server Reporting Services instance. This user will have all the rights in Report Server, should be a valid IFS Applications User. The value should be equal to the directory id of the Foundation user. |
| LDAP Host | LDAP Directory Server Host |
| LDAP Port | LDAP Directory Server Port |
| Absolute Domain Name | The absolute domain name. E.g. corporate.yourcompany.com |
| Domain DN | Distinguished name (in LDAP query syntax) of the Domain to be
queried. This will be automatically suggested when absolute domain name is filled |
| Username | Username for Querying the LDAP Server |
| Password | Password for Querying the LDAP Server |
c. Windows Integrated Authentication (WIA)
There are no parameters to configure when using Windows Integrated Authentication.
4.Confirmation
After reviewing the installation settings, Select Extension Installer and
click Next. This will start the actual installation/configuration
Note: It is important to make sure the settings are valid before starting the actual configuration/ installations because it is not possible to rollback the modifications automatically, once it is done. You have to either do it manually or by uninstalling the Report Server instance.
5. Installation
During the installation, status messages will be displayed in this window.
6. Completion
Now the installation/ configuration is over. During this step it is possible to
open the installation log.
Note: Restart the SQL Server Reporting Services service after the installation.