How to change password SQL SERVER 2012 | 2014 | 2016 | 2019

 How to change password  SQL SERVER  2012 | 2014 | 2016 | 2019 

Change SQL Forgetted Password only in two steps 

1. Using SQL  Query 

2. Change SQL Server Password from Login window Authenticate(SQL Setting)

1.  Change SQL Server 2016 Password in 3 steps   Using SQL Server Setting

•         Open SQL Server window Authenticate
•         Go - Security - logins - Select User like Sa
•         Enter Password and Confirm password
•         Go SQL SERVER Property - Security -Select Server Authentication and login               Auditing
•         Restart SQL Server 
•         Login using SQL Server Authenticate 

2. Change SQL Server Password Using SQL Query

• Login SQL Server with Window Authentication        
• Open-Security-Logins-Sa Account (Double click)
• Mark on both (A) Enforce Password Policy & (B) Enforce Password Expiration

    Note:- If Done This then Below query in SQL server

     Query:-

GO ALTER LOGIN [Enter Your User Name] WITH DEFAULT_DATABASE=[master] GO USE [master] GO ALTER LOGIN [Enter Your User Name] WITH PASSWORD=N'NewPassword' MUST_CHANGE

If showing any Error then you can leave a Comment.........

SQLSTDLTD2019

Share on Google Plus

About Pawar Live Study

Search Your Query in Search Box.