Skip to Content

登陆/注册

如何在SQL服务器上重置SA密码

下载PDF文件

下载PDF文件

SA用户（“系统管理员”的简称）是MS SQL服务器的管理者账户。如果忘记服务器管理员账户的密码该怎么办呢？难道要重新安装SQL服务器或放弃所有数据内容吗？不管出于何种原因，如果你忘记了服务器的管理账户密码，并且被告知你无权进行更改，这篇文章将教给你几种重置SQL服务器SA密码的方法。

这些步骤适用于2005、2008、2012及更新的SQL服务器。

方法 1

方法 1 的 4:

方法1：从命令提示符中更改SA密码

下载PDF文件

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/16\/Reset-SA-Password-in-Sql-Server-Step-1-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/16\/Reset-SA-Password-in-Sql-Server-Step-1-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-1-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/29\/Reset-SA-Password-in-Sql-Server-Step-2-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/29\/Reset-SA-Password-in-Sql-Server-Step-2-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-2-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/53\/Reset-SA-Password-in-Sql-Server-Step-3-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/53\/Reset-SA-Password-in-Sql-Server-Step-3-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/41\/Reset-SA-Password-in-Sql-Server-Step-4-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/41\/Reset-SA-Password-in-Sql-Server-Step-4-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-4-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

广告

方法 2

方法 2 的 4:

方法2：使用SSMS重置SA密码

下载PDF文件

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/8b\/Reset-SA-Password-in-Sql-Server-Step-5-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8b\/Reset-SA-Password-in-Sql-Server-Step-5-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

它通常位于开始菜单 -> 所有程序 -> “Microsoft SQL Server 2005” -> 找到“SQL Server Management Studio”程序。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9c\/Reset-SA-Password-in-Sql-Server-Step-6-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-6-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9c\/Reset-SA-Password-in-Sql-Server-Step-6-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/1\/1d\/Reset-SA-Password-in-Sql-Server-Step-7-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1d\/Reset-SA-Password-in-Sql-Server-Step-7-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

右键点击它，选择属性。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f5\/Reset-SA-Password-in-Sql-Server-Step-8-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/Reset-SA-Password-in-Sql-Server-Step-8-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

广告

方法 3

方法 3 的 4:

方法3：使用SQL密码恢复工具重置SA密码

下载PDF文件

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/2\/22\/Reset-SA-Password-in-Sql-Server-Step-9-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/22\/Reset-SA-Password-in-Sql-Server-Step-9-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e4\/Reset-SA-Password-in-Sql-Server-Step-10-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e4\/Reset-SA-Password-in-Sql-Server-Step-10-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

点击“更改密码”来重置密码。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/cb\/Reset-SA-Password-in-Sql-Server-Step-11-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cb\/Reset-SA-Password-in-Sql-Server-Step-11-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

广告

方法 4

方法 4 的 4:

方法4：当SA已被禁用时

下载PDF文件

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/be\/Reset-SA-Password-in-Sql-Server-Step-12-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/be\/Reset-SA-Password-in-Sql-Server-Step-12-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

有时候你会遇到SA被禁用的情况。
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/05\/Reset-SA-Password-in-Sql-Server-Step-13-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/05\/Reset-SA-Password-in-Sql-Server-Step-13-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/ec\/Reset-SA-Password-in-Sql-Server-Step-14-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ec\/Reset-SA-Password-in-Sql-Server-Step-14-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/55\/Reset-SA-Password-in-Sql-Server-Step-15-Version-2.jpg\/v4-460px-Reset-SA-Password-in-Sql-Server-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/55\/Reset-SA-Password-in-Sql-Server-Step-15-Version-2.jpg\/v4-728px-Reset-SA-Password-in-Sql-Server-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

广告

小提示

重置SA密码最简单有效的方法是使用SQL密码恢复工具。你可以使用几种SQL密码恢复工具来成功 重置SQL的SA密码。如，“SQL Password Geeker”程序、“SQL Password Rescuer”程序。

广告

你可能还喜欢

广告

关于本wikiHow

wikiHow是一个“多人协作写作系统”，因此我们的很多文章都是由多位作者共同创作的。为了创作这篇文章，14位用户（部分匿名）多次对文章进行了编辑和改进。这篇文章已经被读过28,380次。

分类: 计算机与电子产品 | 软件

印度尼西亚语

打印

本页面已经被访问过28,380次。

这篇文章对你有帮助吗？

广告

-

-

352

.mwimg a.image{display:none}#header_logo{display:none}#cse-search-box{display:none}#cse-search-box-noscript{display:block !important}#cse-search-box-noscript .cse_q{color:#FFF;background-color:#B3CE9C}.wh_search .cse_q{width:88%}#mw-mf-main-menu-button{display:none;visibility:hidden}.header .search{display:none}#search_footer .cse_sa{background-image:url(/extensions/wikihow/mobile/images/white_mag.png);background-size:22px}.related_box{display:block;background:#EEE;border:5px solid #FFF;vertical-align:bottom;width:127px;background-size:180px;float:left;height:120px;position:relative}.related_box p{line-height:15px !important;font-size:13px;background-color:rgba(67,95,44,.4);color:#FFF;font-weight:bold;padding:8px;margin:0 !important;position:absolute;bottom:0}#noscript_header_logo{display:table-cell;vertical-align:middle;background-position:50% 77%;background-repeat:no-repeat;background-image:url(/extensions/wikihow/mobile/images/wikihow_logo_230.png);background-size:105px;width:auto;height:51px;padding:0 14px}.articleinfo{display:none}#iorg_free_data{z-index:50;width:100%;position:fixed}#ara_recommendations{display:none}

Design a Mobile Website

View Site in Mobile | Classic

Share by: