Browse by Tags

Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?

Published 29 January 8 1:36 AM | SSQA.net

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...

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

SQL Server logins - enforce Password Expiration and policies

Published 7 January 8 1:11 PM | SSQA.net

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...

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