Filter
Top Products
22 Starter Guide SurfControl Web Filter for ISA v5.5
I
NSTALLATION
D
ECISIONS
Database Considerations
2
3 Type the following: sqlcmd -S.\sqlexpress
4 You should get a prompt like this: 1>
5Type: Exit to exit sqlcmd
6 Open the SQL Computer Manager.
7 Expand Server Network Configuration.
8 Expand Protocols for SQLEXPRESS.
9 Enable Np (for local and remote access).
10 Enable TCP (for local and remote access).
11 Restart 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:
1 Install SQL Server on the designated server; this can be the same machine as the Web Filter server.
2 Make sure your server has the minimum resources listed in the table below.
Table 2-4 SQL Server minimum requirements on Web Filter server
3 Configure 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.
# 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.
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.