SQL instance logins

• Niyala

  SSCrazy

  Points: 2778

  More actions

  March 16, 2009 at 7:32 am

  #132254

  Hi all,

  I have a login group account in which 5 people are members of. The account has sysadmin fixed server role. However, I would like to remove only one member from the group account and leave all others intact. Is there a way to remove exactly that member from the group?

  Thanks for your hint

  Niyala

• Mohit K. Gupta

  SSChampion

  Points: 12130

  More actions

  March 17, 2009 at 12:09 am

  #960816

  I am taking a guess it is an Active Directory group... So in Active Directory remove that person from the group and they will not be able to access it then :).

  Thanks.

  [font="Arial"]---

  Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
  Microsoft FTE - SQL Server PFE

  * Some time its the search that counts, not the finding...
  * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

  How to ask for help .. Read Best Practices here[/url].