Forgot or lost MS SQL Server “sa” password

最新推荐文章于 2022-07-31 01:11:20 发布

原创最新推荐文章于 2022-07-31 01:11:20 发布 · 151 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL Server #SQL #Go #Windows #Security

本文介绍了一种在Microsoft SQL Server中更改丢失或遗忘的SA密码的方法。通过使用管理员帐户登录计算机并启用Windows身份验证来连接到SQL Server，然后运行SP_PASSWORD过程设置新的SA密码，并确保启用了SA登录。

By Armand Niculescu on October 18, 2006
http://www.richnetapps.com/forgot_or_lost_sql_server_sa_password_1/

Here’s a neat thing to remember if you’re using MSSQL:

To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:

SP_PASSWORD @NEW = 'new_password', @loginame = 'sa'

After that go to section Security –> Logins –> double click “sa” or choose properties. Go to “Status” and check to see if “Login:” is enabled. If not, enable it.