Step 1:-
Change SQL SA password from a command prompt
Change SQL SA password from a command prompt
Go to the command prompt of the server and type in command prompt osql –L
C:\Users\Administrator>osql -L
Servers:
localhost
Step 2:-
Copy full name of SQL Server and type: OSQL -S <insert_servername_here> -E
C:\Users\Administrator>osql -S localhost -E
Step 3:-
Execute the following query: sp_password NULL, ‘<insert_new_password_here>’, ‘sa’
1> sp_password NULL, ‘,pjam#’,’sa’
2> GO
Done, the sa password has been reset.
Recent Comments