How do I reset the SQL Server ‘sa’ user password?
Open Enterprise Manager and expand the registered SQL server.
Expand Security.
Click on Logins.
Right-click the user "sa" and select Properties.
Type the new password in the Password field.
Click OK, and you will be prompted to re-type the password.
|