Marshal Reporting Console 2.5 Release Notes

Release 2.5.4, Last Revision: November 25, 2013

These notes are additional to the Marshal Reporting Console Installation Guide and Help.

The information in this document is current as of the date of publication. To check for any later information, please see Trustwave Knowledge Base article Q13982.

New Features
Supported MailMarshal and WebMarshal Versions
System Requirements
Installation Instructions
Upgrade Instructions
Release History

New Features

For more information about additional minor features and bug fixes, see the release history.

Features New in 2.5.4

Supports installation on Windows 2012 and 2012 R2
Bundled database software updated to SQL Express 2008 R2 with Service Pack 2 as required for use with Windows 2012.

Features New in 2.5

Supports reporting for MailMarshal Exchange 7.X.
Includes the MailMarshal SMTP Executive Summary report previously provided as an add-on.
Supports additional operating systems and SQL server versions; requires updated service packs in some cases.
No longer supports some older versions of MailMarshal SMTP and WebMarshal.

Features New in 2.1

Supports WebMarshal reports as well as MailMarshal SMTP reports.
The currency symbol used in reports is now configurable.
Some SSRS settings can be configured during MRC installation (if SSRS 2005 and MRC are installed on the same server).
Supports installation on Vista and Windows Server 2008 64 bit editions (as a 32 bit application).
Supports SQL Server 2008.
Requires SP2 for SQL Server 2005.

Features New in 2.0.1

Web based interface.
Reports generated through Microsoft SQL Server Reporting Services.
Report scheduling.
Support for email delivery of reports.
Support for FTP upload of reports. FTP and Explicit FTPS connections are supported.
Use one Reports Console installation to report on more than one MailMarshal SMTP database (select a single database when creating a report).

Supported MailMarshal and WebMarshal Versions

Marshal Reporting Console version 2.5 supports reporting on data logged by the following product versions:

MailMarshal SMTP 6.7.2 and above
WebMarshal 6.5.5 and above
MailMarshal Exchange 7.0 and above

(MailMarshal SMTP and WebMarshal support has changed from previous versions)

System Requirements

The following are hardware and software prerequisites for the Marshal Reporting Console installation.

When you install MRC 2.5 with the licensed version of SQL Server and SSRS, both SQL Server and SSRS must be installed on the computer where MRC is installed. MRC 2.5 checks for the presence of SQL Server.
MailMarshal SMTP or WebMarshal databases (the data to be reported on) can reside on any SQL Server that is supported by the MailMarshal or WebMarshal version.
If Reporting Console databases are installed on the same computer as the MailMarshal SMTP or WebMarshal databases to be reported on, the requirements for those databases must also be considered. For information about database sizing, see the User Guide for each product.

Table 1: System Requirements
Category	Requirements
Processor	3GHz
Disk Space	Free disk space to support databases, and additional space for temporary files during installation. 10GB free recommended. If installing standalone, SQL Express requires a minimum of 600 MB of free disk space for installation (in addition to database storage space)
Memory	2GB
Supported Operating System	Windows Server 2012 and Server 2012 R2 Windows Server 2008 SP2, 32 or 64 bit versions, and Server 2008 R2 (installed as a 32 bit application) Windows 7 Windows Vista SP2, 32 or 64 bit versions (installed as a 32 bit application) Windows Server Standard or Enterprise 2003 SP2 or above (32 bit versions, excluding R2) Windows XP Professional with Service Pack 3 or above (32 bit versions) (for upgrade only, deprecated) Note: New installation of MRC will not complete on Windows XP if the SQL Express 2008 R2 software must be installed.
Network Access	TCP/IP protocol Domain structure
Software	SQL Server 2005 with SP3, SQL Server 2005 Express Advanced Edition with SP3 SQL Server 2008 with SP1, SQL Server 2008 Express Advanced Edition with SP1 For installation on Windows Server 2012 and Server 2012 R2, Service Pack 3 is required. SQL Server 2008 R2, SQL Server 2008 R2 Express Advanced Edition For installation on Windows Server 2012 and Server 2012 R2, a minimum of Service Pack 1 is required. Mixed Mode authentication enabled for SQL. Internet Information Services (IIS) 5.1 or above .NET Framework 3.5 SP1 Note: The MailMarshal Reporting Console installer also installs the Microsoft Report Viewer.
Supported Browsers (for client workstations)	Internet Explorer 7 or above Note: The MRC website will not work correctly if Internet Explorer Enhanced Security Configuration is enabled on the computer you are browsing from (Windows Server operating systems). IEESC blocks active content such as the ASP.NET code used by MRC. This behavior is by design. Adding the MRC site to “safe sites” may not resolve all issues created by IEESC. Firefox 3.6 or above. Note: Report Viewer toolbar functionality in Firefox is limited to page navigation and export. Internet Explorer supports additional functions such as zoom and a group tree. For full details see Help.

Installation Instructions

For help with installation, see the Installation Guide available from the Trustwave website.

When you install MRC 2.5 with the licensed version of SQL Server and SSRS, both SQL Server and SSRS must be installed on the computer where MRC is installed. MRC 2.5 checks for the presence of SQL Server.
Problems connecting to the Report Server during installation could be caused by proxy settings. See Trustwave Knowledge Base article Q12205.
For help with the message "The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools," see Trustwave Knowledge Base article Q14064.
When installing prerequisites on Windows XP, be sure that IIS is enabled before you install the .NET framework. If you do not follow this sequence, the SQL Express Advanced or Marshal Reporting Console installation will fail. For more information, see Trustwave Knowledge Base article Q12054.

The following Knowledge Base articles may also be of interest:

Q12088: Setting up automatic logon to Web Based Reports
Q12090: Browser security settings affect Reporting Console function
Q12126: User permissions lost after deleting and re-creating Active Directory group
Q14156: "The setup has detected that no version of Marshal Reporting Console is installed"

Upgrade Instructions

Marshal Reporting Console 2.5 can be used to upgrade Marshal Reporting Console 2.1.0 and above. (To upgrade from MailMarshal Reporting Console 2.0, first upgrade to 2.1)

Upgrade Notes:

MRC 2.5.3 Application Pool change:

If MRC is installed on IIS 7 and above, the installer creates a new IIS application pool "MRC Application Pool" and sets the MRC web application to use this pool. The reason for this change is to ensure correct settings and avoid conflicts with other applications. By default this application pool uses the Network Service identity. If you want to continue to use a different application pool for MRC, you must edit the settings in IIS Manager.
MRC 2.5 supports reporting on MailMarshal SMTP 6.7.2 and above, and WebMarshal 6.5.5 and above. If the installed version is configured to report on MailMarshal SMTP or WebMarshal databases with older versions, upgrade will not proceed.
MRC 2.5 requires .NET Framework 3.5 SP1. Before upgrading, ensure this prerequisite is installed on the server.
Before upgrading, ensure that the operating system and SQL Server are updated to the required service pack level.
The MRC 2.5 upgrade installer requires several GB of free disk space for the installer package and temporary files.
You will be required to re-enter the password of the impersonation account.
Upgrading updates the existing configuration database, and updates stored procedures as necessary in configured MailMarshal SMTP and WebMarshal databases.
All existing database configurations and scheduled reports are retained.

Marshal Reporting Console can also be installed side by side with the earlier MailMarshal Reports and WebMarshal Reports applications.

Release History

The following additional items have been changed or updated in the specific build versions of Marshal Reporting Console listed.

Note: The information in this document is current as of the date of publication. To check for any later information, please see Trustwave Knowledge Base article Q13982.

2.5.4 (November 25, 2013)

MRC-1352

Installation on Windows 2012 and 2012 R2 is supported. The included version of SQL Express is updated to Express 2008 R2 Service Pack 2.

2.5.3.1255 (March 19, 2013)

MRC-1328	New installations of MRC create a dedicated Application Pool in IIS with appropriate settings.
MRC-1336	The WebMarshal Graph of Usage By User Per Day report had incorrect date formatting and display errors in the X axis labels. Fixed.
MRC-1337	The WebMarshal Graph of Usage By User Per Day report could return data out of order. Fixed.
MRC-1338	The rule name selection menu for WebMarshal Blocked Requests by Rule was not populated. Fixed.
MRC-1339	Reports that include rule names in the output could fail for rule names over 100 characters in length. Fixed: names up to 2000 characters are now allowed.
MRC-1340	Visual C++ 2010 libraries installed as prerequisite are updated to SP1.
MRC-1342	The product is rebranded for Trustwave.
MRC-1347	The Configuration Wizard now runs as Administrator to ensure appropriate access.

2.5.2.1214 (November 21, 2011)

MRC-1319	The report Summary by Selected Classification showed incorrect information in detail views (remote email addresses instead of local addresses). Fixed.
MRC-1320	Daily scheduled reports could be generated at the incorrect time due to timezone offset not being applied. Fixed.
MRC-1321	Weekly scheduled reports could be generated at the incorrect time due to timezone offset not being applied. Fixed.

2.5.1.1208 (April 21, 2011)

MRC-1299	On slower systems, the installer could incorrectly report that the website Virtual Directory was not created. Fixed.
MRC-1306	The installer could not use a 32-bit instance of SSRS on a system where a native 64-bit instance of SQL Server was also present. Fixed.

2.5.0.1189 (March 30, 2011)

MRC-989	Quota reports did not provide a heading for the "Active Periods" column. Fixed for new installations only.
MRC-1124	Users could not be selected for WebMarshal Reports due to a missing SQL stored procedure. Fixed.
MRC-1128	Some WebMarshal rule classes were labeled as GUID strings instead of the text names. Fixed.
MRC-1142	Some reports failed on case-sensitive SQL server installations. Fixed.
MRC-1143	The reports "Blocked Requests by Rule" and "Blocked Requests by User" failed when a large scope was selected, due to incorrect data type of an aggregate variable. Fixed.
MRC-1147	The MailMarshal SMTP Executive Summary did not limit the "delivered" category to successful deliveries. Fixed.
MRC-1148	All product database connections now support Windows Authentication.
MRC-1203	The installer now checks for and if necessary enables the IIS Static Content role feature.
MRC-1207	Scheduled reports ran in UTC time rather than server local time for time zones with positive offset. Fixed.
MRC-1227	The Graph of Top 10 Logged Classifications report could be scaled incorrectly. Fixed.
MRC-1234	The Virus Detail by Source report had minor issues with data labeling. Fixed.
MRC-1241	The Virus Summary by Domain report used incorrect time zone handling stored procedures. Fixed.
MRC-1243	The Virus Detail by Source report had minor issues with data labeling. Fixed.

2.1.0.843 (April 28, 2009)

MRC-840	When Marshal Reporting Console is installed on the same server as SQL Server Reporting Services, the configuration wizard allows you to set up required SSRS configuration if necessary.
MRC-846	The currency symbol used in some reports is now configurable.
MRC-852	When connecting to a WebMarshal database you can select SQL or Windows authentication.
MRC-862	The product has been renamed as Marshal Reporting Console.
MRC-869	The "select" list used on some report parameter pages is now implemented as a paged modal popup window to support large lists of items.
MRC-1027	Email addresses set in the "Exception Notifications Recipients" field received an email every time a report was successfully generated. Fixed: Email is only sent to these recipient if there is an error.

2.0.1.438 (August 06, 2008)

Initial Product Release

Legal Notice

All rights reserved. This document is protected by copyright and any distribution, reproduction, copying, or decompilation is strictly prohibited without the prior written consent of Trustwave. No part of this document may be reproduced in any form or by any means without the prior written authorization of Trustwave. While every precaution has been taken in the preparation of this document, Trustwave assumes no responsibility for errors or omissions. This publication and features described herein are subject to change without notice.

While the authors have used their best efforts in preparing this document, they make no representation or warranties with respect to the accuracy or completeness of the contents of this document and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the author nor Trustwave shall be liable for any loss of profit or any commercial damages, including but not limited to direct, indirect, special, incidental, consequential, or other damages.

The most current version of this document may be obtained from Trustwave Knowledge Base article Q13982.

Trademarks

Trustwave and the Trustwave logo are trademarks of Trustwave. Such trademarks shall not be used, copied, or disseminated in any manner without the prior written permission of Trustwave.

About Trustwave®

Trustwave is a leading provider of compliance, Web, application, network and data security solutions delivered through the cloud, managed security services, software and appliances. For organizations faced with today's challenging data security and compliance environment, Trustwave provides a unique approach with comprehensive solutions that include its TrustKeeper® portal and other proprietary security solutions. Trustwave has helped hundreds of thousands of organizations—ranging from Fortune 500 businesses and large financial institutions to small and medium-sized retailers—manage compliance and secure their network infrastructures, data communications and critical information assets. Trustwave is headquartered in Chicago with offices worldwide. For more information, visit https://www.trustwave.com.