![](/images/new-backgrounds/1163958/16395855x1.webp)
INSTALLATION DECISIONS
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
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
# 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 |
|
|
|
|
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
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.
SurfControl Web Filter for ISA v5.5 | Starter Guide 23 |