KB Article | Forcepoint Support

Problem Description

When installing Log Server, Real Time Monitor and other logging services, the Setup installer displays error:
"Cannot Connect to SQL Server”

Resolution

The "Cannot Connect to SQL Server" error may appear if an incorrect user name or password is used. Confirm the user name and password is correct.
  1. Open SQL Management Studio on the SQL server
  2. Attempt login using the user name and password that was also used in the Forcepoint Setup installer.
  • If the password was recently changed, restarting the SQL server may be needed.
  • If the user name and password are correct, then SQL permission may be restricted. Install using the SQL "sa" or an equivalent account.
 
Forcepoint cannot connect to SQL server if TCP/IP is disabled or is using an unexpected port.
  • For SQL 2005 to 2016, use the run command: SQLServerManager.msc (SQL Server Configuration Manager) to enable or modify the SQL protocol.
  • For SQL Server 2000 and MSDE, use the run command: svrnetcn (SQL Server Network Utility) to enable or modify the SQL protocol.

Note Ensure the version of SQL in use is supported for your Forcepoint Software version. See Forcepoint Web Security, TRITON AP-WEB, and Web Security Gateway Product Matrix.

Check the port used by SQL Server:
  1. On the SQL Server machine, open a command prompt window and type:
netstat -ban > port.txt
  1. A text document named port.txt is created by the above command. Open port.txt and search for: sqlserver.exe. The TCP port listed should be 1433.
 
To enable TCP or change the port for SQL Server 2005-2016:
  1. Select Start > Run and type:
SQLServerManager.msc
  1. Click OK.
  2. The SQL Server Configuration Manager opens.
  3. In the left pane, select SQL Server Network Configuration > Protocols for MSSQLSERVER.
  4. In the right pane, ensure TCP/IP is enabled.
  5. Check the TCP/IP properties.
  • If necessary, select and change all the listed ports to 1433.
  • If necessary, select and change the Enabled status to Yes.
  • Suggested changes are highlighted in yellow below.
User-added image
  1. Click OK and then close the SQL Server Configuration Manager.
  2. Restart the SQL Server Instance.
  3. After restarting, ensure the SQL Server Agent service is also running.
       Now install Websense Log Server and Reporting features.
 
 
To enable TCP or change the port for MSDE or SQL Server 2000:
  1. Select Start > Run and type:
svrnetcn
  1. Click OK.
  2. The “SQL Server Network Utility” opens. Select the General tab > Instance(s) on this server box.
  3. Verify the correct instance server name is selected.
  4. Ensure the TCP/IP protocol is enabled.
  5. If enabled, review the TCP/IP properties. If necessary, change to port 1433.
  6. Click OK twice.
  7. Restart the SQL Server Instance.
  8. After restarting, ensure the SQL Server Agent service is also running.
       Now install Forcepoint Log Server and Reporting features.
 

Article Feedback



Thank you for the feedback and comments.