To deny login access to a Windows NT user or groupWhen a Microsoft® Windows NT® user belongs to a Windows NT group that has a login account in Microsoft SQL Server™, the user is allowed to connect through the group login. However, there may be times when you must ensure that a Windows NT user, or members of a Windows NT group, are prevented from connecting to SQL Server. You can deny login access to any Windows NT user or group. Users cannot connect to SQL Server if their user account, or any group in which they are a member, has been denied login access.
To deny login access to a Windows NT user or group
