SQL2012密码老是过期,本来昨天还好好地,今天就不行了~那么我在网络查询,用一段脚本解决~
ALTER LOGIN sa WITH PASSWORD = '<password>' unlock, check_policy = off, check_expiration = off ;
然后重启sqlserver 服务就行~
SQL2012密码老是过期,本来昨天还好好地,今天就不行了~那么我在网络查询,用一段脚本解决~
ALTER LOGIN sa WITH PASSWORD = '<password>' unlock, check_policy = off, check_expiration = off ;
然后重启sqlserver 服务就行~