RSS Reporter for SQL Server

Requirements

RSS Reporter can be installed on any machine that contains:

• IIS version 5.0 or higher
• .NET Framework 2.0

Installation

Before installing RSS Reporter make sure that IIS is running on the machine on which the installation will take place. To start the installation, execute the setup.exe provided with the RSS Reporter self-extract installation package. You will be prompted to select the web site and specify the virtual directory for the application. By default RSS Reporter will be installed on the RssReporter virtual directory on the default web site.

Configuration

Setting Permissions

RSS Reporter saves the user and profile data in the App_Data subfolder located under the main installation folder (usually C:\Inetpub\wwwroot\RSSReporter). ASP.NET worker process account should have write NTFS permission on this subfolder. Depending on the version of IIS and the operating system, assign write permissions on App_Data subfolder to one of the following accounts:

• IIS 5.0 on Windows 2000 Workstation, Windows XP, Windows 2000 Server configured as Member Server of the domain: ASP.NET account (usually computer_name\ASPNET)
• IIS 5.0 on Windows 2000 Server configured as Domain Controller: Account that starts the IIS process (domain_name\IWAM_computer_name)
• IIS 6.0 on Windows 2003 Server configured as Member Server: ASP.NET account (usually computer_name\ASPNET)
• IIS 6.0 on Windows 2003 Server configured as Domain Controller: Network Service account

Selecting ASP.NET version

RSS Reporter requires .NET framework 2.0 to run - by default, it creates a virtual directory under the default website and enforces the use of .NET 2.0.

WARNING!!! Note that when creating a virtual directory in IIS 6, by default the virtual directory will use the same application pool that the parent web site is using. If that application pool was a .NET 1.1 pool, when the RSS Reporter virtual directory is created it will change it to a .NET 2.0 pool and consequently any web sites or virtual directories using that application pool may stop working. To avoid this potential situation, during the installation of the RSS Reporter make sure you choose a web site that is already running on .NET 2.0.

To verify or change the ASP.NET framework version follow these steps:

• Start the IIS Manager console.
• Right-click on RSS Reporter virtual directory (usually Default Web Site\RssReporter) and select Properties
• On the Properties window, click on the ASP.NET tab.
• Select ASP.NET 2.0 as the ASP.NET version.

Enabling Web Service Extensions

If this is the very first web application you are installing on your IIS 6 server it is very likely that the ASP.NET is in the list of prohibited web service extensions - consequently the application will not run. To enable it follow these simple steps:

• Open IIS Manager
• Click on the Web Service Extensions item on the left panel
• On the right hand panel you will see a list of web service extensions installed on your machine - click on the ASP.NET 2.0 item and then click the "Allow" button.

Accessing the application

To access the RSS Reporter, open your browser and go to http://IISMachine/RSSReporter. The "IISMachine" is the machine on which the RSS Reporter has been installed. If you specified a different virtual directory during the installation, use that virtual directory instead of the default one "RssReporter".