|
|
Posted by Simon Hayes on 10/01/70 11:19
"mbailey" <matt.bailey@gmail.com> wrote in message
news:1119471139.532067.262100@g44g2000cwa.googlegroups.com...
> This has to be a simple question for most of you, so here goes.
>
> My passwords for sa and another login that I created keep resetting.
> How can I turn off password expiration in SQL Server 2000?
>
> Thanks!
> MB
>
As far as I know, there's no standard way to reset passwords in any version
of MSSQL, because 'resetting' implies going back to a previous password, and
unless you know the previous password that shouldn't be possible. Perhaps
you can correlate the reset with an MSSQL or Windows scheduled task?
Alternatively, you could consider Windows authentication instead; that's the
MS recommendation, and it means you can use the same password policy defined
in AD.
If this isn't helpful, I suggest you give some more details about your
servicepack level, how you know that a password has been reset, how often
it's reset, if Profiler has shown any unusual activity etc.
Simon
Navigation:
[Reply to this message]
|