"Bill E." <billmiami2@netscape.net> wrote in message
news:1189503759.466560.270090@y42g2000hsy.googlegr oups.com...
> SQL Server 2005
>
> All of a sudden we cannot log in using sa. The "enforce expiration"
> option is not set.
> How could this have happened outside of a user deliberately changing
> the password? Can sa get
> locked out for other reasons?

Not that I'm aware of.

Sounds like someone changed the sa password or you've got a bad case of
fat-fingering.

Worse case, I'd start looking for domain accounts and the like that didn't
exist before. (A typical 'first thing' a hacker would do.)


>
> Bill E.
> Hollywood, FL
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html