SOL Job Login Failure

Question

SOL Job Login Failure

chandrika.r 91171

Old Hand

Points: 397
More actions
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.

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

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

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

chandrika.r 91171 Old Hand Points: 397 More actions · Answer 3

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

CapnHector SSCoach Points: 16143 More actions · Answer 4

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]

Jenileo Valued Member Points: 61 More actions · Answer 5

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.