If you forget the sa password many articles give you advice of how to login to Management Studio and change the sa password. But what if you've inherited someone else's developer PC and you don't have access to Management Studio using your Windows credentials?
There is a way to do it using the command line.
Stop the SQL Server instance
net stop MSSQLSERVER
Start the instance
net start MSSQLSERVER /mSQLCMD
Go in single user mode
sqlcmd -S. -E
1> sp_password @new='<pwd>', @loginame='sa'
2> go
You can also add the user
sp_addsrvrolemember '<domain>\<user>', 'sysadmin'
No comments:
Post a Comment