Recent

6/recent/ticker-posts

Header Ads Widget

Change the password in SqlServer

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.
Change the password in SqlServer

2. Expand Security and Login
Change the password in SqlServer

3. Right Click on sa User .
sa User is the default user created by the SQL Server


Change the password in SqlServer
 4. Click On properties of sa
Change the password in SqlServer


5. Change the password and click on ok
Change the password in SqlServer

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

Post a comment

0 Comments