Link to home
Start Free TrialLog in
Avatar of Jay Carax
Jay Carax

asked on

Error authenticating proxy SQL Server 2008


I have attempted to create a proxy account using this as a source:

However, when I attempt to run the job that executes the SSIS package, I get this error:

Error authenticating proxy <ProxyAccountName>, system error: Logon failure: unknown user name or bad password.

I am sure the proxy credentials are correct as I can log in to a PC.

Any ideas?
Avatar of Rainer Jeschor
Rainer Jeschor
Flag of Germany image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jay Carax
Jay Carax


Hello RainerJ

Thanks for your post but I am afraid it is still not working :(
Sounds like it's going to be something less obvious.

Check the SQL Errorlog and Windows security logs for messages around the time of the error.  
  -- If it's attempting to log into the domain, make certain you don't have a / instead of a \.
  -- If it's a local machine account... make certain you have the machine name in there instead of the domain name.

In any event, one of the error logs listed above should give a clue as to what is going on.  (And if the system isn't logging failed attempts, I'd turn on logging of failed attempts, if for no other reasons, than to track down fun issues like this one.  ;-) )
what are this login  sql permissions ?  
make sure you did all steps from above links
Thank you.