Recover Your SQL Server sa Password

If you cannot access your Microsoft SQL Server because you do not have the sa password, this will help you.
Commands from this video:
NET STOP MSSQLSERVER
NET START MSSQLSERVER -m
SQLCMD
CREATE LOGIN admin WITH PASSWORD = 'password1234*'
go
SP_ADDSRVROLEMEMBER admin, 'SYSADMIN'
go
ALTER SERVER ROLE SYSAMDIN ADD MEMBER admin
go
NET STOP MSSQLSERVER
NET START MSSQLSERVER
How to support my channel
0 - SHARE THE VIDEO!
1 - Like videos
2 - Subscribe to my channel
3 - www.tomstechsh...
4 - Twitter / toms_tech_show
5 - Facebook tomstech...
Code repository
bitbucket.org/...
My photo site
www.thomasnelso...

[@timwitort6013]

Clearest walkthrough I've seen on recovering and updating the sa password. Well done.

[@sonegury445]

"I just hacked sql" thanks. We fell into a 'IT guy got hit by bus' scenario and SA password was nowhere to be found. cheers.

[@DeridderEvelien]

your a life saver thx it works

[@ESAMALMITHALI]

Thanks , it's Helpful

[@jamesramos1211]

when running sqlcmd I get this error.... sqlcmd: error: microsoft odbc driver 17 for sql server : login failed for user

[@jyothistjohn3240]

please help, "CREATE LOGIN" i got this error msg 15247 level 16 state 1 line 1 user does not have permission to perform this action. Can you help me?

[@crjason09]

Hello, after using the command "CREATE LOGIN" i got this error msg 15247 level 16 state 1 line 1 user does not have permission to perform this action. Can you help me?

[@jyothistjohn3240]

same message, i also got. My scneario is sa(admin) is locked out, I'm trying to restore it.

[@chattoronkaadda4342]

Hi sir, can you tell me sql 2012 server sa default password???