1
Vote

Issues Running RSExecutionLog_Update.dtsx

description

I've tried everything but this error persists -
 
Message
Executed as user: AD\$sqlsvcacct. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:26:48 PM Error: 2008-09-29 15:27:05.24 Code: 0xC0202009 Source: RSExecutionLog_Update Connection manager "Source" 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 ... The package execution fa... The step failed.
 
Any help would be greately appreciated!

comments