June 27, 2016 at 7:53 am
Hi,
I've created a package that imports data from an external MS Access database into an SQL table (deletes data first).
I saved it as a package and it works fine if I just run the package, but as soon as I create a job from that package and try to run the job, the job fails with
login failed for user sa, password did not match that for the login provided.
error 18456 severity 14 state 8
Don't want to be running this manually every night. What have I done wrong?
TIA Chris
June 28, 2016 at 12:23 am
This state occurs when password is not correct in the connection string for any SQL server authenticated logins.
To fix this error uncheck the enforce password policy in the properties of the sa user, but this is for SQL 2005 only. You can also take the help of third party SQL password recovery software[/url] which can help you to reset your password.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply