Error: “It was not possible to connect to the database.” when running Sage Intelligence report.

Products

Sage 300cloud

Country

Country

Description

When running a Sage Intelligence report the following error ocurrs:

“SQL Execution Error”

    1. An error occurred attempting to retrieve lookup data. This error does
      not prevent you from running the report but may cause the lookup
      feature to be unavailable. The error was: –
    1. It was not possible to connect to the database.
      The error returned was:
      [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error
    1. list SQLState = 08001
  1. Please check with the administrator that the connection information
    configured fior this data container is valid.”

The report did not complete.

Cause

The SSL Security Error indicates a possible issue with FIPS Mode being enabled on a current version of Windows Server and the TLS 1.0 protocol not being negotiated.
Resolution

The Network / System Administrator should disable FIPS or enable TLS 1.0 to be negotoiated with the SQL Server.