March 5, 2002 at 10:45 am
Does anybody know/have/etc./ a method or routine that would force an SQL password to change on a timely basis? The current SQL password stays that way until I change it.
March 5, 2002 at 10:54 am
No there really isn't a way to directly do this. You could however keep a table of password change dates and catch people thru your apps. But if they used sp_password would never see it and most standard apps would not use your process. You could also write a process to look at updatedate in the syslogins table of master db to see when the last accoutn change took place to send a reminder, but this changes not only with password changes but any other account changes so is not really reliable unless you know only the password would be changed and account changes would be minimal or none.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
March 5, 2002 at 11:23 am
No way to force this. Another argument for NT Authentication. Otherwise you'd have to write some process as suggested above.
Steve Jones
March 5, 2002 at 12:24 pm
Probably easier to make a table that contains login name and password along with a date stamp, then run an update once a day that joins on name/password to identify any that have changed and update the status date, followed by a step that would change the password for any login over x days old. Probably have to identify "system" logins that are embedded and probably dont need/want to change.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply