The eTrust SCM Quarantine Manager and Reporter can use either MS-SQL or Microsoft SQL Server 2005 Express Edition as the database layer.
According to your needs, you can install a dedicated SQL 2005 Express Server on a remote machine, or install SQL Express 2005 on the same machine as the Quarantine Manager and/or Reporter.
Please read further about MS SQL Express 2005 server at:
http://msdn.microsoft.com/vstudio/express/sql/default.aspx
eTrust SCM r8 Prerequisites
Perform the following installations and checks before installing eTrust SCM:
- Install Microsoft SQL Express 2005 edition according to the product’s documentation. Please read further detail in this document.
Important! Microsoft SQL Express Server must be installed before you install eTrust SCM.
- Confirm that SQL Express 2005 edition and Windows authentication is enabled in the SQL Express 2005 SQL Server Management Studio Express. To confirm this setting, do the following:
- SQL Server Management Studio Express.
- Right click on the Database root and choose the “properties” option.
- Select the “Security” page at the left pane of the “server properties dialog”, as illustrated in the screenshot at the next page.
- Confirm that at the “Server Authentication” option the “SQL Server and Windows Authentication radio button is selected (see screenshot).

- Create both the Quarantine and Reports Databases at the SQL level as detailed further down this document.
Install eTrust SCM after you have confirmed that the above prerequisites have been met.
Microsoft SQL Server 2005 Express Edition System Requirements
Please read the MS SQL 2005 Express Edition pre installation requirements carefully at:
http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/RequirementsSQLEXP2005.htm
Uninstall beta versions
Before you install any members of the SQL Server 2005 Express Edition family, you must uninstall any beta or CTP versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0.
The following is a summery of the installation prerequisites and we recommend reading the complete requirements from the above line since installation instruction may be modified by Microsoft from time to time.
- Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows XP Service Pack 2.
- Computer with Intel or compatible Pentium III 600 MHz or faster processor (1 GHz or faster is recommended).
- Minimum of 192 MB of RAM (512 MB or more is recommended).
- 525 MB of available hard disk space.
You must have administrative rights on the computer to install SQL Server Express.
Step 1: Download and install Windows Installer 3.0.
Note: If you are running Windows Server 2003 Service Pack 1 (SP1) or Windows XP SP2, you already have Windows Installer 3.0.
Step 2: For 32-bit platforms, download and install the 32-bit version of Microsoft .NET Framework 2.0.
Microsoft Internet Explorer 6.0 Service Pack 1 (SP1) or later (prerequisite for .NET Framework).
Step 3: Download Microsoft SQL Server 2005 Express Edition http://msdn.microsoft.com/vstudio/express/sql/default.aspx.
Direct link:
http://go.microsoft.com/fwlink/?LinkId=65212
Step 4: Follow the installation instructions provided in the Readme.
http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm
Creating the Quarantine and Reports Databases
Download and install the SQL Server Management Studio Express (separate download below), so you will be able to manage your SQL Server Express.
Download SQL Server Management Studio Express:
http://msdn.microsoft.com/vstudio/express/sql/default.aspx
Direct link:
http://go.microsoft.com/fwlink/?LinkId=65110
To create the quarantine and reports databases, follow these steps:
Create the Quarantine Database
Perform the following steps to create the Quarantine database:
- Open the “SQL Server Management Studio Express”.
- Connect to the Database Server you have created during the SQL installation. Browse to the Database level.
- Choose Database. The default database appears in the right pane:

- Right-click the right pane and select New Database. The “New Database” dialog appears:

- Enter a name for the container on the General tab, for example: eSCM_Quarantine_DB.

- Within this dialog you may adjust the Data Files properties for the Database, adjust the default parameters, if this is a heavily-used database we recommend to use an initial size of more then 2MB to decrease DB fragmentation.
For Example an initial size of 100MB will be fine.
The defaults parameters are fine for testing purposes.
Adjust the parameters for the DB log file as well.