Notifications
Announcements
No record found.
How i can make the User Password expire every 90 days for example ( GP 10 with SQL 2000 ).
*This post is locked for comments
Out of the box you can enforce your password policy in SQL only if you are using SQL 2005.
We check the box to adhere to Active Directory password requirements, so passwords are forced to change and meet complexity requirements.
where i can find adhere to Active Directory password requirements
Password settings are generally enabled in your Active Directory Default Domain Group Policy Object. You'd need to contact your network/Windows admins (if you don't do this) to get the settings.
If you mean within GP, it is one of the check boxes next to the account when you create it and set the password, or change the password. This is GP 10 here. Not sure about earlier versions.
In order to use the Advanced SQL Server options regarding Password Policy, you must be using SQL Server 2005 or later on Windows Server 2003 or later and the machine must be part of the domain. In your original post you said you were using SQL 2000, therefore you do not meet the minimum requirements to take advantage of these options.
Can you mark the box next to Enforce Password Policy? If I understand your environment correctly, the box should not be available to check.
Let us know :)
Kind regards,
Leslie
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
