Sql 2008 disable windows password policy

Applies to: SQL Server all supported versions. SQL Server can use Windows password policy mechanisms. The password policy applies to a login that uses SQL Server authentication, and to a contained database user with password. SQL Database enforces password complexity. The password expiration and policy enforcement sections do not apply to SQL Database. Password complexity policies are designed to deter brute force attacks by increasing the number of possible passwords.

When password complexity policy is enforced, new passwords must meet the following guidelines:. Non-alphanumeric characters such as: exclamation point! Passwords can be up to characters long. Use passwords that are as long and complex as possible. Password expiration policies are used to manage the lifespan of a password. United States English. Ask a question.

Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. SQL Server Express. Sign in to vote. With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.

Who are the certified experts? How quickly will I get my solution? We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge.

Our experts volunteer their time to help other people in the technology industry learn and succeed. Plans and Pricing.