hi all,Today, since morning our team was on SQL Server 2000 and 2005. We had many task in our hand. We had to handle back and restore of databases and many other stuffs.
And in between one of my friend, lost his
sa userid's password. And due to which he could not log in to his SQL Server. And at that point we really had bad time. He tried entering some password. But that didnt work at all.
Meanwhile, I was just trying to open SQL Server from windows authentication mode. Screenshot is shown below.
So above screenshot shows the SQL Authentication mode. and user id is
sa. But now change the Authentication to windows authentication mode. It did not ask me for the user id and password. and i could log in to the SQL Server.
So switch to Windows Authentication mode. Then it will not ask for the password and user id. It will automatically take it to the SQL server. Which is shown in image below.
Once it is done, what u can do is, just go to security login. and open property of sa login. In the property window change the password. And click on the OK button.
This way you can change the old or lost password.
Send me the reply.