2 |
INSTALLATION DECISIONS
Database Considerations
3Type the following: sqlcmd
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 |
