Browse by Tags

• application
• authentication
• bol
• books online
• logins
• password
• policy
• sa password
• security
• sql server
• store
• symmettric keys
• windows
• windows authentication

Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?
29 January 08 12:36 AM | SQL Master | 2 Comments   

The newest ranch of Security - trust worthy features in SQL Server 2005 usage of symmetric keys has an important role. Always the document suggests to use Windows Authentication of security purpose and better control of user/security management, but when Read More...

Filed under: sql server, security, application, best practice, sql authentication, store, sa password, windows authentication, symmettric keys

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