SQL 2000: sp_dropuser fails for group login

[web4fun]

SQL 2000 Server:

Problem: Trying to use 'sp_dropuser' stored procedure to drop users from a database and I am encountering the following error when attempting to drop a Domain group login from the database:

"User 'groupA' does not exist in the current database."

I can see that it indeed does exist in the database not only via Enterprise Manager but also when I issue 'sp_helpuser' I see:

UserName - 'groupA' with LoginName - 'Domain\groupA'

'sp_dropuser' works with non-group domain logins just fine so it must be an issue with removing the group. Anyone know why this is failing???

Thanks in advance.

 

[JayKusch]

OK ... easy question first ...

are you in the correct DB?

As in ... do you have a command like

USE [MyDatabase]

exec sp_dropuser 'targetUser'

I am sure you are setting the DB in the EM server drop down menu BUT ... I want to be sure.

Thanks

J. Kusch

 

[web4fun]

Jay,

Yes, I am in the correct db. Thanks.

 

[JayKusch]

What happens when you try to ADD the user (even though we can see him in the DB)?

Thanks

J. Kusch

 

[web4fun]

Hey Jay,

When I attempt to run 'sp_adduser' for this domain group I encounter a similar error as when I try 'sp_dropuser'

"The login 'DOMAIN\groupA' does not exist" even though in the 'Security' folder for the server logins, I see 'DOMAIN\groupA' defined as a valid login with a mapping to the database.

It's got to be a domain group login issue vs. just a domain user login which works fine with both 'sp_dropuser' and 'sp_adduser'

Thanks.