SQL SERVER 2005 ( sa login disable automatically )

Question

in sql server 2005 enviroment " sa login disable automatically "
why this happen ??

once i connect with windows aunthication mode then enable sa account so that it will allow through sa account ,
again disconnect with sql server 2005 after that when i connect with sa accout it give error like "SA ACCOUT IS DISABLE"
please look into this.........

---

india

Answer 1

Try couple of following things :

1) Unlock account:
ALTER LOGIN sa WITH PASSWORD = 'new_password' UNLOCK

2) Change Login Mode to Mixed mode via registry:

Default instance:
"HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode"

1 for integrated
2 for mixed-mode

Best Regards,
Pinal

---

Pinal Dave
Founder - http://blog.sqlauthority.com
Search SQL Solutions

Answer 2

There may be hacking attempts as well on your server which might be automatically disabling the account.


Best Regards,
Pinal

---

Pinal Dave
Founder - http://blog.sqlauthority.com
Search SQL Solutions

Answer 3

I have already tried above 2 solution but it's not working........

it's working for 1 time login only.......

next time again disable..........

---

india

Answer 4

in my enviroment if u enter 3 times wrong password it lock for next 15 day's............

any other reason ........

---

india

Answer 5

That is what is happening. Some one might be attaching using Brute Force and it is disabled.

If that is not the case, you can lower your security by unchecking "Enforce Password Policy" and it should fix the problem.

Regards,
Pinal

---

Pinal Dave
Founder - http://blog.sqlauthority.com
Search SQL Solutions

Answer 6

still i am facing same problem ....
sa account automatic disable........
every time i log-in with window Ath mode & select sa then enable .......when i log-in second day ..againg sa account disable..........

plz suggest me..........................

after enableing sa account it's compulsory to restart SQL Service....

---

india

Answer 7

I would very strongly suggest renaming the sa account.  That will stop anyone trying a brute force attack on it.

---

Mike Hotek BlowFrog Software, Inc. http://www.BlowFrogSoftware.com Affordable database tools for SQL Server professionals

Answer 8

i can't rename account bec it's using by approx 10 DBA with different palces......

my question why this happen only in few servers 3-4 only?

---

india