469,946 Members | 1,787 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

Can't log in as sa

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?

Bill E.
Hollywood, FL

Sep 11 '07 #1
5 2548
"Bill E." <bi********@netscape.netwrote in message
news:11**********************@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
Sep 11 '07 #2
Thanks Greg.

This SQL Server is behind the firewall--not available outside the
corporate network. However, when I get a chance I'll follow your
suggestion.

Bill

Sep 11 '07 #3
"Bill E." <bi********@netscape.netwrote in message
news:11**********************@k79g2000hse.googlegr oups.com...
Thanks Greg.

This SQL Server is behind the firewall--not available outside the
corporate network. However, when I get a chance I'll follow your
suggestion.
It's probably an innocent screw up then.

But you never know. (Besides, not all hackers come from outside a company
unfortunately.)

Bill


--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Sep 11 '07 #4
If the server authentication mode was changed to Windows
Authentication only sa would no longer work.

Roy Harvey
Beacon Falls, CT

On Tue, 11 Sep 2007 02:42:39 -0700, "Bill E."
<bi********@netscape.netwrote:
>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?

Bill E.
Hollywood, FL
Sep 11 '07 #5
No, it's still set to mixed mode and I'm using other logins for
applications.

Bill

Sep 11 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

50 posts views Thread by dataangel | last post: by
1 post views Thread by ivan divandelen | last post: by
3 posts views Thread by Rajesh Garg | last post: by
8 posts views Thread by W.Davis | last post: by
4 posts views Thread by Ellen K. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.