Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-06-20 : 03:50:24
|
| Can anyone help me solve this error message My DTS is local and not on the server, the job just started to fail this last 2 days, no logins were changed here is the error message.A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': Logon failure: unknown user name or bad password. The step failed. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-20 : 04:34:17
|
| 1. Are you running SQL Agent as local system or other account?2. Do you have a password policy for expiration days?3. Have you tried to reset username and password to whatever is was before, when working?4. The job that is running, is that connecting to other machine than local? If connecting to other machine, has that account changed?Peter LarssonHelsingborg, Sweden |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-06-20 : 06:09:20
|
| Thanks for your help on this matter i will run this by my DBA as he seems to know very little about it and passes it on to someone else... |
|
|
|
|
|
|
Error