Posted by Erland Sommarskog on 10/01/13 11:19

mbailey (matt.bailey@gmail.com) writes:
> 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?

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@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Sorting - character after 'Z'?
• Prev in forum: Re: bulk copy error: Received invalid row length x from bcp client. Minimum row size is y
• Thread view: Re: Sql Server Password Expiration?

[Reply to this message]