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


Sage 300cloud




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.


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.

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