Solved

SQL 2012 Security group

Posted on 2015-01-19
11
69 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 45

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 45

Expert Comment

by:Vitor Montalvão
ID: 40557826
Sorry, I meant how did you add the group in SQL Server.
0
 

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 45

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 45

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 45

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

Join & Write a Comment

The reason that corporations and businesses use Windows servers is because it supports custom modifications to adapt to the business and what it needs. Most individual users won’t need such powerful options. Here I’ll explain how you can enable Wind…
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
In this Micro Tutorial viewers will learn how to use Windows Server Backup to create full image of their system. Tutorial shows how to install Windows Server Backup Feature on Windows 2012R2 and how to configure scheduled Bare Metal Recovery backup.…
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now