<\/span><\/h2>\n\n\n\nIf you have recently lost SQL Server password, instead\nof reinstalling the SQL Server, you should try a few easy manual methods to\nreset SA password in SQL Server. Microsoft SQL Server uses a smart recovery\nmethod to preserve the objects and other data in a master database file. In\ncase you do not know, SQL Server has an ability to launch in the Single-User\nmode. Using this mode, you can log into the SQL Server with sysadmin privileges\nthrough any account that is being a part of the Local Administrator\u2019s group.<\/p>\n\n\n\n
You can start SQL Server in the Single-User mode by\nusing the parameter -M<\/strong> or -F<\/strong> in the startup parameters. Remember,\nonly one user will be connected at a time while using the Single-User mode. You\nneed to use the SQLCMD commands to connect with the SQL instance and interact\nwith it from the command prompt.<\/p>\n\n\n\n<\/span>Use\nSingle-User Mode<\/span><\/h3>\n\n\n\nBefore you can use the Single-User mode, make sure the\nMicrosoft SQL Server Management System is installed on your system. Then follow\nthe steps shown below:<\/p>\n\n\n\n
Step 1:<\/strong> First, open the command\nprompt in the administrator mode.<\/p>\n\n\n\nStep 2:<\/strong> Here you need to stop the\nSQL Instance from running. To do that, type the command net stop MSSQLSERVER<\/em> and then hit\nthe Enter<\/strong> button. Doing this will\nstop the SQL services running currently.<\/p>\n\n\n\nStep 3:<\/strong> Now you need to restart SQL\nServer in the Single-User mode. To do that, type the command net start MSSQLSERVER\n\/m”SQLCMD”<\/em> and then hit the Enter button. If you do not\nsee anything, this is fine. When you are connected in the Single-User mode,\nthis is not necessary that you will see any indication. Instead, you will see\nthis \u2013 The SQL Server <MSSQLSERVER>\nservice was started successfully<\/em>.<\/p>\n\n\n\nStep 4:<\/strong> Now you need to connect to\nthe SQL Server. To do that, simply type the command sqlcmd<\/em> and then hit the Enter<\/strong> button. Doing this will open the\nSQL command line. Please note that if you want to specify any particular SQL\ninstance, you need to use the appropriate SQLCMD switches. For example: sqlcmd\n-SServerName\\InstanceName<\/em>.<\/p>\n\n\n\nStep 5:<\/strong> Here you need to create a new\nuser and password using the T-SQL<\/strong> (Transact-SQL<\/em>) commands. Type the command\nCREATE LOGIN\nname WITH PASSWORD=\u2019password\u2019<\/em>. Here, “name” denotes the\naccount name and “password” denotes the new password. You also need\nto use the GO<\/em>\ncommand since you are directly using the T-SQL commands and then hit the Enter<\/strong> button.<\/p>\n\n\n\nStep 6:<\/strong> Now you need to add this\nnewly created user to the System\nAdministrator<\/strong> role using more T-SQL commands. Type the command SP_ADDSRVROLEMEMBER\nname,\u2018SYSADMIN\u2019<\/em>. Note:<\/strong>\nHere, “name” denotes the account name. Then type the command GO<\/em> and\nhit the Enter<\/strong> button.<\/p>\n\n\n\nStep 7:<\/strong> Now exit the SQLCMD command\nline by simply typing the command exit<\/em> and hitting the Enter<\/strong> button. You also need to restart the SQL Server in the\nregular mode. To do that, cancel the Single-User mode by simply typing the\ncommand net stop\nMSSQLSERVER && net start MSSQLSERVER<\/em> and then hitting the Enter<\/strong> button. When you see the message \u201cThe SQL Server <MSSQLSERVER> service\nwas started successfully\u201d<\/em>, you can then close the Command Prompt<\/strong>. <\/p>\n\n\n\nStep 8:<\/strong> Now launch Microsoft SQL Server Management Studio<\/strong>\nusing the SQL authentication and login as the new user you have created\nearlier. Click Connect<\/strong>.<\/p>\n\n\n\nStep 9:<\/strong> Under the Object Explorer<\/strong> section, click Security<\/strong> ><\/strong> Logins<\/strong>. You will\nsee the newly created account in the list. The SA account is also listed there.\nRight-click it and select Properties<\/strong>.\n<\/p>\n\n\n\nStep 10:<\/strong> On the System Administrator Properties<\/strong> window, enter a new password and\nconfirm it by entering the same password again. Then click OK<\/strong> and close the properties window. <\/p>\n\n\n\nIn this way, you can reset SA password in SQL Server\nsuccessfully. There are a few more manual methods by using which you can reset\nSA password in SQL Server: <\/p>\n\n\n\n
Use OSQL utility in the command prompt<\/li> Use the Plesk interface (condition applied)<\/li><\/ul>\n\n\n\n<\/span>Use OSQL Utility to Change SA Password<\/span><\/h3>\n\n\n\nAre you familiar with the OSQL utility? It is a\ncommand-line tool for SQL Server available with 2000 and later versions. Follow\nthe steps shown below to use the OSQL utility:<\/p>\n\n\n\n
Step 1:<\/strong> First, open the command prompt\nin the administrator mode. Now you need to list the SQL Server instances.<\/p>\n\n\n\nNote:<\/strong> Please note that the OSQL\nutility may not receive a response from all the servers in a timely manner just\nbecause of the broadcasting nature on networks. As a result, the list of the\nservers returned might be different for each invocation. So if the command is\nnot displaying any server, you should try to execute it again.<\/p>\n\n\n\nStep 2:<\/strong> Now you need to type a\ncommand (shown in the screenshot) specifying an SQL Server instance for which\nyou want to reset the password. After typing the command, hit the Enter<\/strong> button. Note:<\/strong> Replace **** with the new password.<\/p>\n\n\n\nIn case if there is a remote Microsoft SQL Server\ninstance being used, you need to use its remote server name or IP address:<\/p>\n\n\n\n<\/span>Use Plesk Interface to Reset SQL SA Password<\/span><\/h3>\n\n\n\nIn case you do not know what actually Plesk is, it is\na commercial web hosting platform having a control panel. It helps server\nadmins set up new websites, email accounts, reseller accounts, and DNS entries\nusing a web-based interface. If the Microsoft SQL Server instance has been\nregistered in Plesk, you need to follow the steps shown below:<\/p>\n\n\n\n
Step 1:<\/strong> On the Plesk<\/strong> interface, go to Tools\n& Settings<\/strong> ><\/strong> Database Servers<\/strong>.<\/p>\n\n\n\nStep 2:<\/strong> On the Tools & Settings<\/strong> window for Database Servers<\/strong>, click the hostname of an SQL Server instance\nwhose password you want to change.<\/p>\n\n\n\nStep 3:<\/strong> Click Change Password<\/strong>.<\/p>\n\n\n\nStep 4:<\/strong> Enter a new password and\nconfirm it by entering the same password. Click OK<\/strong> to save the changes you have made.<\/p>\n\n\n\n<\/span>Professional\nSolution to Recover SQL SA Password<\/span><\/h4>\n\n\n\nIf you cannot use the above manual methods to reset SA\npassword in SQL Server, you should consider using a professional SQL Password\nRecovery tool. Unlike the manual methods, it is an automated and cost-effective\nsolution to recover SQL SA password. There are many software vendors in the\nonline marketplace that provide such password recovery solutions, and Aryson is\none of them. The SQL Password Recovery tool provided by Aryson allows you to\nremove the old password without knowing it and reset SA password in SQL Server.\nIt supports unlocking both the user accounts and SA accounts.<\/p>\n\n\n\n
This software uses an advanced algorithm to unlock\nboth encrypted and unencrypted passwords without causing any damage to the original\nMDF (master.mdf) file. It can also recover multilingual passwords with ease.\nThe SQL Password Recovery tool supports all major versions of Microsoft SQL\nServer including the latest 2019. It is available with the free demo version\nthat will only allow you to see the list of the users (both normal users and\nsystem administrators). To reset SA password in SQL\nServer, you need to purchase the licensed version of this software.<\/p>\n\n\n\n
<\/span>How to Change or Reset SQL Server SA Password?<\/span><\/h4>\n\n\n\nThe SQL Password Recovery tool is an easy-to-use application that requires no prior technical knowledge. To use this software, download it from the official website of Aryson and then install it on your system. The installation is also very simple, and it does not take much time. Once you have successfully installed the software, double-click it and follow the steps shown below: <\/p>\n\n\n\n
<\/span>Steps to Reset SQL SA Password Successfully <\/span><\/h4>\n\n\n\nStep 1:<\/strong> On the home screen of the SQL Password Recovery<\/strong> tool, click the Browse<\/strong> button to select the MDF file. <\/p>\n\n\n\nStep 2:<\/strong> On the Open<\/strong> dialogue box, select the MDF file (master.mdf) and click Open<\/strong> to confirm.<\/p>\n\n\n\nStep 3:<\/strong> The selected MDF file will\nbe listed in the edit box. The software will auto-detect the version and the\nbuild version of the MDF file. Now select the desired user from the user list. <\/p>\n\n\n\nStep 4:<\/strong> In case you want to reset SA\npassword in SQL Server, select SA<\/strong> in\nthe list. Or to reset user password in SQL Server, select the desired user in\nthe list.<\/p>\n\n\n\nStep 5:<\/strong> Now enter the new password\nfor the SA account or any other user account you have selected in the previous\nstep. Finally, click the Change Password<\/strong>\nbutton.<\/p>\n\n\n\nStep 6:<\/strong> Within a couple of seconds,\nthe password will be changed. Click OK<\/strong>\nand close the software application.<\/p>\n\n\n\nBelow is the working video of SQL password recovery\ntool:<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.arysontechnologies.com\/blog\/wp-content\/uploads\/2020\/03\/sql-password-step-1.png\")
<\/figure>\n\n\n\n