Sql-server – Changing sa password

sql server

I'm trying to change the password of the sa account using SQL Server Management Studio 2012. I've followed the steps below but the password is still the same.

  1. Login into the SQL Server Management Studio, Select Database Engine, \SBSmonitoring, Windows Authentication.
  2. Go to Object Explorer–Security folder–Logins folder.
  3. Right click on SA account and select the Properties option.
  4. In General Page, change the SA password and confirm it.
  5. In Status Page, change Login to Enabled. Click OK to save the change.
  6. Restart the SQL Server and all its services.

Any idea ?

Best Answer

use this query it will change sa password 

GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'newpassword' 
GO
Related Question