Here’s a neat thing to remember if you’re using MSSQL:
To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:
sp_password @new = 'new_password', @loginame = 'sa'
After that go to section Security –> Logins –> double click “sa” or choose properties. Go to “Status” and check to see if “Login:” is enabled. If not, enable it.
3 Responses
Forgot [b] MS SQL Server Sa password[/b]? A few days ago, I set a sa password on the MS SQL Server database, but I did stupid thing and forgot the password. Fortunately, my friend told me to download MS SQL Server Password Unlocker from https://www.passwordunlocker.com/sql-server-password-unlocker.com. This program helps to reset sa password instantly. It is really fabulous.
The link should be https://www.passwordunlocker.com/sql-server-password-unlocker.html
Forgot MS SQL Server Sa password? A few days ago, I set a sa password on the MS SQL Server database, but I did stupid thing and forgot the password. Fortunately, my friend told me to download MS SQL Server Password Unlocker from https://www.passwordunlocker.com/sql-server-password-unlocker.com. This program helps to reset sa password instantly. It is really fabulous.
~~~~~~~~~~~sorry! I have made a mistake on the first comment
Comments are closed.