Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2012 Security group

Posted on 2015-01-19
11
Medium Priority
?
80 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 53

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 53

Expert Comment

by:Vitor Montalvão
ID: 40557826
Sorry, I meant how did you add the group in SQL Server.
0
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

 

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 53

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 53

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 53

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
The article explains the process to deploy a Self-Service password reset portal I developed a few years ago. Hopefully, it will prove useful to someone.  Any comments, bug reports etc. are welcome...
In this Micro Tutorial viewers will learn how to restore single file or folder from Bare Metal backup image of their system. Tutorial shows how to restore files and folders from system backup. Often it is not needed to restore entire system when onl…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

564 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