Microsoft Sql Server Error 15401 Solution
Contents |
360 games PC games sql server 2012 error 15401 Windows games Windows phone games Entertainment All Entertainment
Windows Nt User Or Group Administrators Not Found Check The Name Again
Movies & TV Music Business & Education Business Students & educators error 15401 sql server 2014 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet msg 15401 sql server Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All
Sp_revokelogin
Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
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 q322988 user or group ‘username' not found. Check the name again.This is quite a microsoft sql server reported sql message 15401 severity 16 famous error and I was asked to write about it by couple of readers. The reason I was not
Sp_grantlogin
writing about this as 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 https://support.microsoft.com/en-us/kb/2770837 considered as book mark 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 SQL SERVER - Getting started and creating JSON using SQL Server 2016 June 29, 2015Pinal Dave SQL SERVER - FIX – Error: 905, Severity: 21, State: 1 - Database ‘xxx’ cannot be started 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/ in this edition of SQL Server because it contains a partition function ‘xxx'. February 20, 2015Pinal Dave SQL SERVER - Service Pack Error - The User Data directory in the registry is not valid. Verify DefaultData key under the instance hive points to a valid directory May 16, 2015Pinal 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 th
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL http://www.sqlservercentral.com/Forums/Topic448782-146-1.aspx Server 2005 » Administering » Microsoft SQL Server Error: 15401 Microsoft SQL http://stackoverflow.com/questions/15089617/windows-nt-user-or-group-domain-user-not-found Server Error: 15401 Rate Topic Display Mode Topic Options Author Message Glenn OwensGlenn Owens Posted Tuesday, January 29, 2008 5:52 AM SSC Journeyman Group: General Forum Members Last Login: Tuesday, March 15, 2016 4:22 PM Points: 99, Visits: 342 I've a new instance of SQL 2005 x64 running on sql server Windows 2003 R2. The SQL instance is intended as back-end support for Sharepoint WSS 3.0 Extranet traffic. The SQL instance is behind our firewall in one domain while the WSS Extranet is in a DMZ within another domain. I've successfully done this before with SQL 2000 and WSS 2.x.The problem I'm having currently is that when I try to add our Extranet microsoft sql server support login to the SQL Instance I get the following error: Create failed for Login 'domain\login-name'Windows NT user or group 'domain\login-name' not found. Check the name again. (Microsoft SQL Server, Error: 15401)o The SQL Server can ping the DMZ Domain Controller (and can be pinged from the DMZ Domain Controller.o I can add the target DMZ windows account to the SQL Servero I can add logins from other (and local) domainso The collation sequence on the SQL Instance is: SQL_Latin1_General_CP1_CI_ASo I've checked for duplicates in the master..syslogins (clean)I've looked around on the web and found others having this issue but no definitive answer. Any help would be gretly appreciated!Glenn Post #448782 Glenn OwensGlenn Owens Posted Tuesday, January 29, 2008 8:36 AM SSC Journeyman Group: General Forum Members Last Login: Tuesday, March 15, 2016 4:22 PM Points: 99, Visits: 342 Finally an answer!!!Here's my solution:o On the SQL Server - add the cross-domain account as a local administratoro Log on to the SQL Server using the new cross-domain accounto Add the SQL Login for the cross-domain (using the SQL GUI, CREATE LOGIN, or s
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 posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 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 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 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 th