Create Failed For Login Sql Server 2008 Error 15401
Contents |
360 games PC games microsoft sql server error 15401 Windows games Windows phone games Entertainment All Entertainment sql server error 15401 administrators Movies & TV Music Business & Education Business Students & educators windows nt user or group not found sql server 2008 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
Q322988
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
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
Sp_revokelogin
Overflow the company Business Learn more about hiring developers or posting ads with us windows nt user or group '\administrators' not found. Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network microsoft sql server reported sql message 15401 severity 16 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 https://support.microsoft.com/en-us/kb/324321 R2 Error 15401 when trying to add a domain user up vote 6 down vote favorite I am trying 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: http://serverfault.com/questions/247780/sql-server-2008-r2-error-15401-when-trying-to-add-a-domain-user 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 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 comme
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar http://www.sqlservercentral.com/Forums/Topic448782-146-1.aspx Who's On Home » SQL Server 2005 » Administering » Microsoft SQL Server Error: 15401 Microsoft SQL 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 sql server a new instance of SQL 2005 x64 running on 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 sql server 2008 problem I'm having currently is that when I try to add our Extranet 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 admi