• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

SQL policy vs expiration

What is the difference between SQL password policy and password expiration? What happens if I enable only password policy but not expiration?
2 Solutions
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
The password policy governs the password complexity requirements (E.g. a password must be minimum 8 characters in length and so on). You may read more about this here: https://docs.microsoft.com/en-us/sql/relational-databases/security/password-policy?view=sql-server-2017

Password expiration dictates that the password "expires" and must be reset after a certain number of days.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Password policy is from the Windows OS, meaning that SQL Server will use the Windows Password Policy instead of the SQL Server Password Policy.
If you want to have a different policy then configure your own SQL Server Password Policy and use that one.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now