SQL Server forgot to sign in account solution

"1" stops the SQL Server service and the SQL Server Agent service

"2" opens the command line as an administrator, starting the service in single-user mode.
(starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to an instance of SQL Server as a member of the sysadmin fixed server role)
c:\windows\system32>net start mssqlserver/m
The SQL Server (MSSQLSERVER) service is starting.
The SQL Server (MSSQLSERVER) service has started successfully.


"3" Add login account and authorize. (or simply open SSMs login, modify or add a new account)
c:\windows\system32>sqlcmd
1> Create login kk with password= ' [email protected] '
2> Go
1> sp_addsrvrolemember ' kk ', ' sysadmin '
2> Go
1>


Restart SQL Server service when "4" is complete

SQL Server forgot to sign in account solution