Sql Server Password Expiration?

[mbailey]

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

[Simon Hayes]

Re: Sql Server Password Expiration?


"mbailey" <matt.bailey@gm ail.com> wrote in message
news:1119471139 .532067.262100@ g44g2000cwa.goo glegroups.com.. .[color=blue]
> 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
>[/color]

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

[Erland Sommarskog]

Re: Sql Server Password Expiration?

mbailey (matt.bailey@gm ail.com) writes:[color=blue]
> 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?[/color]

You find that other person who is changing the passwords and slap
him on the fingers.

That is, there is no password expiration in SQL 2000. (There is in
SQL 2005, if you run on Windows 2003, although I think it is off
by default.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[mbailey]

Re: Sql Server Password Expiration?

Simon and Erland, thank you for your replies.

What's happening is this.
I have SQL Server on a remote hosting companies box.
Over the past two weeks when I try to connect to the database, I am
denied based on username and password.
I then remote into the box, set the password back to my "original"
setting and then can connect as normal.

The only thing that Ive noticed is that there had been a server reboot
right aroudn the time of the second sql outage.

MB

[Erland Sommarskog]

Re: Sql Server Password Expiration?

mbailey (matt.bailey@gm ail.com) writes:[color=blue]
> What's happening is this.
> I have SQL Server on a remote hosting companies box.
> Over the past two weeks when I try to connect to the database, I am
> denied based on username and password.
> I then remote into the box, set the password back to my "original"
> setting and then can connect as normal.
>
> The only thing that Ive noticed is that there had been a server reboot
> right aroudn the time of the second sql outage.[/color]

Seems like you should have a discussion with the hosting company.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp