Re: SQL Cluster/Can't execute SSIS package using a proxy acc in sql jo
- From: "Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx>
- Date: Fri, 23 Mar 2007 14:49:38 -0400
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BA440E41-2CBC-498D-B4EE-A70B64755D7C@xxxxxxxxxxxxxxxx
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?
.
- Prev by Date: Re: SQL 2000 cluster, "cannot generate SSPI context", SPN entries
- Next by Date: Re: SQL Cluster/Can't execute SSIS package using a proxy acc in sq
- Previous by thread: Re: Active / Active 2000 cluster.
- Next by thread: Re: SQL Cluster/Can't execute SSIS package using a proxy acc in sq
- Index(es):
Relevant Pages
|
