March 24, 2010 at 6:15 am
My package runs fine directly but when I schedule a job it fails with error "LoadFromSQLServer method has encountered ... Login timeout expired". I tried using proxy account but in that case error is "Proxy authentication failed... Unknown user/pwd"
One strange thing I noticed is in log it says "job executed as user Domain\Svc_Directory" but my user name is different. What is this Svc_directory user and how it is trying to execute job when I'm the owner of job.?
Is there clean way of scheduling package?
March 24, 2010 at 7:18 am
It is not the account of the user that created the job that is used to execute the job, it is the account of the SQL Server Job Agent. See the configurion settings of SQL Server to view and/or change it.
You must make sure that the account that the SQL Agent uses has the necessery permissions to execute your packages and access the necessary resources...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 24, 2010 at 10:57 pm
Ok, Can you please tell me how to give right permissions for SQL Agent user? and what all permissions will it need to run the job?
Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply