August 21, 2008 at 2:35 am
Hi i get this error message when i schedule my job in IS any ideas ?
Message
Executed as user: STERM2\SYSTEM. ...ion 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:44:00 Error: 2008-08-18 12:44:01.37 Code: 0xC0202009
Source: Schedule_job Connection manager "ISPRIMARY.Mart08"
Description: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80040E4D Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80040E4D Description: "Named Pipes Provider: No process is on the other end of the pipe. ".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description:
"Login failed for user 'Sev1\STERM2$'.". End Error Error: 2008-08-18 12:44:01.37
Code: 0xC00291EC Source: Execute SQL Task 1 Execute SQL Task
Description: Faile... The package execution fa... The step failed.
August 21, 2008 at 6:45 am
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description:
"Login failed for user 'Sev1\STERM2$'
I think that is the key line in the error message. Make sure that this user has rights where you are connecting.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply