Configuring IIS 6 for Eureka Report Server

Products

EUREKA:Reporter

Issue/Introduction

This article will walk through the configuration necessary in Microsoft Internet Information Services version 6 to allow the Eureka Report Server to be able to function. It will detail the steps needed to configure the Web Service Extensions to allow the Reports to be available through the web menu, as well as the steps required to set up WebDAV to allow the Eureka Report Designer clients to submit reports to the server for scheduling.

(Currently Microsoft Internet Information Services version 6 is only installed with Windows 2003.)

Environment

Component: EUREKA:Object-Admin Edition

Resolution

Configuring Web Service Extensions and WebDAV to allow the Designer clients the ability to submit jobs, and to allow reports to be available through the rsipub menu in a browser

All steps will be done in the Internet Information Services Manager tool, it is located under: Control Panel/Administrative Tools. If not found it can be installed from the 2003 Server CD.

In the IISM, Select Local Computer/Web Services Extensions
Click on Add a new Web Service extensions
Type Eureka Reporter for Extensions Name
Click ADD button.
Click browse and path to the bin directory: (C:\Eureka\reporter\server\bin)
Select CGI exe files (*.exe) from the Files of Type drop down menu:
Select the rsipub.exe and click the Open button.
Repeat steps 4-7 for the rsisrv.exe executable
Select Set extensions status to Allowed: Click OK.
Select WebDAV and click Allow button
Select Default Web Site from the Web Sites list.
Right Click on Default Web Site and select the Directory Security tab, click the Authentication and Access Control Edit Authentication methods for this resource button
Verify the user name listed has administrator rights for the local computer. (This can also be set on each of the 3 Virtual Directories independently. Check with your Web Administrator if IIS is being used for more than just the Eureka software)
Right Click Default Web Site and select New/Virtual Directory
Using the Virtual Directory wizard setup smart. The default path for smart is: C:\eureka\reporter\server\bin

The smart Virtual Directory should be set with Scripts and Executable permissions.
Using the Virtual Directory wizard setup rsdocs. The default path for rsdocs is: C:\eureka\reporter\server\rsdocs

The rsdocs Virtual Directory needs to have read and write permissions set.
Right click on the rsdocs virtual directory and select properties. Select the HTTP Headers tab and click the MIME Types button. Click NEW and type: .IQO for EXTENSION. Then type: Viewer Document for MIME Type. Click OK. Repeat this for the file extension .LST with a type of text/plain.
Using the Virtual Directory wizard setup rsmanager. The default path for rsmanager is: C:\Eureka\Reporter\Server\admin. The rsmanager virtual directory needs to have read permissions.

To allow the rsmanager to function through IIS in a remote browser the mime type for .properties files must be set.

Right click on the rsmanager Virtual Directory and choose properties. Pick the HTTP Headers tab and click the MIME Types button.

Choose New, for the Extension enter properties, for the MIME type enter text/plain.
Also add the following MIME Types for this directory
.iqo Viewer Document
.lst text/plain

NOTE: These mime types should be defined in lower case.
Depending on the output type that is being used, other MIME Types may need to be defined.

For export to Personal Datamart
.dbf            application/vnd.ms-excel
.iqd            Viewer Document

For export to TM1 cubes
.tab            Viewer Document
.dim           text/plain
.dit             text/plain
.cma          text/plain
.vis            application/x-zip-compressed
.tmp           text/plain
.cub           Viewer Document