Hi,
I have problem with respect to "alter login" on Windows user groups (created
via Active Directory).
If I execute the statement "alter login [domain\groupname] enable" I get an
exception saying (the exception also occurs with "alter login
[domain\groupname] disable"):
Msg 15151, Level 16, State 1, Line 1
Cannot alter the login of 'domain\groupname', because it does not exist or
you do not have permissions.
If if try to enable the login via SQL Server Management GUI I get the same
exception.
Is this because it is not at all possible to alter the logins of windows
user groups? Or is it a bug in SQL Server?
I am running MS SQL Server 2005 SP1 (compatibility level 90).
The user I am executing the statement as is "sysadmin" on the server.
Thanks in advance.
Kind Regards,
Rune Jensen
ETI
Jasper Smith - 25 Oct 2006 14:57 GMT
AFAIK you can only disable/enable logins that represent individual windows
accounts, not windows groups.

Signature
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
> Hi,
>
[quoted text clipped - 25 lines]
> Rune Jensen
> ETI