Monday, June 3, 2013

Change Password of the sa user in MS SQL server

USE [master]

GO

ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON

GO

USE [master]

GO

ALTER LOGIN [sa] WITH PASSWORD='password@123' MUST_CHANGE

GO

No comments:

There was an error in this gadget