Browse by Tags

• authentication
• bol
• books online
• check_expiration
• check_policy
• computing
• feature
• microsoft
• password
• policies
• policy
• security
• settings
• sql authentication
• sql server
• trustworthy
• windows

SQL Server 2005 Login Security - CHECK_POLICY and CHECK_EXPIRATION setting, how it affects the password policy?
30 April 08 01:53 AM | SQL Master | 2 Comments   

Adding password complexity and password expiration to SQL Server logins is one of best feature I quote for SQL Server version 2005 onwards, similarly such password complexity policies are designed to deter brute force attacks by increasing the number Read More...

Filed under: sql server, microsoft, security, best practice, settings, logins, password, check_expiration, check_policy, computing, policies, trustworthy, feature

SQL Server logins - enforce Password Expiration and policies
07 January 08 12:11 PM | SQL Master | 2 Comments   

Here is a quick snippet on enabling a SQL login to password expiration and password policies as per the Windows server: Open the SQL Server 2005 Management Studio. In the left pane, go to the desired server and navigate to the Security folder and expand Read More...

Filed under: sql server, security, windows, authentication, best practice, logins, bol, sql authentication, books online, password, policy