Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Web Security Log Server Troubleshooting Guide : Web Security Log Server installation: Error connecting to SQL Server
Web Security Log Server installation: Error connecting to SQL Server
Topic 50301 | Web Security Solutions | Updated 19-Sept-2013
Applies To:
Websense Web Filter, Web Security, Web Security Gateway, and Web Security Gateway Anywhere, v7.7 and 7.8
When the installer displays a SQL Server connection error, you can either:
*
Exit the installer, correct the problem and re-run the installer.
*
Leave the installer open, correct the problem and return.
To address the problem:
1.
Make sure the Microsoft SQL Server machine is running and available on the network.
2.
Use the Windows Services dialog box (Start > Administrative Tools > Services) to make sure the following services are running:
*
SQL Server
If you are using the default instance, the full service name is SQL Server (MSSQLSERVER).
*
SQL Server Browser
*
(SQL Server Standard or Enterprise) SQL Server Agent
If you are using the default instance, the full service name is SQL Server Agent (MSSQLSERVER).
SQL Server Express does not require the SQL Server Agent service.
3.
Double-check the SQL Server host name or IP address, instance name, and port:
*
If you entered the hostname, try using the IP address.
*
The instance name (if any) is entered as part of the hostname or IP address. For example, 10.201.55.13\instance_name.
*
The default port is 1433.
4.
Verify the authentication method used to connect to the database:
*
To specify a Windows trusted connection, the logon account used when running the installer must be a trusted account with appropriate permissions.
*
To specify a SQL Server account, verify that the account name and password are correct and the account has the appropriate permissions.
See Web Security Log Database permissions.
5.
Make sure you are running a supported version of Microsoft SQL Server.
In v7.8, the certified SQL Server versions are:
*
Microsoft SQL Server (Standard or Enterprise) 2008 SP3, 2008 R2 SP2, or 2012 SP1 (or the latest service packs from Microsoft)
*
For very small networks and evaluation environments, SQL Server 2008 R2 Express SP 2 (packaged in the TRITON Unified Installer).
In v7.7, the certified SQL Server versions are:
*
Microsoft SQL Server 2005 SP4, 2008, or 2008 R2 (Standard or Enterprise)
*
Microsoft SQL Server 2008 R2 Express (installed using the TRITON Unified Installer)

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Web Security Log Server Troubleshooting Guide : Web Security Log Server installation: Error connecting to SQL Server
Copyright 2016 Forcepoint LLC. All rights reserved.