Avatar of Jay Carax
Jay Carax
 asked on

Error authenticating proxy SQL Server 2008

Hello

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

http://www.codeproject.com/Articles/28918/SQL-Server-Agent-Proxy

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?
Microsoft SQL Server 2008Microsoft SQL Server

Avatar of undefined
Last Comment
Jay Carax

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rainer Jeschor

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Jay Carax

ASKER
Hello RainerJ

Thanks for your post but I am afraid it is still not working :(
Rich Weissler

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.  ;-) )
EugeneZ

what are this login  sql permissions ?  
make sure you did all steps from above links
and
check
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/f7653a0a-2b7d-4994-90c3-760db8648c7d/
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Jay Carax

ASKER
Thank you.