Post reply

SOL Job Login Failure

  • March 22, 2012 at 11:56 pm

    #266175

    Hi All,

    I created a job in the SQL Server agent to run the SSIS package. I am the owner of the Job as well as to all the database connections used in the package. But when i run the job it says "Login Failed for [DomainName]\[Servername]. I am new to SQL server jobs. Please help me out.

  • March 23, 2012 at 12:21 am

    #1463171

    is your package using any network data sources that require authentication?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • March 23, 2012 at 1:14 am

    #1463193

    Is the package stored in the file system or msdb?

    When running the package outside of the job, does it still error?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 27, 2012 at 11:20 pm

    #1465463

    It does not return any error when i ran in SSIS. The package is stored in the file system.

  • March 29, 2012 at 10:50 am

    #1466495

    chandrika.r 91171 (3/27/2012)

    It does not return any error when i ran in SSIS. The package is stored in the file system.

    i would import it into msdb and try the job again. it might be you are getting the error while trying to open the ssis package from the file system.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • April 3, 2012 at 4:26 pm

    #1468569

    Depending on how you are calling the SSIS package, you may also want to check the login for the Agent Job. I believe that any jobs scheduled through SQL Agent will run under the context of the SQL Agent user unless you specify different in the job step properties, run as.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply