| Title: | SQL/Services Forum |
| Notice: | kits(3) ft info(7) QAR access (8) SPR access (10) |
| Moderator: | SQLSRV::MAVRIS |
| Created: | Thu Oct 13 1988 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 2214 |
| Total number of notes: | 8586 |
Hi, Sqlsrv 6.1-02 I've got SQLSRV$CHECK_EXPIRED_PASSWORDS defined to Y. A user with password set in authorize to /NOpwdlifetime can log into to the server via set host, but coming in via sql services gets -SQLSRV-E-PWDEXPIRED, Access denied; password has expired in the server log file. Same thing happens with sql/srv 6.0-0. removing the /NOpwdlifetime to /pwdlifetime="something" and all is well. Is PWDEXPIRED planned behavior for /NOpwdlifetime? thanks, Jerry
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 2146.1 | CHSR36::JSUBRI | Focus on Open/Rdb++ | Fri Feb 21 1997 02:31 | 4 | |
Jerry,
Bug382018 (which is not a bug) may help you.
/Jean-Luc
| |||||
| 2146.2 | M5::JHAYTER | Fri Feb 21 1997 09:48 | 16 | ||
> Bug382018 (which is not a bug) may help you. thanks, saw that and I don't think it applies. I havn't a clue how sql/srv and/or vms checks if the pswd is expired. However, with /noPWDLIFETIME specified that is supposed to mean the pswd NEVER expires. But then, there is no date/time to add to the time the pswd was last changed to see if it has expired, so by default last_changed + 0 less than current date so must be expired. But some bit must be set to indicate PWDLIFETIME = infinity?? so the pswd never expires. so back to the question: if /noPWDLIFETIME is specified then sql/srv thinks the pswd IS expired when in reality it is not. I haven't found any doc mentioning the setting of /noPWDLIFETIME. Jerry | |||||
| 2146.3 | M5::JHAYTER | Fri Feb 21 1997 12:54 | 3 | ||
FWIW: finally got around to testing sqs 7.0 and the problem (feature) does not occur there. | |||||
| 2146.4 | fixed in 7.0 | SQLSRV::MAVRIS | Sue Mavris - [email protected] | Fri Mar 07 1997 16:41 | 7 |
Hi Jerry, There are *so* many things to check for when checking for expired passwords... it's unbelievable!! We missed this one in 6.1 and earlier. Version 7.0 does check the /nopwdlifetime flag. Sue | |||||