How to deny login access to a Windows user or group (Enterprise Manager)

SQL Server Setup Help

SQL Server Setup Help

How to deny login access to a Windows user or group (Enterprise Manager)

To deny login access to a Windows NT 4.0 or Windows 2000 user or group

  1. Expand a server group, and then expand a server.

  2. Expand Security, and then click Logins.

  3. In the details pane, right-click the Microsoft® Windows NT® 4.0 or Windows® 2000 user or group to deny, and then click Properties.

  4. Under Authentication, click Deny access.

See Also

Denying Login Access to Windows NT Accounts

How to grant a Windows NT user or group login access to SQL Server (Enterprise Manager)