tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P37

Microsoft SQL Server 2008 R2 Unleashed- P37:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 314 CHAPTER 11 Security and User Administration With Windows Authentication you have an option to restrict access to the server for the new login when it is created. If you select Deny Server Access a command to deny access to SQL Server is issued immediately after the login is created for example DENY CONNECT SQL TO DBSVRXP Chris . This option can be useful for staging new logins and waiting until all the appropriate security has been applied prior to allowing the login to access your SQL Server instance. After you completing the security setup for the login you can select the login properties and choose the GRANT SERVER ACCESS option. You can use the same new login screen shown in Figure to add a login with SQL Server Authentication. Again you need to provide a login name but with the standard SQL Server login there is no domain associated with the user. The login is independent of any Windows login and can be named as desired. The login and password for SQL Server Authentication are stored and maintained in SQL Server. When SQL Server Authentication is selected several options related to passwords are enabled. These options as shown in Figure include Enforce Password Expiration Enforce Password Policy and User Must Change Password at Next Login. These options are all associated with a more rigid password policy. They are similar to options available with Windows accounts and provide a more robust security solution for SQL Server logins. The catch is that the new password options are enforced only on the Windows 2003 Server operating system and versions above. You can select these options when running SQL Server on a machine that has an operating system that is lower than Windows 2003 Server but the hooks between SQL Server and the operating system are not in place to enforce the password policy. FIGURE Creating a login in SSMS with SQL Server Authentication. Download from Managing SQL Server Logins 315 The next set of options on .