Handy Software Lab Products Knowlege Base

SQL Server 2005 - Express Edition is a 'Free' product that Microsoft has provided for use within smaller production environments. It primary limitation in a network is the maximum database size which is limited to 4GB per database. Though the maximum database size is likely sufficient for the Content Database and the Messaging Archive (Email and Instant Messaging Journaling), administrators must be vigilant in monitoring the statistical database (IpmStatistics) which is used for accumulating traffic statistics and generating Traffic Reports from the accumulated data. If accumulated statistical data exceeds the 4GB maximum, the HSLAB Print Logger will not function properly and steps will need to be taken by administrators to reset the data retention values for the various database tables and/or purge aged data from the database tables.

Prerequisite Software:

SQL Server 2005 (including the Express Edition product) requires that Microsoft .NetFramework 2.0 be installed prior to the installation of the SQL engine.

If this product is not installed, at the time of the installation of SQL 2005, the installer will prompt you and stop until the product is in place.

SQL Server 2005 - Express Editions Software:

The Express Edition software can be downloaded from the Microsoft product support website:
http://msdn.microsoft.com/vstudio/express/sql/download/

SQL 2005 Express Edition Installation

1. Launch the SQL Server 2005 - Express Edition Setup utility.
2. At the 'End User License Agreement' dialog, review the license terms, check the 'Accept' check-box and click on .
3. At the 'Installing Prerequisites' dialog, click on . The process will install the necessary prerequisite SQL components. When the process is complete, click on to continue.
4. The 'System Configuration Check' dialog will display while a system precheck is performed. The process will stop at the 'Welcome' dialog. Click on to start the actual installation of the SQL product.
5. A second 'Systems Configuration Check' dialog will display a report. Review and correct any issues reported by the check process, then click on .
6. The installer will work through preliminary steps and stop at a 'Registration Information' dialog. MAKE SURE that you uncheck the 'Hide advanced configuration options' check box at the bottom of the dialog. This is IMPORTANT, to make sure that the SQL product is installed properly to work with the Print Logger software.
7. On the same dialog, you can optionally enter a company or enterprise name. The workstation's name should have been placed in the 'Name' field automatically and you can change it if necessary. Click on to continue.
8. On the 'Feature Selection' dialog, expand the 'Database Services' node and make sure that all three 'Database Services' components are selected to install on the local disk. Red 'X's denote items that will NOT install. Click on the associated drop-down list and select either "...installed on local hard drive" option.
9. While still on the 'Feature Selection' dialog, review the 'Client Components' list and make sure that you select AT LEAST the 'Connectivity Components' for installing to the local disk. The 'Software Development Kit' component can be ignored. Red 'X's denote items that will NOT install. Click on the associated 'Connectivity Components' drop-down list and select either "...installed on local hard drive" option.
10. When you have finished the 'Feature Selection' steps, you should have only the 'Software Development Kit' component showing a Red 'X'. Click on to continue.
11. The 'Instance Name' dialog will be presented. YOU MUST CHANGE THE SETTING to 'PRINTLOGGER'. This will assure that the Print Logger software installation process can properly populate the SQL databases. Click on to continue.
12. On the 'Service Account' dialog, make sure the 'Use the built-in System account' radio button is selected and that "Network Service" is the selected account. Click on to continue.
13. On the 'Authentication Mode' dialog, select the 'Windows Authentication Mode' radio button, then click on .
14. On the 'Collation Settings' dialog, the default settings are appropriate. Click on to continue.
15. On the 'User Instances' dialog, 'Enable User Instances' should be checked. Click on to continue.
16. On the 'Error and Usage Report Settings' dialog, leave the check-boxes blank and click on .
17. The 'Ready to Install' dialog should show the 'SQL Server Database Services' and 'Client Components' as ready to be installed. Click on to continue.
18. The 'Setup Progress' dialog will show how the installation is proceeding. When ALL Products show a status of 'Setup finished', click on .
19. The final dialog will inform you that the setup process has completed. No further setup or configuration tasks will need to be performed. Click on to complete the installation of SQL Express Edition.