how to change sa password in microsoft sql server 2008
TRANSCRIPT
If you forget sa password and cannot login MS SQL Server 2008, or you just want to change your sa password, how to do?
Way 1: Reset password in MS SQL Server 2008
If you forget SA password, you cannot login in SQL with your SA account, but you can login with Windows. So choose Windows Authentication to connect to SQL Server is the first step.
Before you use the software, don’t forget to stop SQL Server/SQL Server Browser in
Sql Server Configuration Manager.
Before this step you can see your sa password current status is Unknown.
Step 3: Click “Reset” to reset a new password.