December 9, 2002 at 8:14 am
Would like to know if there is anything out there that makes SQL logins force a change on passwords, much like Win2k does for user accounts.
December 9, 2002 at 8:20 am
There is no UI for changing passwords in SS2K. Generally, SS users are not allowed to change their own passwords. If you are using Windows security (ie. your NT ID to access SQL Server), then the you are prompted by NT to change your password.
December 9, 2002 at 8:49 am
I've always thought you could build a process. The process would read the syslogins table and use either the password field or the updatedate fields or both, and store these in a table. Anytime the password changed you would set a date in the table, so you knew when the password was changed. Daily you would run a process that would review when the password was last changed. If the password was change less than 50 days ago, you do nothing, but if the password was changed greater than 50 days ago, then you would send an email to the user telling them to change their password. In the email you would point to a webpage (you developed) that would allow them to change their password. If after say after 75 days they have not changed their password, then the process would change their password, basically cutting off their access. When they can't get it they call and you reset there password. Maybe not the best but a method to force a password change. But it would work, and will also require you to do more work!
Better yet implement Windows Authentication.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply