hi I tried set SA and PSW its working great to change the password. The password has changed but when I tried to login it is asking new psw and can't login. getting error 18464.
ALTER LOGIN [sa] WITH CHECK_EXPIRATION=ON
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO