SA密码忘记

Question

版本sql server 2008 R2 express, sa密码遗忘，用windows身份验证 administrator可登录，但没有任何权限可访问数据库，是否有办法修改密码进入？

Answer 1

Did you add any other login to sysadmin role before?

Answer 2

Hi Shrekyue,

你有Windows Administrator的账号吧，如果有的话，使用Admin账户登录Windows，然后重置SQL Server的sa密码。

参考下这篇博客：https://blogs.technet.microsoft.com/sqlman/2011/06/14/tips-tricks-you-have-lost-access-to-sql-server-now-what/

Best Regards，

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

这儿有一篇中文博客，参考一下：http://blog.csdn.net/github_37517254/article/details/55049242

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

你admin账号没有数据库权限吗？