Manuals / Surf Control / TV and Video / TV Receiver

Surf Control 5.5 manual Creating a NEW SQL Server Database

Models: 5.5

1 157

Download 157 pages 10.49 Kb

Page 135

11

DATABASES

Creating a New SQL Server Database

CREATING A NEW SQL SERVER DATABASE

If you wish to create a new SQL Server database for Web Filter, use the SurfControl Database Creation Wizard. Before you can use the Wizard, check the following:

•You must have installed a complete or client version of Web Filter.

•You must have installed Microsoft SQL Server (usually on its own server).

•The SurfControl server must have network access to the SQL Server.

•There must be a user account on the SQL Server with a Database Creators role.

Note: A SurfControl database should only have one database owner.

To create a new SQL Database:

1From the All Programs > SurfControl Web Filter > Database Tools menu select Create SQL Server Database. The Create SurfControl Web Filter Database Wizard will start.

2Click Next.

3Enter the name of the SQL Server and the proper authentication:

•For Windows authentication, select Use Trusted Connection.

•For SQL authentication, leave Use Trusted Connection deselected.

•Enter the SQL Administrator Username and Password.

4Click Next.

5Enter the name of the database.

•If you deselect Use Default Locations, specify the locations for the database and transaction log files.

•If you deselect Set as SurfControl Web Filter Default, specify the new database for both the Rules and Monitor databases.

6Click Next.

7Click Finish. The new database will appear in the Web Filter Manager Navigation tree.

To use the new database in a multiple installation environment you must select the new database from the Web Filter service. See "Database Tab" on page 112 for more details.

128 Administrator’s Guide

SurfControl Web Filter v5.5

Image 135

Surf Control 5.5 manual Creating a NEW SQL Server Database

Contents

SurfControl Web Filter Trademarks SurfControl Web Filter Table of Contents Rules Administrator Real Time Monitor Appendix 145 Introduction to Web Filter ChapterAbout Surfcontrol WEB Filter Basic Configuration Introduction Restart the Web Filter Service Basic Service SettingsAccessing the Service Settings Understanding the SettingsConfigure Subnets Subnet MonitoringSelect Do not Monitor traffic to or from these subnets Ignore Subnets Mail NotificationsSelect Only Monitor traffic to or from these subnets More Information For more details on the other Service Settings, see ChapterInitial Monitored Data Settings Default Monitor SettingsAccessing the Monitor Settings Tab Description 1Monitor SettingsEZPeer File Type Group File Extensions Monitored 2List of File TypesRecommendations for Creating and Applying Rules Basic Rule ConfigurationScheduling Tasks Remote Administration What the Remote Administration Client does Rules Administrator Create and edit rulesPrerequisites Licensing Entering a WEB Filter License KEY Licensing WEB FilterPrivacy Edition What IT does Comparing the Standard and Privacy EditionsAction Standard Edition Privacy Edition Type Standard Edition Privacy Edition 3SRC ReportsPrivacy Edition Features Change the Manager and Union PasswordsViewing User Details From the Monitored Users Tasks, select View User Details Privacy Edition Features Web Filter Manager 1Web Filter Manager Opening the WEB Filter ManagerWorking with the WEB Filter Manager Navigation PaneCentral Pane Information Pane What Can Be SeenNavigation tree item Data viewed Tasks 1Web Filter Manager Navigation items Surfcontrol WEB Filter Data DisplayedTasks Refresh Server Status Add DatabaseWEB Filter Server Server Information DashboardSection Data Tasks How Data is sorted in the Web Filter Manager Monitored DataData FiltersCreating a Custom Filter Users Summary User InformationDetail User Information Users Section Tasks Create New File Type Groups Update ConfigurationMonitor Settings Monitored Data TasksClick New Port Adding New Protocols And PortsPrint Monitored Users TasksUnmonitoring Destinations or Users RefreshChange Groups Rename UserGet Friendly Name Get User NameOption Description Monitor Settings for UsersTask Description Monitored Connections TasksDestinations Summary Destination InformationDetail Destination Information Tasks Submit Destination Monitored Destinations TasksUnmonitor Go To SiteSet Category Categories Summary Category InformationDetail Category Information Categories Categories Tasks Tool Description Content Protection9Web Filter Maintenance Tools MaintenanceMaintenance Rules Administrator Guidelines for Rule Creation Creating Rules Introduction Creating a New Rule Object Rule ObjectsActive Directory, NT and NetWare Domain Objects Where Installed Objects seenWHO Objects Monitored WorkstationsWho Lists Creating User Defined WHO ObjectsUser-defined Who Objects Mobile Who ObjectsMAC Address MAC Address is the Physical Address entryAgain, the MAC Addresses are the Physical Address entries Who List Objects Subnet ObjectCreating User Defined Where Objects Where ObjectsIpconfig /all Make a note of the IP Address and Subnet Mask entries Category Object SurfControl Categories Custom CategoriesExample 11Where List object dialog box Where ListsWhat Objects PROTOCOLS/PORTS ObjectsProtocol Group Port P2P Streaming Media Precise Bandwidth Controls Object Filtering IM, P2P and Web Protocols by signatureApplication type Protocols 13What List dialog box What ListsWhen Objects After WorkStart Time End Time 15After Work object properties Weekends17Worktime object properties WorktimeAllowance Objects MB Volume ObjectType of Allowance Allowance Limit Type of Allowance Volume Allowance Limit 10240 KBMinute Time Object About Browse Time SensitivityTotal Browse time Minutes Stand-Alone BrowsingContinuous Browsing From +Browse Time Sensitivity Duration21Notify Objects tab Notify ObjectsNotify Objects File Type Group File Extensions Http Deny page Objects DefaultAllowance 25Default Http Deny WebConstructing Http Deny Pages Other Http Deny page ObjectsViewing Another Collector Viewing Another Collector Real Time Monitor Column Description 1Real-Time Monitor2Real-Time Monitor Options dialog box Display Columns Column Description Default OptionOther Settings Category ColorAssigning a Category Color 3Collector Details Collector DetailsStopping and Starting the REAL-TIME Monitor Stopping and Starting the Real-Time Monitor Web Filter Settings HOW to Configure the WEB Filter Settings 1Web Filter service Settings Available Settings2Start/Stop Service tab START/STOP Service TAB3Active Directory tab Active Directory TABIgnore Subnets Subnets TABSubnet Monitoring Subnet MonitoringIgnore Subnets Advanced TAB Network SettingsMonitor to Database Settings TCP/IP Name Resolution DNSInternet Threat Database Improvement Program Categorization TABCategorization Company Domains and Intranet DestinationsProtocol Signatures TAB 7Ignored Ports tab Ignored Ports TABCreating NEW Ports Username ResolutionEnterprise User Monitoring REAL-TIME Monitor TAB 9Real-Time Monitor Settings10 Database tab Database TABDatabase Tab Mail Notifications TAB 11E-mail Notification tab Mail Notifications Tab Custom Categorization HOW IT Works VCA in Evaluation ModeList of Destinations TAB Using Custom CategorizationUsing Custom Categorization Custom Categorization dialog, click the VCA Settings tab VCA Settings TAB3VCA Results tab VCA Results TABUsing Custom Categorization 4VCA Service Control tab VCA Service Settings\Program Files\SurfControl\Web Filter\SpiderFiles Using Custom Categorization Databases Creating a NEW SQL Server Database 1The Database Management Tool Managing DatabasesPurge ArchiveCompact DeleteClick Delete Now Restore Options Updating Your Database Updating Your Database Upgrading Your Database Click Update DatabaseExporting Manually Categorized Sites IMPORTING/EXPORTING DatabasesImporting Manually Categorized Sites Scheduler Scheduler SCHEDULERIntroduction Command Line Available EventsDatabase Management Database Update Network Groups Update Internet Threat Database UpdateAppendix Contact Technical Support Location Contact information Sales and Feedback Index SurfControl Web Filter Administrator’s Guide