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!