Error en la ejecucion de tarea

Buenos Dias

Venia ejecutando un tarea sin problema y desde ayer me comenzo a fallar y me
sale este mensaje al parecer es un error de autenticacion pero no se como
solucinarlo.


GRacias


Message
Executed as user: DTASRVSQL02\SYSTEM. ...9.00.3042.00 for 64-bit Copyright
(C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:16:46 AM
Error: 2007-11-23 09:17:13.76 Code: 0xC00291EC Source:
{71693EE4-1C48-4617-AED1-84F5253392BC} Execute SQL Task Description:
Failed to acquire connection "Local server connection". Connection may not be
configured correctly or you may not have the right permissions on this
connection. End Error Warning: 2007-11-23 09:17:13.76 Code: 0x80019002
Source: OnPreExecute Description: SSIS Warning Code
DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the
number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End
Warning Error: 2007-11-23 09:17:13.81 Code: 0xC0024104 Source: Full
Database Backups ... The package execution fa... The step failed.

La tarea falla cuando se ejecuta en forma agendada?
Falla cuando se la ejecuta manualmente?

Gustavo Larriera, Microsoft MVP
https://mvp.support.microsoft.com/profile/gux
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Wilsom Duran" wrote:

> Buenos Dias
>
> Venia ejecutando un tarea sin problema y desde ayer me comenzo a fallar y me
> sale este mensaje al parecer es un error de autenticacion pero no se como
> solucinarlo.
>
>
> GRacias
>
>
> Message
> Executed as user: DTASRVSQL02\SYSTEM. ...9.00.3042.00 for 64-bit Copyright
> (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:16:46 AM
> Error: 2007-11-23 09:17:13.76 Code: 0xC00291EC Source:
> {71693EE4-1C48-4617-AED1-84F5253392BC} Execute SQL Task Description:
> Failed to acquire connection "Local server connection". Connection may not be
> configured correctly or you may not have the right permissions on this
> connection. End Error Warning: 2007-11-23 09:17:13.76 Code: 0x80019002
> Source: OnPreExecute Description: SSIS Warning Code
> DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the
> number of errors raised (1) reached the maximum allowed (1); resulting in
> failure. This occurs when the number of errors reaches the number specified
> in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End
> Warning Error: 2007-11-23 09:17:13.81 Code: 0xC0024104 Source: Full
> Database Backups ... The package execution fa... The step failed.
>

De la dos formas,,, ya que la tarea esta agendada y puse a ejecutar el jos
solo y nada me sale el mismo error

WDS

"Gux (MVP)" wrote:

> La tarea falla cuando se ejecuta en forma agendada?
> Falla cuando se la ejecuta manualmente?
>
> Gustavo Larriera, Microsoft MVP
> https://mvp.support.microsoft.com/profile/gux
> Este mensaje se proporciona tal como es, sin garantías de ninguna clase.
>
>
>
> "Wilsom Duran" wrote:
>
> > Buenos Dias
> >
> > Venia ejecutando un tarea sin problema y desde ayer me comenzo a fallar y me
> > sale este mensaje al parecer es un error de autenticacion pero no se como
> > solucinarlo.
> >
> >
> > GRacias
> >
> >
> > Message
> > Executed as user: DTASRVSQL02\SYSTEM. ...9.00.3042.00 for 64-bit Copyright
> > (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:16:46 AM
> > Error: 2007-11-23 09:17:13.76 Code: 0xC00291EC Source:
> > {71693EE4-1C48-4617-AED1-84F5253392BC} Execute SQL Task Description:
> > Failed to acquire connection "Local server connection". Connection may not be
> > configured correctly or you may not have the right permissions on this
> > connection. End Error Warning: 2007-11-23 09:17:13.76 Code: 0x80019002
> > Source: OnPreExecute Description: SSIS Warning Code
> > DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the
> > number of errors raised (1) reached the maximum allowed (1); resulting in
> > failure. This occurs when the number of errors reaches the number specified
> > in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End
> > Warning Error: 2007-11-23 09:17:13.81 Code: 0xC0024104 Source: Full
> > Database Backups ... The package execution fa... The step failed.
> >

Veo que la tarea es ejecutada por DTASRVSQL02\SYSTEM.
Ya ha intentado ejecutar la tarea con otro usuario administrador?

Gustavo Larriera, Microsoft MVP
https://mvp.support.microsoft.com/profile/gux
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Wilsom Duran" wrote:

> De la dos formas,,, ya que la tarea esta agendada y puse a ejecutar el jos
> solo y nada me sale el mismo error
>
> WDS
>
> "Gux (MVP)" wrote:
>
> > La tarea falla cuando se ejecuta en forma agendada?
> > Falla cuando se la ejecuta manualmente?
> >
> > Gustavo Larriera, Microsoft MVP
> > https://mvp.support.microsoft.com/profile/gux
> > Este mensaje se proporciona tal como es, sin garantías de ninguna clase.
> >
> >
> >
> > "Wilsom Duran" wrote:
> >
> > > Buenos Dias
> > >
> > > Venia ejecutando un tarea sin problema y desde ayer me comenzo a fallar y me
> > > sale este mensaje al parecer es un error de autenticacion pero no se como
> > > solucinarlo.
> > >
> > >
> > > GRacias
> > >
> > >
> > > Message
> > > Executed as user: DTASRVSQL02\SYSTEM. ...9.00.3042.00 for 64-bit Copyright
> > > (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:16:46 AM
> > > Error: 2007-11-23 09:17:13.76 Code: 0xC00291EC Source:
> > > {71693EE4-1C48-4617-AED1-84F5253392BC} Execute SQL Task Description:
> > > Failed to acquire connection "Local server connection". Connection may not be
> > > configured correctly or you may not have the right permissions on this
> > > connection. End Error Warning: 2007-11-23 09:17:13.76 Code: 0x80019002
> > > Source: OnPreExecute Description: SSIS Warning Code
> > > DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the
> > > number of errors raised (1) reached the maximum allowed (1); resulting in
> > > failure. This occurs when the number of errors reaches the number specified
> > > in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End
> > > Warning Error: 2007-11-23 09:17:13.81 Code: 0xC0024104 Source: Full
> > > Database Backups ... The package execution fa... The step failed.
> > >