Job Execution

Posted on 2009-02-24
Last Modified: 2013-12-12
I keep getting this error anytime i try to excute a job to run an SSIS package, can anyone tell me what im doing wrong?

Executed as userXXX\sqlservice. ...ion 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  12:07:16  Error: 2009-02-24 12:07:16.56     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2009-02-24 12:07:17.11     Code: 0xC0202009     Source: refresh_style_colour_dims Connection manager "SourceConnectionOLEDB"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Oracle"  Hresult: 0x80040E4D  Description: "ORA-01017: invalid username/password; logon denied  ".  End Error  Error: 2009-02-24 12:07:17.11     Cod...  The package execution fa...  The step failed.
Question by:M_Boy76
    LVL 8

    Expert Comment

    its purely invalid username/password; better try to reolve the username

    Author Comment

    is it the account used to login into the other system or the account used to run the job?
    LVL 60

    Accepted Solution

    you may have to go into the package, and set the passwordencryption option to "do not save"

    Author Comment

    How do i do that?
    LVL 30

    Assisted Solution

    Right click on a blank spot in the designer and press properties.
    In the properties pane, go to Security/ProtectionLevel
    You probably have 'EncryptSensitiveWithUserKey' selected.
    When the developer account (yourself) doesn't match the execution account (sql agent), it cant find the key to decrypt passwords.
    There is a whole topic around package protection levels, but here are some solutions:
    1. Only use trusted connections in your package, and pick a protection level of DontSaveSensitive
    2. If you must use passwords in your package (i.e. if you have an AS400 source), pick EncryptSensitiveWithPassword and enter a password. Then use that password when scheduling it.
    LVL 60

    Expert Comment

    thank you nmcdermaid, I accidentally skipped over this response.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Suggested Solutions

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now