SQL Security Manager

Definition of SQL Security Manager in The Network Encyclopedia.

Sponsor: Geeky T-Shirt: Blue Screen of Death (Amazon)

What is SQL Security Manager?

A tool in Microsoft SQL Server 6 for managing SQL Server user accounts when you run Integrated Security. You can use SQL Security Manager to automatically copy Microsoft Windows NT user accounts to a server running SQL Server - a simple, one-step process for implementing integrated security on the server running SQL Server. By using this tool, an administrator can grant or revoke SQL Server rights to Windows NT users and groups.

How It Works

SQL Server can validate connection attempts by using three different security modes:

  • Integrated security:
    Lets SQL Server use Windows NT authentication methods for validating all network connections. Connections made using integrated security are called trusted connections. Authentication information is stored in the Security Account Manager (SAM) database on Windows NT domain controllers.

     

  • Standard security:
    Lets SQL Server use its own logon validation process to validate all network connections. Connections made using standard security are called distrusted connections. Authentication information is stored in the syslogins table on the server running SQL Server.

     

  • Mixed security:
    Lets SQL Server use either integrated security or standard security.

     

See also: