Just to re-cap....the issue is as follows -
> I have a SSIS package which connects to multiple servers
> It executes properly when directly executed from the dtsx file (double click -> execute)
> I have created a credential and a proxy on an instance (enterprise edition)
> I have created a job to execute the SSIS package using the proxy
> The job has a output log file
> I have tried both scheduling and directly executing the job, but it fails before starting with the following error - "Unable to start execution of step 1 (reason: Error authenticating proxy <Domain>\<WindowsID>, system error: Logon failure: unknown user name or bad password.). The step failed."
> Have tried changing the password, but did not resolve the error
> The indivual package is runing fine using multiple user IDs outside the SQL job
> I am using a proxy with credential of the ID having access and who is able to execute the package outside the Agent Job
> Have provided sa priviledge to the agent service account
> Additionally, changing to local system account is out of scope for me.
Chandrachurh Ghosh
DBA – MS SQL Server
Ericsson India Global Services Limited
Quality is not an act, it is a habit.