How to Unlock SQL Server Account
Have you lost or forgotten your SQL Server login? Are you unable to access your SQL Server account? If you are an individual user in the SQL Server, you can contact your SA (system administrator) to reset a new password for you. But if you...
Method 1 of 4:
Using the Command Prompt
-
Picture 1 of How to Unlock SQL Server Account Press Win+R and type cmd. Hit enter. The Command Prompt will be appeared. -
Picture 2 of How to Unlock SQL Server Account Run Osql –S ComputerName –E command and hit enter. -
Picture 3 of How to Unlock SQL Server Account Now run EXEC sp_password NULL, 'NewPassword', 'sa' and hit enter. -
Picture 4 of How to Unlock SQL Server Account Type Go to make it done. Now you can log into your SQL Server by using the new password.
Method 2 of 4:
Using SQL Management Studio
The SQL Server password can be changed in Management Studio by using Windows Authentication.
-
Picture 5 of How to Unlock SQL Server Account Log into your SQL Server by using Windows Authentication. In the Management Studio. -
Picture 6 of How to Unlock SQL Server Account Expand Object Explorer and open the Security folder. -
Picture 7 of How to Unlock SQL Server Account Now expand the Logins folder, right click on SA account and click on Properties. -
Picture 8 of How to Unlock SQL Server Account Type a new SA password and confirm it. Then click on OK.
Method 3 of 4:
Using SQL Script
-
Picture 9 of How to Unlock SQL Server Account Open SQL Server Management Studio to change the SQL Server password by using SQL Script. -
Picture 10 of How to Unlock SQL Server Account Open a New Query and write the query given in the image shown. Execute it.
Method 4 of 4:
Using Third Party Software
- Try a third-party tool to unlock the SQL Server accounts (system administrator as well as individual). Search online for reviews of suitable software.
Update 05 March 2020
You should read it
- Method in HTTP
- Use Web browser to connect FTP Server
- Load balancing in Web applications (end part)
- How to Create a Minecraft Server Using Hamachi
- The difference between web server and app server
- Network basics: Part 3 - DNS Server
- How to access Linux server from Android
- Encryption in SQL Server 2005
- Backup for Exchange Server with DPM 2007 (Part 1)
- Learn about Gutmann data deletion method
- How to set up your own Git server on Linux
- Exchange Server 2007: ten minutes of instruction
Maybe you are interested
Why the foundation of the world's tallest tower Burj Khalifa must be powered 24/7 Invite to download the space theme wallpapers on the NASA XS inspired by NASA Fix applications in Microsoft Office 2007 18 'extremely creative' inventions are available only in Japan What is most important to men when they are in their 30s? Work more effectively every day with 3 simple actions