?
Solved

SQL 2012 Security group

Posted on 2015-01-19
11
Medium Priority
?
77 Views
Last Modified: 2015-02-11
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
Comment
Question by:HKFuey
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40557736
How did you add the group? Can you post a screenshot?
0
 

Author Comment

by:HKFuey
ID: 40557822
Group.png
Added new group (where all the rest of my security groups are)
Group Scope: Global
Groupe Type: Security
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40557826
Sorry, I meant how did you add the group in SQL Server.
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:HKFuey
ID: 40557885
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
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 total points
ID: 40557889
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
 

Author Comment

by:HKFuey
ID: 40557900
Same error occurs when just typed in.
0
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 1000 total points
ID: 40557927
Verify in the login screen if "Groups" are checked. I think by default it's only Users and Computers.
0
 

Author Comment

by:HKFuey
ID: 40557934
Done that, same error. Might try a server restart tonight.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 40557953
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
 

Accepted Solution

by:
HKFuey earned 0 total points
ID: 40593309
I still cannot add this new group. I will use an existing security group.
0
 

Author Closing Comment

by:HKFuey
ID: 40602732
Thanks for trying.
Andy
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question