Also, When your SQL Server occasion is functioning in mixed authentication method and you want to reset the password of an enabled sa account. Change the password of your sa account with the following syntax. Be sure you swap with a robust password of your alternative:Disabled logins retain their permissions and can however be impersonated.The sa a