Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 82
  • Last Modified:

SQL 2012 Security group

I created a security group on my DC, 'SQL_Read' then added some users. I try to add the group on my SQL server and get error 15401 "User or Group not found'
Tried suggestions here: - http://support.microsoft.com/kb/324321/en-gb
Still stuck, can anyone help?
0
HKFuey
Asked:
HKFuey
  • 6
  • 5
3 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
How did you add the group? Can you post a screenshot?
0
 
HKFueyAuthor Commented:
Group.png
Added new group (where all the rest of my security groups are)
Group Scope: Global
Groupe Type: Security
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sorry, I meant how did you add the group in SQL Server.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
HKFueyAuthor Commented:
Logged in as sa, Security/Logins/New Login/Windows Authentication.

Searched for object type 'Group' looking in Entire Directory. I typed part of the name, then clicked 'Check Names', 2 groups were listed, I selected the one I have just created. Set the default database.

Click OK gives the error: "Windows NT user or Group not found, check the name again. (error 15401)
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok. Looks like somewhere in the process you might lost the domain name.
Try to add it manually the DomainName\GroupName instead of searching for it.
0
 
HKFueyAuthor Commented:
Same error occurs when just typed in.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Verify in the login screen if "Groups" are checked. I think by default it's only Users and Computers.
0
 
HKFueyAuthor Commented:
Done that, same error. Might try a server restart tonight.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm not sure about the server restart but also ran out of ideas.
I'll wait for your feedback and see if you got good news.
0
 
HKFueyAuthor Commented:
I still cannot add this new group. I will use an existing security group.
0
 
HKFueyAuthor Commented:
Thanks for trying.
Andy
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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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