Error 15401 Windows Nt User
Contents |
SERVER - Fix : Error : Error 15401: Windows NT user or group ‘username' not found. Check the name again. June 7, 2007Pinal DaveSQL, SQL Server, SQL Tips and Tricks24 commentsFix : Error : Error 15401: Windows NT user or group error 15401 sql server 2012 ‘username' not found. Check the name again.This is quite a famous error and
Error 15401 Sql Server 2014
I was asked to write about it by couple of readers. The reason I was not writing about this as
Windows Nt User Or Group '\administrators' Not Found.
the solution of this error is very well explained in Book On Line. All the potential causes and their solutions are explained well here. This post/article should be considered as book mark
Msg 15401 Sql Server
to solution.Fix/WorkAround/Solution: Refere Microsoft Help and Support : How to troubleshoot error 15401Reference : Pinal Dave (http://blog.SQLAuthority.com) Tags: SQL Error Messages, SQL Login, SQL Scripts1Related Articles SQLAuthority News - Presenting at Virtual Tech Days TechEd Pre-Con - February 9, 2011 February 7, 2011Pinal Dave SQL SERVER - 2008 - Interview Questions and Answers - Part 6 September 17, 2008Pinal Dave SQL SERVER - Count Duplicate Records sp_revokelogin - Rows July 11, 2007Pinal Dave 24 comments. Leave new Nebu June 8, 2008 5:23 pmpls slove this errorWindows NT user or group ‘username’ not found. Check the name again.Reply David April 13, 2009 4:45 pmHi,I have one suggestion, now that it works for me. I was unable to add a new login for a local windows user on a local sql server just because of case. The Sql Server management studio process would always give my user login like this : AMITY\Dave. In fact, the right case is Amity\Dave.By executing sp_grantlogin "Amity\Dave" it worked fine.Bad GUI tools don't ease the use at all.DavidReply Alice April 30, 2009 12:51 amHi Pinal,I got this err when I tried to manually change the Window group name after the physical server got renamed.After renaming the server, I use sp_dropserver and sp_addserver to bring SQL in sync with the new server name. Then I restart SQL Server. Everything seems to work fine. However, under Security -> Logins there are 3 groups that are prefixed by the old server name and also contain the old server name within their name (for example: oldservername\SQLServer2005SQLAgentUser$oldservername$MSSQLSERVER)Can you please advise how to fix it?I
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the q322988 company Business Learn more about hiring developers or posting ads with us Stack Overflow microsoft sql server reported sql message 15401 severity 16 Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 sp_grantlogin million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Windows NT user or group 'DOMAIN\USER' not found? up vote 4 down vote favorite 2 I am trying to http://blog.sqlauthority.com/2007/06/07/sql-server-fix-error-error-15401-windows-nt-user-or-group-username-not-found-check-the-name-again/ create users on a SQL server from an Active Directory group as an application I am working with does not natively support Windows authentication and relies upon individual logins being created on the SQL server, as application level permissions are managed in the application rather than using SQL roles. Due to this, each user that is to access the application needs their own user creating against the SQL instance that the applications database http://stackoverflow.com/questions/15089617/windows-nt-user-or-group-domain-user-not-found is on, so that the user can then be assigned individual permissions within the application. I am reading the list of users from the Active Directory group we have designated using the following; exec master..xp_logininfo 'domain\groupname', 'members' This returns output similar to the following; account name type privilege mapped login name permission path DOMAIN\USER user user DOMAIN\USER DOMAIN\GROUPNAME For the most part, the users returned in this list can be created on the SQL instance without any drama. I am creating the users as SQL accounts using sp_grantlogin in the first instance, before moving on to allow each new login access to the application database. However, a handful of users are being reported as not existing. I get the following error as a result of running sp_grantlogin; Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49 Windows NT user or group 'DOMAIN\USER' not found. Check the name again. Obviously in the above error message, I have removed the actual username. Why would xp_logininfo return a user that cannot be created with sp_grantlogin? Is there anything obvious that I am missing? sql-server active-directory share|improve this question asked Feb 26 '13 at 12:52 user1451185 support.microsoft.com/kb/324321/en-us –David Brabant Feb 26 '13 at 13:08 the user definitely exists in AD, the potential for the s
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or http://serverfault.com/questions/247780/sql-server-2008-r2-error-15401-when-trying-to-add-a-domain-user posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault http://discussions.citrix.com/topic/339612-windows-nt-user-or-group-domainuser-not-found-check-the-name-again-microsoft-sql-server-error-15401/ is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL Server 2008 R2 Error 15401 when trying to add a domain user up vote 6 down vote favorite I am trying sql server to add a domain user. I am doing the following. Expand Security Right click on Logins Select New Login... Login name select search Click on location and select entire directory Type username Click checkname The name goes underlined and add some more info Click OK Click OK I then get the following error: I have found http://support.microsoft.com/kb/324321. The Login does exist There is no Duplicate security identifiers Authentication failure I don't think is happening as I can browse AD Case sensitivity should 15401 sql server not be the problem as I am doing the checkname and it is correcting it. Not a Local account Name resolution again I can see the AD I have rebooted the server (VM) and the issue is still happening. Any ideas? Edit I have also: Domain member: Digitally encrypt secure channel data (when possible) – Disable this policy Domain member: Digitally sign secure channel data (when possible) – Disable this policy Rebooted server http://talksql.blogspot.com/2009/10/windows-nt-user-or-group-domainuser-not.html Edit 2 I have also: Digitally encrypt or sign secure channel data (always)- Disabled Rebooted Edit 3 Since the question have moved site I no longer haves access to comment etc... I have checked the dns on the server to a machine where it is working. The DNS servers are the same on both... sql-server sql-server-2008 sql share|improve this question edited Mar 16 '11 at 11:00 splattne 23.8k1685138 asked Mar 15 '11 at 16:46 Alice migrated from stackoverflow.com Mar 15 '11 at 19:24 This question came from our site for professional and enthusiast programmers. Is this a Virtual Machine? –Robert Miller Jul 26 '11 at 1:36 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote Old question but I had the same issue today on SQL Server 2012 (web) when trying to create a login for a domain user, something I've done numerous times before. The issue for me turned out to be the SQL Server agent which had not started up follow
Developer Network (CDN) ForumsCitrix Insight ServicesCitrix ReadyCitrix Success KitsCloud Provider PackCloudBridgeCloudPlatform (powered by Apache CloudStack)CloudPortalDemo CenterDesktopPlayerEdgeSightEducationForum PrototypeHDX MonitorHDX RealTime Optimization PackHotfix Rollup PackJapanese ForumsKnowledge Center FeedbackLicensingLTSRNetScalerNetScaler E-Business CommunityNetScaler Gateway (Formerly Access Gateway)Profile ManagementProof of Concept KitsProvisioning ServerQuick Demo ToolkitReceiver, Plug-ins, and Merchandising ServerSecure GatewayShareFileSingle Sign-On (Password Manager)SmartAuditorStoreFrontTechnology PreviewsTrial SoftwareUniversal Print ServerUser Group CommunityVDI-in-a-BoxWeb InterfaceXenAppXenClientXenDesktopXenMobileXenServer Discussions Support Forums Products XenApp XenApp 6.5 for Windows Server 2008 R2 Installation Javascript Disabled Detected You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality. Windows NT user or group 'Domain\User' not found. Check the name again. (Microsoft SQL Server, Error: 15401) Started by Siyamand Rashid , 01 November 2013 - 06:37 AM Login to Reply 2 replies to this topic Siyamand Rashid Members #1 Siyamand Rashid 67 posts Posted 01 November 2013 - 06:37 AM hi all i have test lab for xenapp , and i prepared a windows server 2008 r called DB01 which is joind to a domain called MyDomain,on this server (DB01.MyDomain.local) i installed SQL Server 2008, now after i created a database and want to add users from the AD im getting this error below :Windows NT user or group 'Domain\User' not found. Check the name again. (Microsoft SQL Server, Error: 15401)why this happened ?Regards Attached Files 01-Nov-13 6-54-44 PM.png 75.36K 26 downloads 01-Nov-13 8-52-09 PM.png 37.78K 26 downloads 1302-339612-1775592 Back to top Joseph Rich Members #2 Joseph Rich 641 posts Posted 01 November 2013 - 06:19 PM Are you logged in as a local user or domain user? If you are logged in as a local user you will not be able to add Domain accounts to SQL server. You must log in as a Domain User that has local administrator rights to the SQL server, open SQL server Management Studio as that Domain user and then you can add Domain users to SQL server. 1302-339612-1775742 Helpful Answer Back to top Siyamand Rashid Members #3 Siyamand Rashid 67 posts Posted 02 November 2013 - 07:42 PM the pr