Change the password of SqlServer
This is the common problem of new learner and programmer how to change the password of the SQL server in any version. Sometimes they forget the old password and don't know how to set the new password in SQL server. we can change the password using the wizard or
also using the SQL query. here I am shown you both method to for change the password in SQL server.
First Method Using Wizard
1. Login using Windows Authentication Mode.
2. Expand Security and Login
3. Right Click on sa User .
sa User is the default user created by the SQL Server
4. Click On properties of sa
5. Change the password and click on ok
Now your password will change and login with new password
Second Method using the Query
This is the common problem of new learner and programmer how to change the password of the SQL server in any version. Sometimes they forget the old password and don't know how to set the new password in SQL server. we can change the password using the wizard or
also using the SQL query. here I am shown you both method to for change the password in SQL server.
First Method Using Wizard
1. Login using Windows Authentication Mode.
2. Expand Security and Login
3. Right Click on sa User .
sa User is the default user created by the SQL Server
4. Click On properties of sa
5. Change the password and click on ok
Now your password will change and login with new password
Second Method using the Query
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'Your new password', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
0 Comments
thank you for your comment