Recover Your SQL Server sa Password

Опубликовано: 31 Октябрь 2024
на канале: Tom's Tech Show!
8,759
99

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 - https://www.tomstechshow.com/contribute
4 - Twitter   / toms_tech_show  
5 - Facebook https://fb.me/tomstechshow

Code repository
https://bitbucket.org/tomstechshow/

My photo site
http://www.thomasnelsonphotography.com