Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Log Server Troubleshooting Guide : Log Server installation: Error connecting to SQL Server
Log Server installation: Error connecting to SQL Server
Web Protection Solutions, v8.2.x, v8.3.x | 10-Dec-2016
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 tool (Start > Administrative Tools > Services or Server Manager > 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 Log Database permissions.
5.
Make sure you are running a supported version of Microsoft SQL Server.
The supported SQL Server versions are:
*
Microsoft SQL Server (Standard or Enterprise) 2008 R2, 2012, 2014, or 2016 (with the latest service packs from Microsoft)
*
For very small networks and evaluation environments, SQL Server 2008 R2 Express SP 2 (packaged in the TRITON Setup program).

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