Home » Questions » Computers [ Ask a new question ]

How do I give myself admin rights to a sql server instance, having forgotten the sa password?

How do I give myself admin rights to a sql server instance, having forgotten the sa password?

I have lost all passwords for a SQL Server instance, how do I give myself admin access again?

Asked by: Guest | Views: 390
Total answers/comments: 2
bert [Entry]

"Run SSMS as Administrator (ie, with escalated privileges on the server). This should have sysadmin rights, and you can then find your login and assign rights as necessary.

Almost wrote ""tights"" there. You can probably assign them too, if you're running as an admin on the server."
Qvlhoo [Entry]

order lipitor 10mg without prescription <a href="https://lipiws.top/">order atorvastatin 80mg for sale</a> atorvastatin sale