{"id":69302,"date":"2024-07-28T11:02:00","date_gmt":"2024-07-28T03:02:00","guid":{"rendered":"http:\/\/www.xiaoyebailong.com\/?p=69302"},"modified":"2024-12-05T11:05:30","modified_gmt":"2024-12-05T03:05:30","slug":"sa%e7%94%a8%e6%88%b7%e8%a2%ab%e9%94%81%e5%ae%9a%e6%88%90%e7%81%b0%e8%89%b2%e7%8a%b6%e6%80%81","status":"publish","type":"post","link":"http:\/\/www.xiaoyebailong.com\/index.php\/2024\/07\/28\/69302.htm","title":{"rendered":"sa\u7528\u6237\u88ab\u9501\u5b9a,\u6210\u7070\u8272\u72b6\u6001"},"content":{"rendered":"\n<p>\u539f\u56e0\u5206\u6790\u53ca\u89e3\u51b3\u529e\u6cd5\uff1a<br>1\u3001\u5982\u679c\u77ed\u65f6\u95f4\u5185\u4e0d\u505c\u8fde\u63a5\uff0c\u5c31\u4f1a\u88abSQL SERVER\u8bef\u8ba4\u4e3a\u662f\u8fd9\u662f\u653b\u51fb\uff0c\u4f1a\u81ea\u52a8\u5c06\u6b64\u8d26\u53f7\u9501\u5b9a\u3002<\/p>\n\n\n\n<p>SqlServer\u81ea\u52a8\u9501\u5b9asa\u7684\u89e3\u51b3\u4ee3\u7801\u3002<\/p>\n\n\n\n<p>\u8981\u7528windows\u8eab\u4efd\u9a8c\u8bc1\u767b\u5f55\uff0c\u5728\u67e5\u8be2\u5206\u6790\u5668\u91cc\u8f93\u5165<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\u65b9\u6cd5\u4e00\uff1a\u91cd\u7f6esa\u7684\u5bc6\u7801\uff1a<\/p>\n<\/blockquote>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>ALTER LOGIN \u7528\u6237\u540d ENABLE ;GOALTER LOGIN \u7528\u6237\u540d WITH PASSWORD = 'password' unlock, check_policy = off,check_expiration = off ;GO<\/code><img decoding=\"async\" width=\"16\" src=\"https:\/\/static.ilingban.com\/extension\/standalone\/assets\/logo-Db92ZgZM.png\">\u4ee3\u7801\u89e3\u91ca<\/pre>\n\n\n\n<p>\u6216\u8005\u7528windows\u8eab\u4efd\u9a8c\u8bc1\u767b\u5f55\u540e\uff0c\u6570\u636e\u5e93-&gt;\u5b89\u5168\u6027-&gt;sa\u8d26\u53f7\u53f3\u952e\u5c5e\u6027\uff1a\u5728\u72b6\u6001 \u9009\u9879\u5361\u4e2d\u627e\u5230sql server \u8eab\u4efd\u9a8c\u8bc1 \uff0c\u663e\u793a\u201c\u767b\u5f55\u5df2\u9501\u5b9a\u201d\uff1b\u628a\u8fd9\u4e2a\u52fe\u9009\u53bb\u6389\uff0c\u7136\u540e\u63d0\u793a\u5fc5\u987b\u4fee\u6539\u5bc6\u7801\u3002<br><img decoding=\"async\" src=\"https:\/\/img2020.cnblogs.com\/blog\/98475\/202009\/98475-20200930083708787-1016695851.png\" alt=\"\u56fe\u72471\"><br>2\u3001\u8fd9\u6837\u5c31\u5c06\u5bc6\u7801\u7f6e\u7a7a\uff0c\u7136\u540e\u518d\u91cd\u542f\u767b\u5f55\u3002\uff08\u65b9\u6cd5\u4e8c\uff1aSqlServer\u81ea\u52a8\u9501\u5b9asa\u8d26\u53f7\u4fdd\u7559\u539fsa\u5bc6\u7801\uff09<\/p>\n\n\n\n<p>SqlServer\u81ea\u52a8\u9501\u5b9asa\u8d26\u53f7\u4fdd\u7559\u539fsa\u5bc6\u7801\uff1a<\/p>\n\n\n\n<p>\u7528Windows\u8eab\u4efd\u767b\u5f55SQLServer\u7684SSMS\u540e\uff0c\u3010\u5b89\u5168\u6027\u3011\u2014\u2014\u3010\u767b\u5f55\u540d\u3011\u2014\u2014\u3010sa\u3011<\/p>\n\n\n\n<p>\u5728\u3010sa\u3011\u4e0a\u70b9\u53f3\u952e&#8211;\u5c5e\u6027\uff1a<\/p>\n\n\n\n<p>\u5728\u6253\u5f00\u7684\u3010\u767b\u5f55\u540d\u5c5e\u6027-sa\u3011\u5bf9\u8bdd\u6846\u4e2d\uff0c\u5728\u201c\u5e38\u89c4\u201d\u9009\u9879\u5361\u4e2d\uff0c\u53d6\u6d88\u52fe\u9009\u201c\u5f3a\u5236\u5b9e\u65bd\u5bc6\u7801\u7b56\u7565(F)\u201d,\u786e\u5b9a\u3002\u91cd\u542fSqlServer\u670d\u52a1\u5668\u540e\uff0c\u539f\u6765\u7684\u5bc6\u7801\u5c31\u53ef\u4ee5\u6b63\u5e38\u4f7f\u7528\u4e86\u3002<\/p>\n\n\n\n<p>\u4ee5\u540e\u518d\u4e5f\u4e0d\u4f1a\u51fa\u73b0\u81ea\u52a8\u9501\u5b9asa\u5bc6\u7801\u7684\u95ee\u9898\u4e86\u3002<br><img decoding=\"async\" src=\"https:\/\/img2020.cnblogs.com\/blog\/98475\/202009\/98475-20200930081555290-1075139819.png\" alt=\"\u56fe\u72472\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u539f\u56e0\u5206\u6790\u53ca\u89e3\u51b3\u529e\u6cd5\uff1a1\u3001\u5982\u679c\u77ed\u65f6\u95f4\u5185\u4e0d\u505c\u8fde\u63a5\uff0c\u5c31\u4f1a\u88abSQL SERVER\u8bef\u8ba4\u4e3a\u662f\u8fd9\u662f\u653b\u51fb\uff0c\u4f1a\u81ea\u52a8\u5c06\u6b64\u8d26\u53f7\u9501\u5b9a\u3002 SqlServer\u81ea\u52a8\u9501\u5b9asa\u7684\u89e3\u51b3\u4ee3\u7801\u3002 \u8981\u7528windows\u8eab\u4efd\u9a8c\u8bc1\u767b\u5f55\uff0c\u5728\u67e5\u8be2\u5206\u6790\u5668\u91cc\u8f93\u5165 \u65b9\u6cd5\u4e00\uff1a\u91cd\u7f6esa\u7684\u5bc6\u7801\uff1a ALT&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[106,646,645],"topic":[],"class_list":["post-69302","post","type-post","status-publish","format-standard","hentry","category-server","tag-sql","tag-646","tag-645"],"_links":{"self":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/69302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/comments?post=69302"}],"version-history":[{"count":1,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/69302\/revisions"}],"predecessor-version":[{"id":69303,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/posts\/69302\/revisions\/69303"}],"wp:attachment":[{"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/media?parent=69302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/categories?post=69302"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/tags?post=69302"},{"taxonomy":"topic","embeddable":true,"href":"http:\/\/www.xiaoyebailong.com\/index.php\/wp-json\/wp\/v2\/topic?post=69302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}