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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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. ;-) )
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
and
check
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/f7653a0a-2b7d-4994-90c3-760db8648c7d/
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/
ASKER
Thank you.
ASKER
Thanks for your post but I am afraid it is still not working :(