Find Members of Windows User Groups in SS2005 1

[gcoast]

In SS2000 we could go to Security->Right click on Logins->Select New Login...->Click on the search box "..."->Find a user group-> and click the "Members..." box to see all members of a user group.

In SS2005 this has changed and I don't know a way to find the members of a User Group.

Any ideas?

Thanks so much,

gcoast

 

[onpnt]

umm...it hasn't changed. Maybe you don't have groups checked in the search

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[onpnt]

just a bit more detail. Click groups in the object types. And maybe it's due to having to click Advanced. That I think is the only difference but that is a 2003 change. Not SQL Server

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[gcoast]

Thanks for the reply onpnt. I have no problems finding the user groups I just don't see a way to look at the group members anymore.

After drilling down to a user group how do you view the members? There used to be a "members..." button to click.

Thanks,

gcoast

 

[mrdenny]

What OS was your SQL 2000 machine running? I don't remember seeing that since the old NT 4 days.

There are a couple of ways to view domain group membership.

1. Install the admin pack from the Windows 2003 CD. It's in x:\i386\adminpak.msi. That will give you the Active Directory Users and Computers icon in Add Remove Programs (as well as the ADUC MMC snapin) which will allow you to search the network and view group membership.

2. From a command line run:

net group {GroupName} /domain

This will spit out a list of the group members.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[gcoast]

mrdenny, thanks for your help definitely worth a star.

btw I am using Windows XP SP2 client running SS2005 SP2(CTP)