Procedure
- To open Command Prompt with administrative access rights, click Start, type cmd, right-click the Command Prompt search result, and then click Run as administrator.
-
In the Command Prompt
window, type sqlcmd, and then press
Enter.
The sqlcmd software starts and displays the following command prompt: 1>
-
Type the following commands. Press Enter after each command, and
replace newpassword with the new
password.
Note: To comply with the SQL Server complex password policy, choose a new password that is at least eight characters long and contains characters from three of the following categories: uppercase letters A to Z, lowercase letters a to z, numbers 0 to 9, and non-alphanumeric characters. However, do not use the following characters: &, <, >, or /.
- sp_password @new = 'newpassword', @loginame = 'sa'
- go
- exit