What should I do if SQL Server error 18456 is caused by an incorrect password?

Question

Grade: Education Subject: Support
What should I do if SQL Server error 18456 is caused by an incorrect password?
Asked by:
78 Viewed 78 Answers

Answer (78)

Best Answer
(218)
If the cause is an incorrect password, the user needs to reset their password or be provided with the correct password. For SQL Server Authentication logins, you can reset the password in SSMS under Security -> Logins.