How To Rest the SA Password of the SQL Server

preview_player
Показать описание
Steps:To Reset the SA Password for Default Instance
1.Net stop Mssqlsever
2.Net start MSQLSERVER /m"SQLCMD"
3.SQLCMD
4.Create login loginname with password = 'urpassword'
go
5.Sp_addsrvrolemember loginname , 'SYSADMIN'
Go
=====================

All the Best.
Рекомендации по теме
Комментарии
Автор

It’s not work for me can you help me please what is shift press go that means shift enter and type go and than press control enter ?

samsamp
Автор

hi...can you tell me how to use smd in sql server 2019

Anjali-zhdn
Автор

Does this work with SQLserver express 2014?

KJC
Автор

it work at first thanks

note some people might have problems with the name of the sql isntance so when starting on stopping service use like this net stop MSSQL$SQLEXPRESS our net start MSSQL$SQLEXPRESS /m"SQLCMD

AndreTVOC