Did you lost your SA password? Do yo need to do some actions in your SQL server?
If the answer is yes, this post is for you. Following this procedure, will be very easy to change the SA password from the SQL. This steps works for SQL 2005, 2008, 2008R2, 2012 and 2012R2. The only requirement, is that you’ll need to be an OS administrator.
First of all, open a CMD window as administrator
Execute osql -L which will show all the SQL servers in the domain
Choose the SQL Server that you want to change the password, and execute the following command: osql -S ServerName -E
sp_password NULL, NewSAPassWord, ‘sa’
And you’re ready to go!!