ETL Refresh errors with Login timeout expired

The ETL Refresh errors out with the log:

Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "Login timeout expired".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
The root cause was a login timeout error which occurred when one of the ETL packages tried to access the database. This type of error has various causes that are not completely controllable, as there are many reasons a process can timeout. Retry the ETL refresh, and it should be successful.

Steps to Duplicate

Run the ETL Refresh in a non-production environment

Environment

 Blackbaud CRM
 4.0
 4.0
 4.0.173

Was this article helpful?