Unlock sa account

Always use AD accounts now, skip SQL accounts and do not use sa for anything other than whatever you just can’t solve with an AD sysadmin account.

Ok, sa is locked out, you have sysadmin permissions, so you can unlock it with the following.

ALTER LOGIN [sa] WITH CHECK_POLICY = OFF;

ALTER LOGIN [sa] WITH CHECK_POLICY = ON;

Nice huh!

Leave a Reply

Your email address will not be published. Required fields are marked *