How to reset SQL password, when I forgot SQL password?

Have you ever forgot or lost your SQL password? Did you have any ideals to reset SQL password? Or chosen to reinstall MS SQL Server on your PC again? I once forgot my SQL password and I reinstalled SQL Server at last, because I failed to find some good methods to solve the problem. What annoying and terrible experience it is! In order to avoid reinstalling SQL Server for a second time, I collect some methods to reset sa Password in sql for sa account. Method 1: Use the Query Windows in Management Studio to reset sql sa password 1. … Continue reading

2 Effective Ways to Reset SQL Server SA Password

About system administrator (SA) MS SQL Server offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode (Windows authentication and SQL Server Authentication). No matter what authentication mode you select, you should assign a strong password for the SA (system administrator) account which has full control over the database objects, including the tables, stored procedures, user permissions and backup logs etc. However, this SA password can be easily forgotten. Well, in the following I will show you how to reset SQL SA password when it is forgotten with following 2 methods: Method 1: Reset password … Continue reading