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”
- 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: –
- An error occurred attempting to retrieve lookup data. This error does
- It was not possible to connect to the database.
The error returned was:
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error
- It was not possible to connect to the database.
- list SQLState = 08001
- 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.