Re: Windows Services Groups

Hari,

I have copied the content for your convenience.

************************************************************************************************************************
sp_denylogin (T-SQL)

Prevents a Microsoft® Windows NT® user or group from connecting to Microsoft
SQL Server™.
Syntax

sp_denylogin [@loginame =] 'login'
Arguments

[@loginame =] 'login'
Is the name of the Windows NT user or group. login is sysname, with no
default. If the Windows NT user or group does not exist in SQL Server, it is
automatically added.

Return Code Values

0 (success) or 1 (failure)
Remarks

sp_denylogin can be used only with Windows NT accounts in the form Domain\
User, for example London\Joeb. sp_denylogin cannot be used with SQL Server
logins added with sp_addlogin.

Use sp_grantlogin to reverse the effects of sp_denylogin and allow the user
to connect.

sp_denylogin cannot be executed within a user-defined transaction.
Permissions

Only members of the securityadmin or sysadmin fixed server roles can execute
sp_denylogin.
Examples

This example prevents user Corporate\GeorgeW from logging in to SQL Server.

EXEC sp_denylogin 'Corporate\GeorgeW'



Or

EXEC sp_denylogin [Corporate\GeorgeW]


*************************************************************************************************************

Hope this helps :)

--
Best Regards

Anil Mahadev

http://anilm001.myfreewebs.net/index2.php

http://www.db2india.org

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/200609/1

.

Relevant Pages

  • exec: Search order under Windows
    ... when I call a external executable via the exec command under Windows, ... that Tcl first searches in the directories listed in PATH? ... When attempting to execute an application, ...
    (comp.lang.tcl)
  • Re: exec: Search order under Windows
    ... command first. ... > when I call a external executable via the exec command under Windows, ... > When attempting to execute an application, ...
    (comp.lang.tcl)
  • Re: Permission for Importing data.
    ... database owner to execute xp_cmdshell. ... the SQL Server service is running. ... Microsoft® Windows NT® 4.0 and Windows 2000. ...
    (microsoft.public.sqlserver.dts)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)