I've installed MS SQL SERVER 2008 Standard Edition. WHat i'm facing now is the SQL SERVER will auto change my "sa" login password to soemthing else. I had put a password to "xxx", but when login to "sa" account using SQL Authentication mode, it will prompt
login failed for user "sa".
I went to the Log file and found out that the state is 8 which is password mismatch. I have no idea as i already applied all changes after setting my "sa" password and i never change after that.
So, i change to WIndow Authentication mode and login , then from there i change the "sa" password to the original value. Now i login again with the password using SQL authentication and it works.
But my question is - Why the password will auto change after sometime? does it relate to sticter security policy in SQL SERVER 2008?
View Complete Post