Chapter 10 -- Managing Access to SQL Server 2000

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


MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
ISBN: N/A
EAN: N/A
Year: 2001
Pages: 126

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net