Managing password policies

- When creating a new SQL Server login account,…you'll have some options to consider…when establishing the account password.…These are controlled…by the computer's local security policy.…So let's take a look at how they affect the creation…of a new user in SQL Server.…In order to get…to the computer's local security policy settings,…we'll come down to the Start button,…and I'll right-click, and choose Control Panel.…Then, we'll go into System and Security,…we'll scroll down and click on Administrative Tools,…then I'll double-click on Local Security Policy.…On the left, I'll go into my Account Policies here,…and find our Password Policy folder here.…

Over on the right, we can see…all the different password policies…that are currently in effect on this computer.…Right here, we can see that we're enforcing…a maximum password age of 42 days.…So after 42 days, the system will force me…to recreate a new password.…Next is the minimum password age.…This is how often you can change your password.…Right now, it's set to zero days, which means…

Resume Transcript Auto-Scroll

Author

Released

11/3/2015

Ongoing, regular administration is critical to the security and performance of databases such as Oracle and SQL Server. It's also a key topic of the Microsoft Technology Associate (MTA) Exam. Whether you're studying to pass the test or simply to keep your admin skills up to date, this course will cover the most current techniques and best practices for administering a database. Adam Wilbert covers the core concepts, including securing the server with user authentication and roles, assigning object-level permissions, and performing a backup and restore. Along the way, he'll provide tips for working with SQL Server Management Studio and some challenges to help you practice what you've learned.

Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.