3.3. SECURITY

The security model used by Microsoft SQL Server is described in this section.

3.3.1. Client Program Login to SQL Server

The SQL Server Database Engine does not have a GUI as part of the database server. As shown in Figure 3-11, the only way to communicate with the server process is via a “Client Application” program, or a “client,” such as Query Analyzer, an interactive SQL interface program; Enterprise Manager, a DBA GUI; or any other program written using any of the interfaces previously discussed.

Figure 3-11. Microsoft SQL Server (MSS) Client-Server.

For a client application to connect to SQL Server it must use a login and password ...

Get Transact-SQL Desk Reference 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.