"TheMask" <TheMask@discussions.microsoft.com> wrote in message
news:C7FD4833-4216-4B7B-8C61-E9EB851ED8DB@microsoft.com...
> I tried without success, using SSIS not clustered (service installed on
both
> nodes, this is the default option) and also clustered (I did configure
SSIS
> as a cluster service following this MS document:
> http://msdn2.microsoft.com/en-us/library/ms345193.aspx).
>
> Javier Villegas
>
>
> "Geoff N. Hiten" wrote:
>
> > Is SSIS clustered or not clustered?
> >
> > If it is not clustered, did you install it on all cluster nodes
separately?
> >
> > --
> > Geoff N. Hiten
> > Senior Database Administrator
> > Microsoft SQL Server MVP
> >
> >
> > "TheMask" <TheMask@discussions.microsoft.com> wrote in message
> > news:BA440E41-2CBC-498D-B4EE-A70B64755D7C@microsoft.com...
> > > I've a problem trying to execute a SSIS package inside a SQL Job that
uses
> > > a
> > > credential/proxy account.
> > >
> > > The sql job hist error msg is:
> > >
> > > Message
> > > Unable to start execution of step 1 (reason: Error authenticating
proxy
> > > DOMAIN\USER, system error: Logon failure: unknown user name or bad
> > > password.). The step failed.
> > >
> > > BTW, if I run the sql job as "SQL Agent account" it works fine
> > >
> > > I've this error on two differents sql clusters (one cluster is x86 and
the
> > > other x64)
> > >
> > > I've this running with no problems on a non-cluster sql server (5 diff
> > > servers)
> > >
> > > Any Idea?
> >
> >

"Anthony Thomas" wrote:

> Is the DOMAIN\USER account local to only one of the nodes or is it an actual
> AD Domain User? You can create local accounts, but then it will only work
> while resources exist on that node. You cannot use the Virtual Server as
> the DOMAIN, only the cluster nodes.
>
> To work in a clustered environment, you have to promote the account to the
> AD domain level.
>
>
> Anthony Thomas
>
>
> --
>
> "TheMask" <TheMask@discussions.microsoft.com> wrote in message
> news:C7FD4833-4216-4B7B-8C61-E9EB851ED8DB@microsoft.com...
> > I tried without success, using SSIS not clustered (service installed on
> both
> > nodes, this is the default option) and also clustered (I did configure
> SSIS
> > as a cluster service following this MS document:
> > http://msdn2.microsoft.com/en-us/library/ms345193.aspx).
> >
> > Javier Villegas
> >
> >
> > "Geoff N. Hiten" wrote:
> >
> > > Is SSIS clustered or not clustered?
> > >
> > > If it is not clustered, did you install it on all cluster nodes
> separately?
> > >
> > > --
> > > Geoff N. Hiten
> > > Senior Database Administrator
> > > Microsoft SQL Server MVP
> > >
> > >
> > > "TheMask" <TheMask@discussions.microsoft.com> wrote in message
> > > news:BA440E41-2CBC-498D-B4EE-A70B64755D7C@microsoft.com...
> > > > I've a problem trying to execute a SSIS package inside a SQL Job that
> uses
> > > > a
> > > > credential/proxy account.
> > > >
> > > > The sql job hist error msg is:
> > > >
> > > > Message
> > > > Unable to start execution of step 1 (reason: Error authenticating
> proxy
> > > > DOMAIN\USER, system error: Logon failure: unknown user name or bad
> > > > password.). The step failed.
> > > >
> > > > BTW, if I run the sql job as "SQL Agent account" it works fine
> > > >
> > > > I've this error on two differents sql clusters (one cluster is x86 and
> the
> > > > other x64)
> > > >
> > > > I've this running with no problems on a non-cluster sql server (5 diff
> > > > servers)
> > > >
> > > > Any Idea?
> > >
> > >
>
>