May 12, 2008 at 12:13 am
Dear friends
I need to auto mate my package i am facing the fallwoing problem .I had studied some articles through online also but i am not still i am getting the same error..
The job was failed: The job invoked by the User...
I am Using all SQL server connections to build my package but i need to run my packge in Windows authuntication..
plz guide me.
May 12, 2008 at 8:25 am
Without more details, I don't know if I can be of help. In the SQL Agent job properties, have you verified that the owner is correct? If so, have you verified your permissions on the server on which this job is trying to run to ensure that your Windows login actually has the right priveleges?
May 12, 2008 at 8:51 am
In SQL Server, all jobs are run based on the credentials of the account that the SQL Server agent is signed in as.
When you developed your package, you probably used your SQL Server login, and I'm assuming you have dbo rights in your development area, it worked because you have those rights.
Now comes time to deploy, well, the SQL Server again may not have the same rights, so the package don't run successfully. Either you have to give the same rights to the account the SQL Server Agent uses to login or you can set up a proxie account that is used to run the jobs.
Either way, you may want to check with your network admins because some companies frown on use of proxie accounts, and they should know which login is used by the SQL Server Agent. Once that information is obtained, you will have to ensure that account has the appropriate rights to run your job.
Marvin Dillard
Senior Consultant
Claraview Inc
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply