Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ETL Expand / Collapse
Author
Message
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: Today @ 4:00 PM
Points: 245, Visits: 1,137
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
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 28, 2014 8:09 AM
Points: 316, Visits: 592
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
Post #1509768
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse