MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
3 4
Chapter 10
About This Chapter
Before you place your SQL Server 2000 database into production, you must configure security to permit appropriate access for users and administrators. In this chapter, you will learn how SQL Server 2000 controls access to the server itself. Next, you will learn how SQL Server 2000 controls access to databases, including an introduction to server-wide and database-level permissions. Finally, you will learn to create security accounts (logins) for users using Windows authentication and SQL Server authentication.
Before You Begin
To complete this chapter, you must have
- A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1, "Hardware Requirements," in Lesson 1 of Chapter 2.
- Microsoft Windows 2000 Server running on your computer on an NTFS partition.
- A computer with a NetBIOS name of SelfPacedCPU, configured as a domain controller in the SelfPacedSQL.MSFT domain.
- Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2).
- Created the SSEMDB database using the CreateDB.sql script (see Chapter 6) .