{"id":598,"date":"2012-06-25T07:02:04","date_gmt":"2012-06-25T07:02:04","guid":{"rendered":"http:\/\/www.top-password.com\/blog\/?p=598"},"modified":"2012-06-25T07:06:04","modified_gmt":"2012-06-25T07:06:04","slug":"how-to-change-sql-server-password","status":"publish","type":"post","link":"https:\/\/www.top-password.com\/blog\/how-to-change-sql-server-password\/","title":{"rendered":"How to Change SQL Server Password"},"content":{"rendered":"<p>Forgot SQL Server password? A former employee forgot to leave you with the sa password for your SQL Server? \u00a0How to change the password or reset it? If you couldn&#8217;t fix this problem, you may have to reinstall SQL Server. \u00a0But if you have some very important data in the database, this may prevent you from reinstalling. Then, is there any effective way to recover or <a href=\"http:\/\/www.top-password.com\/knowledge\/change-sql-server-password.html\">change SQL Server password<\/a>?<\/p>\n<p>This tutorial will explain how to change SQL Server password with <a href=\"http:\/\/www.top-password.com\/sql-server-password-recovery.html\">SQL Server Password Changer<\/a>, if you forgot sa password and can&#8217;t connect to your database using any user account. Once SQL Server is installed, a master.mdf file will be created and be used to stored the logins and passwords for all available SQL Server accounts. With <a href=\"http:\/\/www.top-password.com\/sql-server-password-recovery.html\">SQL Server Password Changer<\/a> you can easily change forgotten SQL Server passwords stored in the master.mdf database.<\/p>\n<p><strong>How to Change SQL Server Password:<\/strong><\/p>\n<ol>\n<li>Download\u00a0<a href=\"http:\/\/www.top-password.com\/sql-server-password-recovery.html\">SQL Server Password Changer<\/a>\u00a0on your local PC, install and launch it.<\/li>\n<li>Click the\u00a0<strong>Open File<\/strong>\u00a0button. 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\u00a0<strong>Change Password<\/strong>\u00a0button. Type a new password and click\u00a0<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>Follow the steps above you can also change other user account passwords. \u00a0SQL Server Password Changer is a really useful utility and it can help you easily reset SQL Server passwords on SQL Server 2008\/2005\/2000.<\/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>Forgot SQL Server password? A former employee forgot to leave you with the sa password for your SQL Server? \u00a0How to change the password or reset it? If you couldn&#8217;t fix this problem, you may have to reinstall SQL Server. \u00a0But if you have some very important data in the database, this may prevent you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,10],"tags":[189,190,188,187],"class_list":["post-598","post","type-post","status-publish","format-standard","hentry","category-sql-server","category-tips-tricks","tag-change-sql-server-password","tag-change-sql-server-sa-password","tag-forgot-sql-server-password","tag-reset-sql-server-password"],"_links":{"self":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/598","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=598"}],"version-history":[{"count":3,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/598\/revisions"}],"predecessor-version":[{"id":600,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/posts\/598\/revisions\/600"}],"wp:attachment":[{"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/media?parent=598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/categories?post=598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.top-password.com\/blog\/wp-json\/wp\/v2\/tags?post=598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}