Edit

Share via

Connectivity error 0x80004005 occurs from SQL Sever Agent SSIS failures

  • Article

This article provides a resolution to a connectivity issue in which SQL Server Integration Services (SSIS) packages that use an SQL Agent fail to run.

Symptoms

When you try to run SSIS packages that use an SQL agent, the packages don't run, and you receive the following error messages:

An OLE DB record is available. Source "Microsoft OLE DB Driver for SQL Server" Hresult. 0x80004005 Description "Protocol error in TDS stream".

An OLE DB record is available. Source "Microsoft OLE DB Driver for SQL Server" Hresult. 0x80004005 Description "Communication link failure".

An OLE DB record is available. Source "Microsoft OLE DB Driver for SQL Server" Hresult. 0x80004005 Description "TCP Provider: An existing connection was forcibly closed by the remote host".

Resolution

To resolve this issue, follow these steps:

  1. Open SQL Server Management Studio (SSMS), and then connect to your SQL Server instance.
  2. In the Object Explorer, navigate to SQL Server Agent.
  3. Locate your SSIS job that runs the package.
  4. Right-click the job, and then select Properties.
  5. In the Steps section, find the step that runs your SSIS package.
  6. Select the Edit button to open the Job Step Properties.
  7. In the Job Step Properties dialog box, navigate to Configuration > Connection Managers.
  8. Select the connection that's experiencing the issue.
  9. Change the value of the RetainSameConnection property from False to True.
  10. Select OK to save your changes.

Note

You can also adjust the RetainSameConnection property directly in the SSIS package connection manager properties.

See also

An existing connection was forcibly closed by the remote host (OS error 10054)