USE [master]
GO
ALTER LOGIN [sa]
      WITH CHECK_EXPIRATION=OFF, -- Password will never expired
           CHECK_POLICY=OFF      -- Password do not need to meet the password complexity policy
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'123'
GO