Kazmarek

Free Site Analysis 1-858-952-5400
REMOTE ASSISTANCE
  • Home
  • OnGoing Management
  • IT Services
    • Microsoft 365, Exchange Services, and Consulting
    • Cloud Solutions
    • Virtualization
    • Mobility
    • Backup & Disaster Recovery
    • Server Installation/Migration
    • VoIP
    • Network & System Administration
    • Additional Solutions
  • Why Kazmarek
    • Case Studies
    • Testimonials
    • KTS Values
  • For Clients
    • O365 Log In
    • Client Portal
    • KTS Documents
    • SonicWALL VPN Client
  • News
    • Newsletters
  • Who We Are
    • Company
    • Team
    • KTS E-Award Winners
    • KTS Values
    • Charities We Support
  • Contact Us
    • Contact Us
    • Careers

Manual Websense Database creation

May 22, 2007 by Robert Masterson

Problem

The Catalog Database was not created at installation, or became corrupted.

Solution

Create the Catalog Database manually from the command line.

  1. From the Windows Start menu, go to Programs > Accessories > Command Prompt. The Command shell opens.
  2. Get the name of the Server, which is the database instance or host name.
  3. Enter the createdbu command to create the new Catalog Database, including:
    • Server name
    • User name or “” (two double quotes) for trusted connection
    • Password or “” (two double quotes) for no password for trusted connection
    • Component (enter LogServer, Reporter, or Both)
    • New Catalog Database name
    • Database path (C:Program FilesWebsenseSQL)

    Be sure to include spaces in between each command and enclose each command with double quotes. For example:

    createdbu "WS-DB-SERVER" "ws_admin" "password1" "LogServer" "newlogdb63" "C:Program FilesWebsenseSQL"

    To see the options available with the createdbu command, enter the following:

    C:Program FilesWebsenseSQLCreateDbU.exe - Help

    NOTE

    It may take a few minutes for the database to be created.

    Both the catalog and partition databases should exist once the process is complete.

  4. Go to Microsoft SQL Server to verify that the new Catalog Database has been created. For Microsoft SQL Server 2000, go to Enterprise Manager. For Microsoft SQL Server 2005, go to Management Studio.
    1. For SQL Server 2000, the default path for Microsoft SQL Server 2000 is: C:Program FilesMicrosoft SQL ServerEnterprise Manager
    2. Expand the navigation tree to reveal the SQL Server name and the folders beneath it.
    3. Open the Databases folder to see the new Catalog Database (for this example, newlogdb63).
  5. Restart the Log Server.
    1. Go to the Windows Start menu and select Programs > Websense > Utilities > LogServer Setup. The Log Server Configuration displays with multiple tabs.
    2. Go to the Connection tab and click Stop in Service Status.
    3. Click Start in Service Status. You should see a message that says the service is running.
  6. Update your Explorer Settings.
    1. Go to Enterprise Explorer via Programs > Websense > Web Reporting Tools.
    2. Select Settings in Enterprise Explorer.
    3. Check the View the catalog database option.
    4. Click Save Settings.
  7. Go to Database Administration in the Reporting Tools Portal to see that the new Catalog Database name is displayed. At the top of the Database Administration screen, you will see Settings for: <machine name> <new Catalog Database name>.

Categories

  • Active Directory
  • Backup Exec (All Versions)
  • Blackberry / Blackberry Enterprise Server
  • Citrix
  • Cool Tech Stuff
  • CRM
  • Dell
  • Exchange 2007
  • Exchange 2010
  • Exchange 2013
  • Exchange Hosted
  • Exchange Server
  • Group Policy
  • IIS
  • Kaseya
  • kazmarek
  • MacOS
  • Microsoft
  • Networking
  • newsletter
  • Office
  • Office 365
  • Office Communications Server
  • OfficeScan
  • Outlook
  • Printing
  • SBS 2003
  • SBS 2008
  • SBS 2011
  • Server 2003
  • Sharepoint
  • Spyware
  • SQL
  • Symantec
  • Terminal Server
  • Thawte
  • Trend Micro
  • Uncategorized
  • Virtual Server
  • Websense
  • Windows 7
  • Windows Mobile
  • Windows Server 2008
  • Windows Server 2012
  • Windows Vista
  • Windows XP Pro/Home
Copyrights: © 2023 Kazmarek. All rights reserved.

Designed by TinyFrog & N Halie Designs