• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 922
  • Last Modified:

Can't Add Active Directory group to SQL Server database

I have a SQL Server 2005 DB and I like to add a Active Directory group to the database. When I select to add a new user and select login and browse, my Active Directory group that I just created does not show up to be selected. How can I make this happen, so I can add the group to the DB?
0
gtrapp
Asked:
gtrapp
  • 3
  • 3
1 Solution
 
Malli BoppeCommented:
Give few minutes before it is updated on all DC's.Also is Sql server part of the domain.
0
 
gtrappAuthor Commented:
Yes, its part of the domain. Should I try typing in the group name? There are other AD groups that have been around for a while, but SQL Server does not seem to find them. Maybe I am browsing wrong, when trying to add a new login/user.
0
 
Malli BoppeCommented:
when adding a group make sure that you have selected the domainname instead of the local computer.
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
gtrappAuthor Commented:
I have selected the domain. Even my gtrapp is not found. The only type of objects that can be searched on is logins. I have another server where there are some AD groups showing up where I can select from, but on this new server, they don't appear. Why is that?
0
 
gtrappAuthor Commented:
I needed to add the AD Group to the SQL Server first, then add the Group to the DB.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now