• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 919
  • 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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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