Forgot SQL Server 2008 Password, How to Reset?

Have you ever thought that once you forgot SQL Server SA password one time, what will happen then? The result can be imagined by us. Take the Microsoft SQL Server 2008 password for an example and you will learn MS SQL Server password reset here. Continue reading

Forgot SQL Server SA Password – How to Recover Forgotten SQL Password with Tool

Forgot Microsoft SQL Server password? You can read this article and see how to recover Microsoft SQL Server password with a SQL password recovery tool when you lost or forgot it in any situation. You can also see how to choose a better tool to help you. Continue reading

SQL Server Password Recovery: What to Do When You Forgot SQL Server SA Password?

This article mainly talks about how to recover Microsoft SQL Server password with a SQL password recovery tool when you forgot MS SQL Server SA password. Continue reading

SQL Password Recovery – How to Recover SQL Server Password Smoothly

How to recover SQL Server password when you can’t open your locked Microsoft SQL server database? You will find out the solutions here. Continue reading

2 Simple Methods to Change SQL Server 2008 Password for SA Account

For security reason, we need to change SA password in SQL Server. Today we are going to discuss how to change SA password in SQL 2008. Method 1: Changing SA password in SQL 2008 by using Management Studio Step1: Login into SQL Server 2008 with Windows Authentication mode. (This means you have to login in the local Windows computer of SQL Server 2008.) Step2: Now go to “Object Explorer>>Security>>Logins”. Next find sa and right click on it. Step3: Select “Properties”. And then in the newly pop-up window, enter a new password to the Password filed, and confirm password later. However, … Continue reading

My Little Tricks on How to Change Password in SQL

Yesterday I saw a question about solution to change password in SQL and now I decide to write something and share some of knowledge I know to help people change SQL server login password easily even if in the situation when the password has already been forgotten or lost. Changing SQL password cannot only well protect the databases against unauthorized access but also can help the user regain access to the databases when the password is lost. Trick 1: Change SQL login password (including SA password and other SQL user password) from Windows Authentication mode 1. Login into SQL server … Continue reading