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, ...
Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
