{"id":905,"date":"2012-08-05T07:58:10","date_gmt":"2012-08-05T07:58:10","guid":{"rendered":"http:\/\/www.top-password.com\/blog\/?p=905"},"modified":"2012-08-05T08:00:20","modified_gmt":"2012-08-05T08:00:20","slug":"how-to-reset-sql-server-sa-password-if-you-forgot-it","status":"publish","type":"post","link":"https:\/\/www.top-password.com\/blog\/how-to-reset-sql-server-sa-password-if-you-forgot-it\/","title":{"rendered":"How to Reset SQL Server SA Password if You Forgot it"},"content":{"rendered":"<blockquote><p>I have a local install of SQL Server Express that I haven&#8217;t touched in months. Now I need to use it, and I&#8217;ve forgotten the SA password. I have tried using SQL Server Management Studio, I have done Single User Mode with SQL Server and used sqlcmd, they all tell me I don&#8217;t have permissions for it. I&#8217;m afraid that even reinstalling SQL Server Express isn&#8217;t going to fix this for me. Does anyone know of any other method to reset the SA password?<\/p><\/blockquote>\n<p>Forgot the password of SA account on your SQL Server? You may lost the SA password on a machine, and when you log in to the machine directly using an account in the admin group, SQL Server Management Studio still doesn&#8217;t allow you to log in using Windows authentication. So how to reset forgotten SA password if you can&#8217;t connect via Windows Authentication?<\/p>\n<p>In this tutorial we&#8217;ll show you an easy way to <a href=\"http:\/\/www.top-password.com\/knowledge\/reset-sa-password-on-sql-server.html\">reset SQL Server SA password<\/a> with SQL Server Password Changer, if you forgot the password and can&#8217;t connect to your SQL Server database. The password resetting procedure is simple and you can reset SA password in just a few mouse clicks!<\/p>\n<p><strong>How to Reset SQL Server SA Password if You Forgot it:<\/strong><\/p>\n<ol>\n<li>Download <a href=\"http:\/\/www.top-password.com\/sql-server-password-recovery.html\">SQL Server Password Changer<\/a> on your local PC, install and launch it.<\/li>\n<li>Click the <strong>Open File<\/strong> button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Data.<img decoding=\"async\" src=\"https:\/\/www.top-password.com\/images\/open_sqlserver.png\" alt=\"Select the SQL Server master database file\" \/><\/li>\n<li>The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click the <strong>Change Password<\/strong> button. Type a new password and click <strong>OK<\/strong>.<img decoding=\"async\" src=\"https:\/\/www.top-password.com\/images\/sqlserver_pwd.png\" alt=\"SQL Server Password Recovery\" \/><\/li>\n<li>The old password will be replaced with your new password. Now you are able to log into the SA account using your new password.<\/li>\n<\/ol>\n<p>Now you&#8217;ve completed the task of resetting SQL Server SA password. No need to worry about forgetting SA password! With <a href=\"http:\/\/www.top-password.com\/sql-server-password-recovery.html\">SQL Server Password Changer<\/a> you can reset SQL Server SA password quickly and easily.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>I have a local install of SQL Server Express that I haven&#8217;t touched in months. Now I need to use it, and I&#8217;ve forgotten the SA password. I have tried using SQL Server Management Studio, I have done Single User Mode with SQL Server and used sqlcmd, they all tell me I don&#8217;t have permissions [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,10],"tags":[377,376,187,375],"class_list":["post-905","post","type-post","status-publish","format-standard","hentry","category-others","category-tips-tricks","tag-forgot-sql-server-sa-password","tag-reset-sa-password-on-sql-server","tag-reset-sql-server-password","tag-reset-sql-server-sa-password"],"_links":{"self":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/comments?post=905"}],"version-history":[{"count":4,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/905\/revisions"}],"predecessor-version":[{"id":909,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/905\/revisions\/909"}],"wp:attachment":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/media?parent=905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/categories?post=905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/tags?post=905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}