O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

An Overview of SQL Server's Security Model

SQL Server's security model comprises the following components:

  • SQL Server login

  • Database user

  • guest user

  • Permissions

  • Roles

SQL Server Login

The SQL Server login model supports two security modes:

  • Windows Authentication

  • SQL Server and Windows (Mixed Mode)

CAUTION

By default, the sa account is not password protected! After installing SQL Server, I recommend immediately changing the sa password.

Windows Authentication

Windows Authentication takes advantage of Windows 2000 user security and account mechanisms. This security mode allows SQL Server to share the username and password used for Windows 2000 and allows the user to bypass the SQL Server login process. Users with a valid Windows 2000 account can log ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required