This article applies to:
- Trustwave MailMarshal (SEG)
- Trustwave ECM/MailMarshal Exchange
- WebMarshal
- Marshal Reporting Console
Question:
- What are the common scenarios for installing SQL Server with Marshal Products?
- Do I have to install SQL Server Express if I already have a licensed SQL Server Installation?
- Do I have to install SQL Server Express when I am upgrading the product?
Information:
Most Marshal Products can work with either Express editions or Full licensed versions of SQL Server. SQL Express editions are made available without charge by Microsoft.
- SQL Express has limitations, determined by Microsoft. These limitations are not determined by Trustwave or the Marshal Products.
- The most important limitation is on database size.
- SQL Express 2005 and 2008 limit each database to 4GB
- SQL Express 2008 R2 and above limits each database to 10GB
- For sizing recommendations see the links for each product below.
- Also note that SQL Express does not include the SQL Management Studio user interface. However you can download this from Microsoft.
Each Trustwave Product has specific minimum requirements for the SQL Server version and service packs. To review these requirements, please refer to the documentation for the particular product and version.
Trustwave provides SQL Express in the installation files for the named products.
If you already have a SQL server installation (express or full) with the required version and service pack(s), then it is not necessary to install the SQL Express which comes packaged in the installer.
The following sections provide more information about specific Marshal Products.
Marshal Reporting Console (MRC)
MRC uses SQL Server Reporting Services (SSRS) to generate reports. As part of the MRC installation, you can install the SQL Server Express Advanced edition which comes packaged with the MRC installation files. This is the recommended option. With this option, you must install the MRC configuration database on this SQL Express instance. The product databases (for MailMarshal and WebMarshal) can be hosted on the same instance or another instance.
If you have a full license for SQL Server including SSRS, you can install MRC on the computer where SQL Server and the Report Server instance are installed. (MRC does not support installation where SSRS and SQL Server are installed on separate computers). The product databases (for MailMarshal and WebMarshal) can be hosted on the same instance or another instance.
- Note: The version of SQL Express that is installed with SEG, ECM, and WebMarshal does not include the reporting features, and cannot be used for the MRC database. However, you do have the option of installing MRC with SQL Express Advanced as a new instance on the same computer.
Trustwave MailMarshal (SEG)
SEG/MailMarshal SMTP requires a SQL database. The SQL Server (full or Express) software can be installed on the Array Manager or any other computer that can communicate with the Array Manager. If you previously installed MRC you can use the MRC SQL Express installation to host the MailMarshal database.
- If SQL Server or SQL Express is installed locally but you want to use an instance installed elsewhere, you should use the "custom install" option on the installer.
- For information on database permissions, see Trustwave Knowledgebase articles Q12939 (6.8 and above) or Q11867 (earlier versions)
- For server sizing suggestions, see Q10829.
Trustwave ECM/MailMarshal Exchange
ECM 7.X requires a SQL database. The SQL Server (full or Express) software can be installed on the Array Manager or any other computer that can communicate with the Array Manager. If you previously installed MRC you can use the MRC SQL Express installation to host the MailMarshal database. For information on database permissions, see Trustwave Knowledgebase article Q12939.
MailMarshal Exchange 5.X can be installed without a database. With this version, using a database for logging email usage is optional. You can install and configure the database during or after the installation. For server sizing suggestions, see Q10724.
WebMarshal
WebMarshal 6.X or 7.X can be installed without a database. Using a database for logging web usage is optional. You can install and configure the database during or after the installation. The SQL Server (full or Express) software can be installed on the Array Manager or any other computer that can communicate with the Array Manager. If you previously installed MRC you can use the MRC SQL Express installation to host the WebMarshal database. For server sizing suggestions, see Q10724.
Trustwave SPE/MailMarshal SPE
SQL Express is NOT supported with MailMarshal SPE, due to feature requirements. The SPE installation, and all SEG arrays controlled by SPE, must use full licensed SQL Server installations. Please refer to the SPE documentation.
Upgrading
When upgrading you generally do not need to re-install SQL or SQL Express. Upgrade will detect and use the existing database server settings. You should use the version of the installer without SQL Express (this version is also significantly quicker to download).
- However, be sure to check the prerequisites in release notes to verify that your installed version of SQL (and other prerequisites) are supported by the new version of the Marshal product.
- If the new version of the Marshal product does not support the existing SQL version, you might need to install a new SQL server or SQL Express instance and move the database before upgrading.