Skip to Content
0
Former Member
May 11, 2010 at 10:45 AM

DTS_E_OLEDBERROR error

295 Views

Hi,

I am running a SAP BPC package that connects to SQL server. Checking de DTSX, from Visual Studio, all the connections works ok but when I run it from Excel -> eData -> RunPackage it ends with the following error:

Package Error Events:

ErrorCode = -1071636471

Source = Interface

SubComponent= Connection manager "SQL"

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 Native Client" Hresult: 0x80004005 Description: "Login timeout expired".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Named Pipes Provider: Could not open a connection to SQL Server [53]. ".

Thanks!