While working on SQL (see my previous post…) we of course got locked out…

I found a post that helped! (Thanks Google-fu!)

You can either run this query:

ALTER LOGIN sqluser WITH CHECK_POLICY = OFF;
ALTER LOGIN sqluser WITH CHECK_POLICY = ON;
GO

or via GUI, uncheck the box:

sqluser

 

PS: Dear Vendor, if you are selling a product, please know the ins and outs of the product AND the other products that are needed to get everything to work. Thank you.

Source:

http://www.sqldbadiaries.com/2010/07/21/unlock-sql-user-without-changing-the-password/#ixzz2OBIJCsqv