Azure SQL Server Connection failure issue when running SSIS package Jobs

Dhara Prajapati 1 Reputation point
2020-06-05T03:21:51.023+00:00

Hi,

I am facing the following error while loading data on Azure SQL Server:

First error:
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
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.

Second error:
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: ;Microsoft OLE DB Provider for SQL Server; Hresult: 0x80004005 Description: ;Cannot open server ;xyz.com; requested by the login. The login failed.;.

Third error:
Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: ;Microsoft OLE DB Driver for SQL Server; Hresult: 0x80004005 Description: "Login timeout expired;.
An OLE DB record is available. Source: ;Microsoft OLE DB Driver for SQL Server; 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 OLE DB Driver for SQL Server; Hresult: 0x80004005 Description: ;Named Pipes Provider: Could not open a connection to SQL Server [53]..

These errors doesn't occurs continuously but I face it on random basis. Can anyone get me help to resolve this issue as soon as possible as I need to report a solution for the same.

Thanks & Regards,
Dhara

Azure SQL Database

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2020-06-09T00:32:43.837+00:00

    @DharaPrajapati-8699

    There are few things you can do here:

    1) This more looks like to be issue on your On Prem Connection end and the network. Please check the documents on MSDN and Stack for more insight into this.

    2) Raise the issue in SQL Server On prem forum on MSDN which will get more traction for your issue and provide you with correct solutions.

    3) As the issue is intermittent we would suggest to raise the issue with support and work with them to identify the issue.

    Thanks Navtej S

  2. Uri Dimant 206 Reputation points
    2020-06-11T04:19:52.973+00:00

    Hello
    Yes, I have seen such errors when we upload the data to SQL Azure, In my opinion it is networking problem, I mean a data center when the db is located some how cannot establish connection. I suggest you open the case in MS or call support office.