Surf Control v5.5 manual SQL Server minimum requirements on Web Filter server

Page 27

2

INSTALLATION DECISIONS

Database Considerations

3Type the following: sqlcmd -S.\sqlexpress

4You should get a prompt like this: 1>

5Type: Exit to exit sqlcmd

6Open the SQL Computer Manager.

7Expand Server Network Configuration.

8Expand Protocols for SQLEXPRESS.

9Enable Np (for local and remote access).

10Enable TCP (for local and remote access).

11Restart SQL Server Express.

To access SQL Server Express database tables, you can use the Windows OSQL utility from the command prompt. For more details about the OSQL utility, visit www.microsoft.com.

For more information about SQL Server Express, visit: http://www.microsoft.com/sql/editions/express/ default.mspx

SQL Server

If you have SQL Server on your network, you should plan to create the database on that server (you can create and configure the database during the installation process). SurfControl recommends installing SQL Server on a dedicated server. If you plan to use a SQL Server database, but have not installed Microsoft SQL Server, complete the following tasks before installing Web Filter:

1Install SQL Server on the designated server; this can be the same machine as the Web Filter server.

2Make sure your server has the minimum resources listed in the table below.

Table 2-4 SQL Server minimum requirements on Web Filter server

# Users	Server Specification
<500	Intel Pentium IV, 2 GB RAM, 1.2 GHz processor, 10 GB hard drive.

500 - 1000	Intel Pentium IV, 3 GB RAM, 1.4 GHz processor, 20 GB hard drive.

1000 - 5000	Intel Pentium IV, 5 GB RAM, 1.4 GHz processor, 40 GB hard drive.

>5000	Intel Pentium IV, 7 GB RAM, 1.8 GHz processor, 60 GB hard drive.

3Configure SQL Server to limit memory and processors when running both Web Filter and SQL Server on the same computer.

•There should only be one database owner (db_owner) per database.

•If you need to have multiple user accounts with database access, the other users should only have db_datareader and db_datawriter permissions.

Caution: Install SQL Server with the default setting of case insensitivity, including case insensitivity for Dictionary Order. Choosing case sensitivity may cause problems when installing Web Filter.

22 Starter Guide

SurfControl Web Filter for ISA v5.5

Image 27

Contents SurfControl Web Filter Trademarks SurfControl Web Filter Table of Contents Appendix Chapter Microsoft ISA Server Edition ISA ServerHOW WEB Filter and ISA Server Interact Hardware Requirements System RequirementsGeneral System Requirements SQL Server Licensing System Requirements Installation Decisions Database Options User Name ResolutionIntroduction Network ConsiderationsNetwork Considerations Deployment RecommendationsDMZ Recommendations Network Considerations Web Filter communication ports Firewall Port ConfigurationISA Server Authentication ISA ServerISA Server 2004/2006 EUM User Name ResolutionEUM on Windows NT domain controllers Methods of Installing EUMEUM Agent on Domain Controllers EUM on Windows 2000 and 2003 domain controllersBefore installation Netwareeum Ignoring Users in NetWare EUMLogging Levels Login Agent Location EUM Login AgentInstalling the Login Agent on NT Domains Installing the Login Agent on Windows 2000Below is a copy of the supplied .ini file EumLogin.ini fileEumLogin.ini file sections How to configure the fileAdd an Exception to the Windows Firewall Configuring a logon and logoff scriptDatabase Considerations Database PlatformsSQL Server Express SQL Server minimum requirements on Web Filter server SQL ServerSQL Authentication Database AuthenticationReasons to Install SQL Server on a Dedicated Server Windows AuthenticationInternet Threat Database Improvement Program Other ConsiderationsInternet Threat Database Categorization OptionsMail Notifications Remote Administration ClientPrivacy Edition Considerations Remote Administration Client minimum requirementsInstalling Web Filter NetWare client on to the Web Filter server Installation ProcessInstalling SQL Server Express Optional Select I accept the terms of the license agreement Installing Surfcontrol WEB FilterInstalling SurfControl Web Filter Select SurfControl Web Filter Installing SurfControl Web Filter Installing SurfControl Web Filter Changes to the Server Configuring WEB Filter Configuring Web Filter Configuring Web Filter Configuring Web Filter Configuring Web Filter Configuring Web Filter Internet Threat Database Update screen is displayed Automatic Database Management screen is displayedThreat Database Configuring Web Filter Click Add to list Enterprise User Monitoring recommended NetBIOS Configuring Web Filter Configuring Web Filter Installing Service Pack Installing Service Pack Installing Service Pack Further Configuration Network Dependent Post Installation TasksALL Installations Firewall Policy Rules for ISA Server 2004Installing the EUM Agent on Your Domain Controllers User Name Resolution Select Domain Controllers screen is displayed Making changes to the EUM Agent configurationUser Name Resolution Installing Netwareeum Installing the EUM Login Agent on Your NetworkIgnored users in NetWare EUM Automatically loading the NetWare EUMUnloading the NetWare EUM Add Web Filter Servers to NetWare EUMInstall Surfcontrol Report Central Installing the Remote Administration Client Select I accept the terms of the license agreement Select Remote Administration Installing the Remote Administration Client InstallShield Wizard Complete screen is displayed Remote Administration Client and Windows VistaAllow VCA Spider Functionality Allow Internet Threat Database UpdatesConfigure IE and the VCA Firewall Policy RulesFrom the Primary Connection Information screen, click New Allow the Remote Administration Client AccessConfigure a Firewall Policy Rule for the VCA From Access Rule Destinations, click AddAllow Remote Access to Surfcontrol Report Central SRCEnter 8888 in the Port Range From field Click Apply in the Firewall Policy window Appendix Contact Technical Support Location Contact information Sales and Feedback