Thursday, January 12, 2012

Add a domain group to SQL Server Logins

You may notice that by default you can add domain user accounts but not security groups to SQL Server logins.
To grant permission to a group, navigate from the Management Studio to Security -> Logins, right click -> "New Login", click Search button next to "Login name:", click "Object Types", check "Groups". Now you should be able to resolve group names as well

3 comments:

  1. I was recommended this website by my cousin. I am not sure whether this post is written by him as no one else know such detailed about my problem.

    You are amazing! Thanks!

    Also visit my webpage; hip waist ratio

    ReplyDelete
  2. Magnificent goods from you, man. I've understand your stuff previous to and you're just extremely fantastic.
    I actually like what you have acquired here, certainly like what you
    are saying and the way in which you say it. You make it enjoyable and you still take care of to keep it sensible.

    I can't wait to read far more from you. This is actually a wonderful web site.

    Review my blog - Abercrombie & Fitch

    ReplyDelete
  3. Do you know of any way to change the default so that it is always checked? And why in the world the default is off?

    ReplyDelete