停止服务后以管理员身份启动服务。(https://docs.microsoft.com/zh-cn/sql/database-engine/configure-windows/start-sql-server-in-single-user-mode?view=sql-server-2017)
C:\Windows\system32>net start MSSQLSERVER /m
添加登录账号并授权
C:\Windows\system32>sqlcmd
1> create login sa with password='yourpassword'
2> go
1> sp_addsrvrolemember 'sa','sysadmin'
2> go
转载于:https://my.oschina.net/cdt/blog/3031239