SQL Cluster/Can't execute SSIS package using a proxy acc in sql jo

Giganews Newsgroups
Subject: SQL Cluster/Can't execute SSIS package using a proxy acc in sql jo
Posted by:  TheMask (TheMa…@discussions.microsoft.com)
Date: Fri, 23 Mar 2007

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?

Replies