SQL Account locked out
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:
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