Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ETL Expand / Collapse
Posted Tuesday, October 29, 2013 1:20 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, September 21, 2016 11:37 AM
Points: 284, Visits: 1,471
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?
Post #1509541
Posted Wednesday, October 30, 2013 7:31 AM


Group: General Forum Members
Last Login: Tuesday, December 6, 2016 3:06 AM
Points: 476, Visits: 1,069
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.

Post #1509768
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse