October 29, 2013 at 1:20 pm
I had job runnning well in sql server with a proxy account in sql serveragent but all of a sudden it throws out an error: "reason: Error authenticating proxy TestUser1, system error: Logon failure: unknown user name or bad password.). The step failed.". I tried with diffrent accounts and it gives me the same error. All accounts have full access to the databases in use-Infact one of the account under test is sysadmin. Don't know how to proceed. any help, idea?
October 30, 2013 at 7:31 am
On the server you are trying to connect your data source to have you checked the SQL log? It will give you a full description of the login failure and you can use the severity etc to find out the reason. Caveat is that auditing failed logins is turned on.
Off the top of my head a couple of suggestions are:
1. The login exists but has been set to deny connection
2. The login exists but is disabled
3. The login exists but is locked out.
4. The SQL server has been changed to only accept windows authentication and not mixed mode.
MCITP SQL 2005, MCSA SQL 2012
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply