Error 15401 Sql 2008
Contents |
360 games PC games
Error 15401 Sql Server 2012
Windows games Windows phone games Entertainment All Entertainment sql server error 15401 administrators Movies & TV Music Business & Education Business Students & educators
Microsoft Sql Server Error 15401
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet windows nt user or group not found sql server 2008 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 error 15401 sql server 2014 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 user
Msg 15401 Sql Server
or group ‘username' not found. Check the name again.This is quite a famous sp_revokelogin error and I was asked to write about it by couple of readers. The reason I was not writing about
Q322988
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 considered as https://support.microsoft.com/en-us/kb/324321 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 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 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/ - Count Duplicate Records - 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\SQLServer2005SQLAgent
log in tour help Tour 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 http://dba.stackexchange.com/questions/27198/difficulty-creating-logins-on-sql-server-2012-error-15401 Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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 sql server the top Difficulty creating logins on SQL Server 2012 (error: 15401) [closed] up vote 2 down vote favorite I have the following setup A Windows Server 2008 machine as a domain controller [DC] A Windows Server 2008 machine running SQL Server 2012 [SQL-A] [Both machines are virtual and are running on virtual box] I am logged into both machines as CONTOSO\Administrator On the DC I create a global security group named domain_group_b in the Users container. error 15401 sql Similarly I create a user account named domain_user_b. However when I try to create Windows Authenticated logins on SQL Server using these accounts it doesn't work irrespective of whether I use Transact-SQL or SQL Server Management Studio. I get an error Windows NT user or group 'CONTOSO\domain_user_b' not found. Check the name again. (Microsoft SQL Server, Error: 15401) When I use the "Check Names" feature it does find the user and underlines it. Adding local users works OK. Any ideas? sql-server-2012 share|improve this question edited Oct 19 '12 at 12:10 codingbadger 338520 asked Oct 19 '12 at 2:35 Antonio2011a 1234 closed as off-topic by Jon Seigel, Max Vernon, Mike Walsh, Kin, Mark Storey-Smith Nov 19 '13 at 19:27 This question appears to be off-topic. The users who voted to close gave this specific reason:"Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Jon Seigel, Max Vernon, Mike Walsh, Kin, Mark Storey-SmithIf this question can be reworded to fit the rules in the help center, please edit the question. 1 I tried the suggestions in this article, but none of the