O'Reilly logo

Microsoft® SQL Server™ 2005: Applied Techniques Step by Step by Solid Quality Learning

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

Managing Access to SQL Server Instances

When you connect to a SQL Server instance, you must provide valid authentication information. The database engine performs a two-step validation process. First, the engine checks whether you have provided a valid login that has permission to connect to the SQL Server instance. Second, the engine checks whether the login has permission to access the database to which you are trying to connect.

SQL Server 2005 defines Principals as the persons, groups, or processes that request access to database resources. Principals are arranged at Operating System, Server, and Database levels and can be indivisible or a collection. For example, a SQL login is an indivisible principal at the SQL Server instance level, ...

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