Monday, March 12, 2012

Login Error in today's processing

I have an

ETL package that processes every morning through SQL Agent. It has

been running for a month or 2 on this build - I received the following

error this morning:

An OLE DB error has occurred. Error

code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native

Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE

DB record is available. Source: "Microsoft SQL Native Client" Hresult:

0x80004005 Description: "TCP Provider: An existing connection was forcibly

closed by the remote host. ". An OLE DB

record is available. Source: "Microsoft SQL Native Client" Hresult:

0x80004005 Description: "Login failed for user '(null)'. Reason: Not associated

with a trusted SQL Server connection.".

This

package is trying to pull data from our source (remote) server. After

the failure I re-started the SQL job and it processed without any

errors,

This

is a critical process so I need to eliminate any errors - any idea why

SSIS would pass a NULL login? There is not enough information in the

log for me to deterimine the exact OLEDB Source that is causing the

error.

Does anyone have an idea of what I could check?

-Evan Black

This may have been a problem with our domain controller. I will post an update when our network department finishes their research.

Thanks,

-Evan Black

No comments:

Post a Comment