tailieunhanh - Wiley - Microsoft SQL Server 2008 For Dummies (2008)02

Wiley - Microsoft SQL Server 2008 For Dummies (2008)02 | Chapter 2 Building Your SQL Server 21 Microsoft strongly recommends the use of Windows authentication mode as a security best practice. Using this approach you maintain a single set of accounts for both server and database access and errors are much less likely to occur. You should use mixed authentication mode only if you have a specific requirement for it in your organization such as an application that doesn t support Windows authentication. Choosing service accounts During the installation process you ll be asked to choose service accounts for several SQL Server services. Every program in Windows must run using the permissions of an account when you make this decision you re choosing the account s that will be used to run SQL Server and its components. For security reasons I strongly recommend that you ask your domain administrator to create dedicated domain accounts for the SQL Server Agent and SQL Server service accounts. These accounts should be configured with the minimum permissions necessary to run their respective services and should not be used for any other purpose. Selecting the collation Collations define how SQL Server stores and sorts data. They differ based upon the character set used in different parts of the world. Some common collations include Latin1_General collation for English and German Arabic collation for Arabic languages French collation for French Modern_Spanish collation for Spanish SQL Server Setup will choose a default collation for you based upon the settings of the underlying Windows operating system. In general you should not change this default unless one of the following situations exists The database collation must support a different language than that of the underlying operating system. For example you might have a server hosted in one country supporting a database server used by individuals in another country. The database server participates in a replication relationship with another server that uses a different collation.