November 28, 2012 at 6:30 am
I have an SSIS Package that I have loaded into the MSDB database.
I then created a job that I will run on a regular basis, set the job type to SQL Server Integration Services Package and the correct package is specified as \MSDB\NavRoutineResults
The command line is shown as
/DTS "\MSDB\NavRoutineResults" /SERVER GKNJNAV01 /CHECKPOINTING OFF /REPORTING E
I have also set the protection level to DontSaveSensitive on the package property in BIDS.
The error after job execution is below
Executed as user: GKNJNAV01\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 8:20:11 AM Error: 2012-11-28 08:20:11.92 Code: 0xC0202009 Source: NavRoutineResults Connection manager "GKNJNAV01.GK50LIVE.sa" 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 Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'sa'.". End Error Error: 2012-11-28 08:20:11.92 Code: 0xC020801C Source: Data Flow Task OLE DB Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "GKNJNAV01.GK50LIVE.sa" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2012-11-28 08:20:11.92 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "OLE DB Source" (1) failed validation and returned error code 0xC020801C. End Error Error: 2012-11-28 08:20:11.92 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2012-11-28 08:20:11.92 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:20:11 AM Finished: 8:20:11 AM Elapsed: 0.219 seconds. The package execution failed. The step failed.
Based on this message it seems as if there are two accounts being used by the job. One is by SYSTEM and the other SA.
I don't recall specifying to use SA anywhere in particular and am not sure why SYSTEM is being used.
Can anyone offer any guidance? Thanks.
November 28, 2012 at 2:31 pm
How can the login fail for user SA?
The only place I am entering the SA credentials are in the connection manager to test my data data connection.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply