How to set SQL Server Password Policy | Set SQL Password Policy
This article demonstrates the steps to create an SQL Server Login which enforces password policies and password expiration policies.
Let us start by creating a new SQL Server Login.
1. Using SQL Server Management Studio, connect to SQL Server Instance.
2. Expand Security, and right click Logins to choose New Login… option from the popup menu to open up Login dialog box as shown in the snippet below.
3. In Login dialog box, you will be able to see checks boxes for Enforce Password Policy and Enforce Password Expiration as highlighted in the snippet below. If you select those check boxes while creating the new SQL Server logins, then the SQL Server will leverage the Windows password policies set by the windows administrator across the organization. Click OK to create the SQL Server Login with Public server role.
Where I will be able to see the Password Policies?
1. Navigate to Start | Control Panel | Administrative Tools | Local Security Policy or Run SECPOL.MSC from Command Prompt.
2. To review the local policies on the machine expand Security Settings | Account Policies | Password Policy as shown in the snippet below.
Trending SQL Server Articles and Tips
- How to Change SQL Server Database Auto Growth Settings
- Improved Startup Parameters in SQL Server 2012
- How to Use SQL Server Configuration Manager
- Database Consistency Checker DBCC CHECK For Analysis Services Database in SQL Server 2016 for Tabular and Multidimensional Databases
- ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016
- Troubleshooting The remote procedure call failed. [0x800706be] WMI Error in SQL Server
- Discover SQL Server Components Installed Using SQL Server Discovery Tool
Enforce Password Policy SQL Server | SQL Server Password Requirements
Logon Error: 18487, Severity: 14, State: 1. Logon Login failed for user 'Login Name'. Reason: The password of the account has expired.
In this article you have seen how to leverage Windows Polices to enforce password policies and password expiration for SQL Server Logins.