HomeSQL ServerSQL Server Error Msg 15118 – Password validation failed.

SQL Server Error Msg 15118 – Password validation failed.

In this blog post, let’s learn about the error message “15118 – Password validation failed. The password does not meet the operating system policy requirements because it is not complex enough.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

15118 – Password validation failed. The password does not meet the operating system policy requirements because it is not complex enough.

Reason for the Error

The reason for the SQL Server Error Msg 15118 is that the operating system enforces a set of password complexity requirements. These requirements are designed to ensure that passwords are strong and secure, and include criteria such as minimum length, complexity, and age. If the password that you are trying to set for the login does not meet these requirements, you will receive the error message.

Examples of Password Complexity Requirements Password complexity requirements can vary depending on the operating system that you are using, but some common examples include:

  • The password must be at least 8 characters long
  • The password must contain at least one uppercase letter, one lowercase letter, and one numeric character
  • The password cannot contain the user’s username or parts of the user’s full name
  • The password must be changed every 90 days

Solution

If you receive the SQL Server Error Msg 15118, there are several solutions to fix the issue:

  1. Ensure that the password meets the complexity requirements: Review the password complexity requirements set by the operating system and ensure that the password you are trying to set meets these requirements.
  2. Reset the password: If the password you are trying to set does not meet the complexity requirements, reset the password to a new password that meets the requirements.
  3. Disable password complexity requirements: If you do not want to enforce password complexity requirements, you can disable this feature in the operating system. However, this is not recommended, as it can make your system less secure.
  4. Use a password generator: If you are having trouble coming up with a password that meets the complexity requirements, consider using a password generator to create a strong and secure password.

In conclusion, SQL Server Error Msg 15118 occurs when the password you are trying to set for a login does not meet the complexity requirements set by the operating system. To fix this issue, ensure that the password meets the requirements, reset the password, disable the password complexity requirements (not recommended), or use a password generator. By following these solutions, you can set a strong and secure password for your SQL Server login.

Leave a Reply

You May Also Like

When dealing with a relational database management system (RDBMS) like SQL Server, compatibility level is an important concept to understand....
In this blog post, let’s learn about the error message “49975 – Unable to load controller client certificate due to...
In this blog post, let’s learn about the error message “49973 – Cannot remove tempdb remote file to local tempdb...