SQL Server Security Model

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

SQL Server Security Model
Document ID : 000-000848 Created: 1/19/2004 Last changed on: 1/19/2004

To login to MS SQL server you need to go through at least 3 security layers:

*- Network connection request to SQL server (your PC can connect to the network and the SQL computer)

*- Login authentication request to SQL server (you can access the SQL server computer)

*- Login to the database and tables. (you can access the database and tables and have rights to process information)

See also : sp_grantlogin (Allows a Microsoft� Windows NT� user or group account to connect to Microsoft SQL Server� using Windows Authentication.)

See also: Enterprise Manager. SECURITY tab of the SQL server. Here you can add individual users or groups (if under a domain) to the authorized to login to SQL server.

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.