SurfControl Web Filter for ISA v5.5 Starter Guide 23
I
NSTALLATION
D
ECISIONS
Database Considerations
2
Reasons to Install SQL Server on a Dedicated Server
Use SQL Server 2000 or 2005 on a dedicated server if your organization:
• Needs to store large amounts of data (for instance, you have a large number of users, high Internet
activity, or need to retain data for an extended period).
• Requires more than one Web Filter server (collector) to consolidate data in a single database.
• Plans to store Web Filter and SurfControl E-mail Filter data on the same SQL Server installation.
Make sure your dedicated SQL Server has the minimum resources listed in the table below:
Table 2-5 SQL Server minimum requirements for large environments
DATABASE AUTHENTICATION
Web Filter supports both Windows authentication and SQL authentication. SurfControl recommends
Windows authentication because it is easier to use and compliant with Microsoft’s security
recommendations. If you choose SQL authentication, any configured connections must be re-established if
the username or password of the SQL user account (e.g. SA) changes. With Windows authentication, you
can change the username and password without having to reconfigure the database connection.
Windows Authentication
If you choose to use Windows authentication, make sure domain rights are correctly configured between
the Web Filter server and the SQL Server database. The Web Filter installer account requires SQL Server
database creator rights.
SQL Authentication
If you choose to use SQL authentication, you will need to create a SQL Server login specifically for Web
Filter. This login is required for creating the database and will be used for all Web Filter database
activities.If you choose to connect to the SQL database using SQL authentication, make sure the SQL
Server is configured to support SQL Server and Windows NT authentication.
# Users Computer Specification
<500 Intel Pentium IV, 1 GB RAM, 1.2 GHz processor, 10 GB hard drive
500 - 1000 Intel Pentium IV, 2 GB RAM, 1.4 GHz processor, 20 GB hard drive
1000 - 5000 Intel Pentium IV, 4 GB RAM, 1.4 GHz processor, 40 GB hard drive
>5000 Intel Pentium IV, 6 GB RAM, 1.8 GHz processor, 60 GB hard drive