-
Written By Rohan Wiese
-
Updated on December 14th, 2023
How to Change MSSQL User Password
Have you forgotten your MSSQL User Password and want to reset it? If yes, then here is the blog which will guide you to change the MSSQL user password. In this digital era, we impose passwords to make things safe and secure. Sometimes we forget the password, also get confused with their complexity.
MS SQL Server is secured with the passwords to keep users and administrators data unreachable from unauthenticated users. So, let’s check out the methods for resetting the MS SQL user password. Let’s get started and learn how to change the password.
How to Change MSSQL User Password?
Method # 1 Change SQL Server Password in Server Management Studio
- First of all, click on Start and move to MS SQL Server. Open SQL Server Management Studio.
- After that, connect to SQL Server Database Instance by using Windows Authentication.
- Then in Object Explorer, click on Security and go to Logins Object. Right-click on SA User and choose Properties option.
- Enter the New Password and Confirm New Password. Click on the OK button.
Method # 2 Using Command Prompt Method
- Firstly, click on the Windows logo. This will open the Start menu.
- Then, type Command Prompt and wait for the command prompt to appear.
- Now, right-click on the Command Prompt. A drop-down menu will appear.
- After that, click Run as Administrator from the dropdown menu.
- Click Yes when Prompted. It will be a confirmation to open the command prompt.
- Next, enter type the Command “osql –L” and hit Enter.
- Enter the next command with the Server Name. Type OSQL –S server –E. Replace “server” with the server name and click on Enter.
- Create a new password. Type EXEC sp_password NULL, ‘passwor1d’, ‘sa’ “password” is replaced by the password that you want to use and then hit Enter.
- Now, execute the command. Type GO, then click Enter. Type exit, then hit Enter to exit OSQL.
- Finally, try to log-in to SQL Server by using your new password.
Method # 3 Use Configuration Manager (for SQL Server 2012 only)
-
Run Configuration Manager on your computer system and stop the instance of the SQL for which, you are resetting the password.
-
After that, go to Properties on SQL Server Instance and choose Advanced option.
-
Then, add -m in the starting of the line in the startup parameter and click on the OK button.
-
Next, initiate SQL Server Instance and Run the Command Prompt.
-
After that, type sqlcmd and press Enter.
-
Now, one can add a new or existing SQL account in the Systemadmin server role.
-
Run command T-SQL and replace DOMAIN/Username with the account to be added.
Change SQL Server Password with Professional Tool
Well, if you are still facing issue while changing the SQL Server password, then you must go for the Aryson SQL Password Recovery Tool. It is professional software that changes your lost password within seconds. You can set a new password without any hassle.
The software allows users to change passwords from all types of protected or encrypted SQL Server database and reset SA Password in SQL Server. All you need to do is to upload the master.mdf file from your system, then you can select the user name and reset the password. In addition to this, the utility can reset the multilingual password of the SQL Server database MDF file.
The tool has the ability to change both the User and Admin password from the SQL master .mdf file. It comes up with a Demo Version that allows you to evaluate the software.
Final Words
The above blog has described the various techniques to change the MSSQL user password. After trying all the manual solutions mentioned-above, if still, you are unable to reset your password then I would recommend you trying SQL Password Recovery tool. It is the best solution for changing the MSSQL Server Password.
About The Author:
Rohan Wiese is a Technical Writer at Aryson Technologies. He is an expert Email Forensic, Cloud Computing, and a passionate nerd with over 10 years of experience in technical content writing. He writes about Cloud Migration, Database Recovery, Email Backup, Windows, Mac, and Tech.
Related Post
