Solved

SQL 2012 Security group

Posted on 2015-01-19
11
71 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
  • 6
  • 5
11 Comments
 
LVL 47

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 47

Expert Comment

by:Vitor Montalvão
ID: 40557826
Sorry, I meant how did you add the group in SQL Server.
0
Does Powershell have you tied up in knots?

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

 

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 47

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 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 47

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This article runs through the process of deploying a single EXE application selectively to a group of user.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

803 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