Forum - How to change or reset SQL Server Password?

Jump to: navigation,
Overview > Matrix Access Control & Time-Attendance > Database Related Issues > How to change or reset SQL Server Password?
[#7]

This forum topic shows 2 methods to help you change or reset forgotten SA password for your SQL Server 2000/2005/2008/2012/2014 database installation.

Method 1: Using SQL Management Studio:

  • Login into SQL Server using Windows Authentication.
Login with windows authentication.png


  • In Object Explorer, open Security folder, open Logins folder. Right click on SA account and go to Properties.
Select sa and its properties.png


  • Change SA password, and confirm it. Click OK.
Change sql password.png


Method 2: Using SQL Script

  • Open the SQL Server Management Studio.


  • Open a New Query.
Open new query.png


Copy, paste, and execute the following:

GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword'
GO

where NewPassword is the password you wish to use for the sa account.

SQL Query to reset password.png
Posted by Admin (administrator) on 29 January 2019 at 05:55.
Edited by Admin (administrator) on 29 January 2019 at 06:11.
Retrieved from "https://wiki.matrixcomsec.com/index.php?title=Special:WikiForum/How_to_change_or_reset_SQL_Server_Password%3F"