O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

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

Special Purpose Logins and Users

You configure access to SQL Server using server logins. You can configure various levels of access to these logins:

  • By the roles to which those logins belong.

  • By permitting access to specific databases.

  • By allowing or denying object permissions.

Just as there are two authentication modes, there are also two kinds of server logins. You create domain logins using domain accounts, which can be domain or local user accounts, local group accounts, or universal and global domain group accounts. You create SQL Server logins by specifying a unique login ID and password. Several logins are configured by default, and these include local Administrators, local Administrator, sa, NETWORK SERVICE, and SYSTEM.

To narrow the scope ...

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