Monday, March 12, 2012

Job fails in SQL Server 2005 Agent with error "Package not found"

Hello everybody,
I am trying to run an SQL Server 2005 job which is made up of one SSIS
package.
The SSIS package run successfully when I start it manually, but as soon as I
include it in an SQL Server Agent I get the error message mentioned in the
subject.
Any ideas?
Thank you in advance
Massimo SartorisHere is the solution for this issue from Micorosft:
http://support.microsoft.com/Default.aspx?kbid=918760
Bob
"Massimo" wrote:
> Hello everybody,
> I am trying to run an SQL Server 2005 job which is made up of one SSIS
> package.
> The SSIS package run successfully when I start it manually, but as soon as I
> include it in an SQL Server Agent I get the error message mentioned in the
> subject.
> Any ideas?
> Thank you in advance
> Massimo Sartoris|||Thank you, Bob.
I tried the proxy method described in the article, but the job keeps
failing. The error message is now
"A required privilege is not held by the client"
The user is an administrator on the SQL server machine, which privilege is
actually missing?
Thank you
"Bob" wrote:
> Here is the solution for this issue from Micorosft:
> http://support.microsoft.com/Default.aspx?kbid=918760
> Bob
>|||Did you change the SQL Server Service account to use the proxy method?
"Massimo" wrote:
> Thank you, Bob.
> I tried the proxy method described in the article, but the job keeps
> failing. The error message is now
> "A required privilege is not held by the client"
> The user is an administrator on the SQL server machine, which privilege is
> actually missing?
> Thank you
>
>
> "Bob" wrote:
> > Here is the solution for this issue from Micorosft:
> >
> > http://support.microsoft.com/Default.aspx?kbid=918760
> >
> > Bob
> >
>|||Bob,
I did, actually.
I created a credential with an account that has administrator rights
(Username "Massimo")
I created a proxy using that credential.
I changed the step in the SQL Server agent job saying "run as" the proxy
instead of the SQL Agent Service Account
Username "Massimo" is also member of the group SQLServer2005SQLAgentUser
Cheers
Massimo
"Bob" wrote:
> Did you change the SQL Server Service account to use the proxy method?
> "Massimo" wrote:
>

No comments:

Post a Comment